How to create a collection of computers by installed software

These are directions on how to create an SCCM device collection based upon what software the device has installed on it.

Use this query (the example is iTunes):

select 
SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  

SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId 

where 
(SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%iTunes%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version like "%") or (SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%iTunes%" and SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version like "%") 

order by SMS_R_System.Name

Source: https://systemcenterguru.wordpress.com/2014/02/20/how-to-create-a-collection-of-computers-by-installed-software/

Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.