SCCM 2012 – WQL Query for devices with specific software installed
If you want to identify machines with a specific piece of software installed, you can utilise the Add/Remove Programs software inventory to do this by using this query.
select distinct <br /> SMS_R_System.Name, <br /> SMS_R_System.OperatingSystemNameandVersion, <br /> SMS_R_System.ClientVersion <br /> from SMS_R_System <br /> inner join SMS_G_System_ADD_REMOVE_PROGRAMS <br /> on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId <br /> where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Office Professional Plus 2010" <br /> order by SMS_R_System.Name <br />
In this example, we are using “Microsoft Office Professional Plus” – however, you can change this value to anything you like (that matches the Add/Remove Programs software inventory) to bring back the required information.
If you have any problems with this query, please leave a comment below.