SCCM 2012 Query for devices in a specific Active Directory Organisational Unit (OU)
This is a SCCM 2012 query that will return all machines that are in a specified organisational unit (OU).

All you need to do is change the demo OU below to your own required OU.

 "TECHYGEEKSHOME.CO.UK/LAB/COMPUTERS/WINDOWS 7"  


 SELECT  
      distinct *   
 FROM  
      SMS_R_System  
      WHERE SMS_R_System.SystemOUName = "TECHYGEEKSHOME.CO.UK/LAB/COMPUTERS/WINDOWS 7"

This will then return all machines in this OU along with a large amount of information for each machine.

If you have any problems with this query, please leave a comment below and we will try and help you as soon as we can.

Labels: , ,