Symantec Management Platform (Notification Server)

 View Only
  • 1.  Need some direction on an SQL report

    Posted Jul 26, 2016 02:36 PM

    Greetings,

    I have a simple report and need some direction on how to add a few more items but no luck so far.

    Here is the report.

    ----------------------------------------------------------------------------------------------------------------------------------------------

    SELECT vc.[Name],vc.[User],vc.[OS Name],vc.[OS Revision],vc.[System Type],cs.[Manufacturer],cs.[Model]

    FROM vComputer vc

    JOIN vHWComputerSystem cs ON vc.[Guid]=cs._ResourceGuid

    -------------------------------------------------------------------------------------------------------------------------------------------------

    I just want to add Processor Type, Total RAM, hard disk space and .net version.  I kept getting "this datasource is not a runnable state'

    Any direction would be appreciated.

    Thanks

     

     



  • 2.  RE: Need some direction on an SQL report
    Best Answer

    Posted Jul 27, 2016 02:09 AM
    .Net Version is in the following table: Inv_AeX_AC_NetFrameworkVersions
    You will have multiple entries there per machine, as you will have multiple version of .net framework on your machines.

    Total RAM is in ​Inv_HW_Physical_Memory
     
    Processor: Inv_HW_Processor_Name_Windows
     
    Harddisk: Inv_HW_Logical_Disk


  • 3.  RE: Need some direction on an SQL report

    Posted Jul 27, 2016 08:38 AM

    Thanks schnyders.