hi, i am trying to make a collection based on a query that gets computer names from a specific OU. I know the query is correct but i am not getting any results. It seems the query is not getting into AD to get the information Active Directory System Discovery is Enabled. Anyone has any idea what goes wrong ?

Hi, Did you enable Active Directory System Group discovery as well? It is required to discover OU information: http://technet.microsoft.com/en-us/library/cc181248.aspxFollow me through my blog and Twitter!

hi, thnx for your reply and the answer is yes, it's enabled too

can you paste your query in your reply. If the OU information are found and stored in ConfigMgr. they should work in a query.Kent Agerlund | http://scug.dk/ | The Danish community for System Center products

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 = "domain.com\Computers" domain.com\Computers is an example, not the real names

Try this: SMS_R_System.SystemOUName = "Domain_name/OUname" Follow me through my blog and Twitter!

you can try this : select * from SMS_R_System where SMS_R_System.SystemOUName = "eskon.COM/computers" Btw,if you are creating collection with Query based and using Criteria,you can select the OU directly from the existing OU's(you will all Ous like Domainname/OUname) //Eswar Koneti @ http://eskonr.wordpress.com/

hi, tried it but did not work. Is there a way to check if there really is a connection with AD ?

can you verify that the OU information is added to your computer objects? Just double click any of the computers in the configmgr. console.Kent Agerlund | http://scug.dk/ | The Danish community for System Center products

When i double click a computer object in another collection i see under discovery data a lot of property's. Is there a property i can check to see if the information i put in the query is right ? for instance the Domain name or so /

the property AD Domain Name displays <null>, is that correct /

you should have information shown in the System OU Name. If not then the data is not stored in the DB. Your query is correct, I think the problem is in the AD System Group Discovery. Any errors in the adsysgrp.log file?Kent Agerlund | http://scug.dk/ | The Danish community for System Center products

I don't see anything in the log file that indicate as ERROR should the IP range of the systems i am looking for be in the boundaries ?

they objects should be assigned to the site, so yes they should be in the boundaries. Check this flowchart http://technet.microsoft.com/en-us/library/bb932145.aspxKent Agerlund | http://scug.dk/ | The Danish community for System Center products

is it necessary to put the OU you want to discover in the Active Directory System Discovery as LDAP query in the properties ?

or is this only necessary for the OU's you want to exclude ?

the LDAP defines the OU's that you are using in the search. Make sure that you have the correct OU defined.Kent Agerlund | http://scug.dk/ | The Danish community for System Center products

Still not working. The strange thing is that if i make the collection and i get the end window where it says Confirmation i see : Details General Membership Rules Advertisements Security but there is no info there. Shouldn't there be any text there ? Does thet implicate that it allready goes wrong creating the collection ?

when i create the query, there is an option to get values instead of typing the OU path. If i open this value box i only see a few OU's there. Is that normal ?

It's because you haven't collected the other OU information. You should configure the LDAP path to include the OU's you want to import.Kent Agerlund | http://scug.dk/ | The Danish community for System Center products

Hi Kent, you are totally right. I added an LDAP query to the Active Directory System group Discovery properties with the top OU where i want to find the systems and now i find them under "values" and when i pick an OU i get the results i want. Thank you very much for your time and effort you put into helping me. Greetings Gerrit

Hi Gerrit, Very glad to hear the issue resolved. Also, if you have any further concerns, please do not hesitate to let us know and we are happy to be of further assistance. Thanks,Yog Li -- Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.