Query to Detect Clients in a Specific Domain OU

This is a pretty simple query which is used to locate all Clients in a specific Active Directory OU.

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 = "DEV.DOMAIN.LOCAL/BUILD"

Which will return all clients in the dev.domain.local Build OU.

 

No votes yet