This has more fields than you requested, but should do the trick. You can 
customize as needed.

 

Select distinct sys.Netbios_Name0, fcm.SiteCode,  sys.User_Domain0, 
sys.User_Name0,  tcu.TopConsoleUser0, sys.Operating_System_Name_and0, 
arp.DisplayName0, arp.Version0 

FROM v_R_System sys

JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID 

JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID

LEFT JOIN v_GS_SYSTEM_CONSOLE_USAGE tcu ON sys.ResourceID=tcu.ResourceID

WHERE ( DisplayName0 like 'Microsoft Office Professional Plus 2013' or 

DisplayName0 like 'Microsoft Office Standard 2013')

and fcm.CollectionID='SMS00001'

ORDER BY DisplayName0





Reply via email to