Age of computer and form factor Report

[cosp]

Can someone help me with a computer report

I need to get the age of our computers , and if the computer is a laptop or desktop

computer name, bios date, form factor, computer model

[Migration User]

Use the report builder:

1. Reports > All Reports
2. Right-click on a folder and choose New > Report > Computer Report
3. Provide a name and description for the report

4. In the right pane, select the Fields tab to add columns to your report
   Click Add
   In the search field that appears, click 'Select Multiple Fields'
   In the bar at the top, type Release Date and select [BIOS Element].[Release Date] and click Add
   Search for Logical and select [Logical Device].[Model] and click Add
   Search for Chassis and select [Chassis].[Chassis Package Type] and click Add
   Click OK to add these to your report

5. Click Filter Expressions tab, click Add to add the AND condition
   In the first field, type Logical and select [Logical Device].[Description], in the middle field choose Equals, and in the final field type AT/AT Compatible
   Click Save Changes
   This tells the report to only include results for computer inventory data if the Logical Device's description is AT/AT Compatible, i.e., the Logical Device is a computer (and not a printer or a video card or a keyboard, etc).

6. At this point, you have a report which shows computer name, BIOS release date, Computer Model, and Chassis Package Type as a number.  You will now need to convert it to a SQL query report.  (I could have just given you a SQL report, by the way, but it's important you run through these steps to learn how to use the report builder.  I found the right data to select by using the Resource Manager and going to View > Inventory, then expanding the data classes there.  The titles of the sections and columns tell me what I need to select.  The [Chassis] area in the resource manager has the [Chassis Package Type] column, for example.  Using Resource Manager and the Report Builder, you can get a lot done.)

7. Click Edit to edit the report

8. In the top, right-hand corner, click 'Convert this query to SQL Query'

9. Replace the final line of the SELECT statement, which should be the [Chassis Package Type] line, with this text:
    

   Case [Chassis Package Type]

   WHEN 3 then 'Desktop'

   When 7 then 'Desktop'

   When 9 then 'Laptop'

   ELSE 'Unknown'

   END AS 'Desktop or Laptop',

   CASE [Chassis Package Type]

   When 1 Then 'Other'

   When 2 Then 'Unknown'

   When 3 Then 'Desktop'

   When 4 Then 'Low Profile Desktop'

   When 5 Then 'Pizza Box'

   When 6 Then 'Mini Tower'

   When 7 Then 'Tower'

   When 8 Then 'Portable'

   When 9 Then 'Laptop'

   When 10 Then 'Notebook'

   When 11 Then 'Hand Held'

   When 12 Then 'Docking Station'

   When 13 Then 'All in One'

   When 14 Then 'Sub Notebook'

   When 15 Then 'Space-Saving'

   When 16 Then 'Lunch Box'

   When 17 Then 'Main System Chassis'

   When 18 Then 'Expansion Chassis'

   When 19 Then 'Sub Chassis'

   When 20 Then 'Bus Expansion Chassis'

   When 21 Then 'Peripheral Chassis'

   When 22 Then 'Storage Chassis'

   When 23 Then 'Rack Mount Chassis'

   When 24 Then 'Sealed Case PC'

   ELSE 'Other'

   END AS 'Chassis Type'

10. This text tells the numbers how to display.  The first CASE statement is just a sample of how you might use it -- it's up to you to decide what's a 'Desktop' in your environment and what's a 'Laptop' in your environment.  Just add WHEN statements as necessary.
11. Click Save Changes and you should have your report!

Does this help?

[cosp]

mclemson:  Amazingly easy to follow your instructions, a little problem for a rookie

I got lost @

8. In the top, right-hand corner, click 'Convert this query to SQL Query'

Cant find it

[Migration User]

You must be in edit mode to see this section.

This option does not appear if you've already made it into a SQL query.

The top tab must have Data Source selected.  This option does not appear under Views, Report Parameters, Drilldowns, or Advanced.

In the top, right-hand corner you should see the Symantec logo and a search field; below this, a greyed out Edit button (since you're already editing), and below this the blue text 'Convert this query to SQL query'

[cosp]

Strange i cant see the blue text 'Convert this query to SQL query'

[Migration User]

Perhaps, for some reason, it's already a SQL query?  You did click Edit, right?

If it's already converted to a SQL query, you can modify the SQL under the 'Parameterised Query' tab.

If you don't see this tab, can you screenshot what you do see?