SM 2003 Collection Based On AD OU??

[bkrauthamer]

Hi,

I am trying to create a collection based on the members of a specific OU in my AD. The OU is called "Dev-Systems" and is 2 levels deep in my AD. I believe the proper way to do this is to create a new collection and then update the "Membership Rules" based on a Query. I am using the followin query statement:
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 SystemOUName = "OU=Dev-Systems,OU=Cambridge-USA,OU=North America,DC=rpega,DC=com"

But my collection keeps coming up empty when I update the membership. I am sure I have the syntax incorrect. Is there anyone who can help me out?

 

[pmol]

Do you have AD System Group Discovery turned on ? this is needed.

Then, don't create the query yourself, but just select the right components by using the pull down options.

Make the query based on : System Resource - System Group Name
it will work then.

good luck.