Tuesday, May 28, 2013

SCCM Collection for Windows 7 machines from a OU and multiple domains

This WQL Query will create a collection for all Windows 7 machines with combination of OU and domains.

*********************************************************


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 where 
(SMS_R_System.SystemOUName like "AD.YOURDOMAIN.COM/OU" or SMS_R_System.ResourceDomainORWorkgroup like "DOMAIN1" or SMS_R_System.ResourceDomainORWorkgroup like "DOMAIN2")and SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation 6.1"
************************************************ 


More SCCM collection queries can be found here
 

No comments:

Post a Comment