SOLVED Create SCCM Collection based on OU query

[araimondi]

Hi guys

I need to create a collection on a OU .. I did it query based and it seems only 1366 populate even though the OU has over 2000 machines. I have AD and Group discovery setup correctly i cant figure out why some entries in the collection are missing.. Any help will be appreciated

 

[Youssef Saad]

You can try with with query and let us know if it works :

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 like "%NAME-OF-OU%"

 

[araimondi]

You are a life saver my friend! Worked perfectly!! thank you

 

[Prajwal Desai]

@Youssef Saad - Good one