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):

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 

(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

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.
    Blogger Comment


Post a Comment

Note: Only a member of this blog may post a comment.