SCCM Collection based on Active Directory Organisation Unit (OU) Membership
You may want to create a Configuration Manager Collection based upon an Active Directory Organisation Unit. To do this you can use the following WQL code and then simply amend the last part to be the Organisation Unit that you want to base the Collection on:

 SELECT  
 SMS_R_USER.ResourceID,  
 SMS_R_USER.ResourceType,  
 SMS_R_USER.Name,  
 SMS_R_USER.UniqueUserName,  
 SMS_R_USER.WindowsNTDomain   
 FROM  
 SMS_R_User  
 WHERE   
 SMS_R_User.UserOUName = "LOCALDOMAIN.COM/COMPANYNAME/TECHYGEEKSHOME"

COMMENTS

If you have any questions or comments on this post, then please feel free to post a message below using our Disqus system below.

Labels: , ,