Client Management Suite

Expand all | Collapse all

How to generate a specific Report

Jump to Best Answer
  • 1.  How to generate a specific Report

    Posted 01-13-2020 11:12 AM

    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)



  • 2.  RE: How to generate a specific Report
    Best Answer

    Posted 01-14-2020 12:44 AM

    (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.



  • 3.  RE: How to generate a specific Report

    Posted 01-16-2020 09:23 PM

    This worked very well. Thank you Igor.