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