Symantec Management Platform (Notification Server)

I'm looking to do a bespoke report that will bring back the following:

User of PC (last logged in)

Name of PC

List of Software in Add/Remove Programs.

While I can do this manually and just look at the information in Computers I would prefer a report that gave me all the details.

I've had a look and can't find anything.

I have a Filter setup for the machines I want to find out the information for, but I believe I need to create a custom script and being new to this product I don't know how to do it.

Any assistance would be appreciated.

J

The following objects should help (names may not be fully correct): 

Inv_AC_Identification  -  PC info

Inv_AddRemove  - ARP info

vUser - User info

CollectionMembership - targets computers in a specific filter.  Use vCollection to find the filter guid based off of its name first. 

You could of course use vComputer instead of objects 1 & 2. 

Hi,

try this SQL Query

SELECT vi.Name AS [PC Name],

      u.Domain + '\' + u.[User] AS [Primary User],

      ISNULL(CONVERT(VARCHAR,logon.LastLogin), 'N/A') AS [Last Logon DateTime],
      i.[Hardware Serial Number],
      ad.[DisplayName] AS [Software in Add/Remove],
      ad.[DisplayVersion] AS [Software Version],
      ad.[Publisher]
      

FROM vRM_Computer_Item vi

JOIN Inv_AeX_AC_Identification i

   ON i._ResourceGuid = vi.Guid

JOIN Inv_AeX_AC_Primary_User u

   ON u._ResourceGuid = i._ResourceGuid

JOIN Inv_AddRemoveProgram ad

    ON ad._ResourceGuid = i._ResourceGuid

OUTER APPLY (SELECT _ResourceGuid, MAX(_eventTime) AS LastLogin

           FROM Evt_AeX_Client_LogOn

           WHERE _ResourceGuid = vi.Guid

           AND LOWER(Event) = 'logon'

           GROUP BY _ResourceGuid) logon

           ORDER BY [Last Logon DateTime]
           DESC

Thanks,

IP.