How to generate a specific Report

[HHenry]

I am new to Symantec and SQL but have learned to create new reports and canned reports. What is the best way to generate a report that will pull the following information?

Computer name

Serial number

Operating System (WIN7, WIN10, etc.)

Machine Type (desktop, laptop, etc)

[Igor Perevozchikov]

(Original report posted by mjohnsonon (https://www.symantec.com/connect/articles/creating-hardware-chassis-type-view)

Try this modified report below.

SELECT
   aai.[Name] AS [Device Name],
   aai.[Domain],
   aai.[OS Name],
   aai.[Last Logon User],
   Inv_HW_Chassis.[Serial Number],
   Inv_HW_Logical_Device.[Description],
   Inv_HW_Logical_Device.[Device Class],
   Inv_HW_Logical_Device.[Manufacturer],
   Inv_HW_Logical_Device.[Model],
   Inv_HW_Logical_Device.[Device ID],
   Inv_HW_Chassis.[Asset Tag],
 Case When Inv_HW_Chassis.[Chassis Package Type] = 1 Then 'Other'
  When Inv_HW_Chassis.[Chassis Package Type] = 2 Then 'Unknown'
  When Inv_HW_Chassis.[Chassis Package Type] = 3 Then 'Desktop'
  When Inv_HW_Chassis.[Chassis Package Type] = 4 Then 'Low Profile'
  When Inv_HW_Chassis.[Chassis Package Type] = 5 Then 'Pizza Box'
  When Inv_HW_Chassis.[Chassis Package Type] = 6 Then 'Mini Tower'
  When Inv_HW_Chassis.[Chassis Package Type] = 7 Then 'Tower'
  When Inv_HW_Chassis.[Chassis Package Type] = 8 Then 'Portable'
  When Inv_HW_Chassis.[Chassis Package Type] = 9 Then 'Laptop'
  When Inv_HW_Chassis.[Chassis Package Type] = 10 Then 'Notebook'
  When Inv_HW_Chassis.[Chassis Package Type] = 11 Then 'Hand Held'
  When Inv_HW_Chassis.[Chassis Package Type] = 12 Then 'Docking Station'
  When Inv_HW_Chassis.[Chassis Package Type] = 13 Then 'All in One'
  When Inv_HW_Chassis.[Chassis Package Type] = 14 Then 'Sub Notebook'
  When Inv_HW_Chassis.[Chassis Package Type] = 15 Then 'Space-Saving'
  When Inv_HW_Chassis.[Chassis Package Type] = 16 Then 'Lunch Box'
  When Inv_HW_Chassis.[Chassis Package Type] = 17 Then 'Main System'
  When Inv_HW_Chassis.[Chassis Package Type] = 18 Then 'Expansion Chassis'
  When Inv_HW_Chassis.[Chassis Package Type] = 19 Then 'Sub Chassis'
  When Inv_HW_Chassis.[Chassis Package Type] = 20 Then 'Bus Expansion'
  When Inv_HW_Chassis.[Chassis Package Type] = 21 Then 'Peripheral Chassis'
  When Inv_HW_Chassis.[Chassis Package Type] = 22 Then 'Storage Chassis'
  When Inv_HW_Chassis.[Chassis Package Type] = 23 Then 'Rack Mount'
  When Inv_HW_Chassis.[Chassis Package Type] = 24 Then 'Sealed-Case PC' End as [Chassis Type]
FROM Inv_HW_Logical_Device
INNER JOIN Inv_HW_Chassis ON
Inv_HW_Logical_Device.[Device ID] = Inv_HW_Chassis.[Device ID]
AND Inv_HW_Logical_Device.[_ResourceGuid] = Inv_HW_Chassis.[_ResourceGuid]
JOIN Inv_AeX_AC_Identification aai ON
aai._ResourceGuid = Inv_HW_Chassis._ResourceGuid
ORDER BY aai.Name
ASC

Regards,

IP.

[HHenry]

This worked very well. Thank you Igor.