Query on System OU but not computers from underlying OU

[StefanWe]

Hi,

 

i have a simple query that imports computers from an on like XenDesktop55.

Under that OU there is another OU "Controller" where one computer object is in. "Controller01".

 

Now, i have in my collection all computers from XenDesktop55 and the Controller01 computer.

How can i only get the computers from the first OU?

 

My query is this:

 

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 = "INTERN.NET/XENDESKTOP55"

 

Thanks