WHERE arp.DisplayName LIKE '%Microsoft Office Standard%' or arp.DisplayName Like 'Microsoft Office Professional%' or arp.DisplayName LIke 'Microsoft Office Enterprise %' DisplayNameįROM SMS_R_SYSTEM sys INNER JOIN SMS_G_SYSTEM_ADD_Remove_Programs arp ON sys.ResourceID = arp.ResourceID SELECT DISTINCT sys.Name, SMS_G_SYSTEM_ADD_Remove_Programs. See below one: (Just modified above ones and without any syntax check) 32bit Office will only in SMS_G_SYSTEM_ADD_Remove_Programs and 64bit ones are in SMS_G_SYSTEM_ADD_Remove_Programs_64.
0 kommentar(er)
