Log in

[Config Mgr] Query to show all clients that have a certain package installed

By DimitriC at February 05, 2010 13:44
Filed Under: Configuration Manager, WQL
 
   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.

Tags:
Comments (0) E-mail Kick it! DZone it! del.icio.us Permalink Post RSS
Comments are closed