Symantec Developer Group

 View Only
  • 1.  Adding User Information to a Software Query

    Posted Sep 27, 2016 11:49 AM

    I have the following SQL Query to check for Google Chrome.

    I need help adding user information to the output?

    Thanks for any ideas?

    SELECT arp1.DisplayName, arp1.DisplayVersion, arp1.InstallDate, c1.Name AS 'Computer', id1.[OS Name], id1.[OS Type]
    FROM vRM_Computer_Item c1
    JOIN Inv_AddRemoveProgram arp1 ON c1.Guid = arp1._ResourceGuid
    JOIN Inv_AeX_AC_Identification id1 ON c1.Guid = id1._ResourceGuid
    WHERE arp1.DisplayName LIKE '%google chrome%'
    Order by DisplayVersion

     

     



  • 2.  RE: Adding User Information to a Software Query
    Best Answer

    Posted Sep 29, 2016 03:53 AM

    Inv_AeX_AC_Identification has the Field [Last Logon User]

    SELECT 
    	arp1.DisplayName
    	,arp1.DisplayVersion
    	,arp1.InstallDate
    	,c1.NAME AS 'Computer'
    	,id1.[OS Name]
    	,id1.[OS Type]
    	,id1.[Last Logon User]
    FROM vRM_Computer_Item c1
    JOIN Inv_AddRemoveProgram arp1 ON c1.Guid = arp1._ResourceGuid
    JOIN Inv_AeX_AC_Identification id1 ON c1.Guid = id1._ResourceGuid
    WHERE arp1.DisplayName LIKE '%google chrome%'
    ORDER BY DisplayVersion

    Is there other User Info you need?