SCCM collection query for Windows 7 machines in multiple domains

This query makes a collection of all Windows 7 machines on different domains.
You can rename DOMAIN1 to DOMAIN5 as you needed.

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

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.ResourceDomainORWorkgroup like "DOMAIN1" or SMS_R_System.ResourceDomainORWorkgroup like "DOMAIN2" or SMS_R_System.ResourceDomainORWorkgroup like "DOMAIN3" or SMS_R_System.ResourceDomainORWorkgroup like "DOMAIN4" or SMS_R_System.ResourceDomainORWorkgroup like "DOMAIN5") and SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation 6.1"

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

More SCCM collection queries can be found here