I'm sure someone has something prettier, but this one works for me. I limit the collection to All Servers (including the query for that below as well).
select SMS_R_System.Name from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office 2000 SR-1 Prem%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office 2000 SR-1 Prem%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office 2000 SR-1 Prof%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office 2000 Stan%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office 2000 SR-1 Stan%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office XP Stan%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office XP Sma%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office XP Pro%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office Sta%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office Ult%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office Ent%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office Sma%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office Hom%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office Bas%" or SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "Microsoft Office Prof%" order by SMS_R_System.Name All Servers collection: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SY STEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM .Client from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT %Server%" From: [email protected] [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Thursday, July 7, 2016 8:14 AM To: [email protected] Subject: [mssms] Servers with Office installed Hello, Does anyone have a query to find any servers with MS Office installed? Thanks, Brian
smime.p7s
Description: S/MIME cryptographic signature
