[Config Mgr] Query to show all clients that have a certain package installed
1: select
2: SMS_R_SYSTEM.ResourceID,
3: SMS_R_SYSTEM.ResourceType,
4: SMS_R_SYSTEM.Name,
5: SMS_R_SYSTEM.SMSUniqueIdentifier,
6: SMS_R_SYSTEM.ResourceDomainORWorkgroup,
7: SMS_R_SYSTEM.Client
8: from SMS_R_System
9: where SMS_R_System.ResourceId in
10: (select ResourceID
11: from SMS_G_System_PACKAGESINSTALLED
12: where SMS_G_System_PACKAGESINSTALLED.Application = "PackageName"
13: )
Replace the “
PackageName” with the actual package name you want to query the reported clients for.