Guest UselessUser Posted January 17, 2008 Posted January 17, 2008 Hi all, I am having trouble using the Find users section on ADUC... If I go to advanced for example, and put in the field... User -> Member Of Condition -> Is exactly Value -> Group Name I get no results back?? I have had other examples of this... like trying to find who has a certain SMTP address on their account which has not worked either? Any ideas? Also just a quick query to see if anyone can point me to some good free documentation about SQL server (MSDE and full) and also what are the differences (Besides cost?!)
Guest Richard Mueller [MVP] Posted January 17, 2008 Posted January 17, 2008 Re: Finding users, contacts and groups? / SQL query "UselessUser" <UselessUser@discussions.microsoft.com> wrote in message news:D47208F6-D261-4B06-842B-FF60A1295509@microsoft.com... > Hi all, > > I am having trouble using the Find users section on ADUC... > > If I go to advanced for example, and put in the field... > > User -> Member Of > Condition -> Is exactly > Value -> Group Name > > I get no results back?? I have had other examples of this... like trying > to > find who has a certain SMTP address on their account which has not worked > either? Any ideas? > > Also just a quick query to see if anyone can point me to some good free > documentation about SQL server (MSDE and full) and also what are the > differences (Besides cost?!) You must specify the full Distinguished Name of the group in your query (not the NetBIOS name of the group). Similar to: cn=MyGroup,ou=Sales,ou=West,dc=MyDomain,dc=com -- Richard Mueller Microsoft MVP Scripting and ADSI Hilltop Lab - http://www.rlmueller.net --
Guest UselessUser Posted January 19, 2008 Posted January 19, 2008 Re: Finding users, contacts and groups? / SQL query Hi, I am not sure if you will read this but.... Thank you Thank you THANK YOU! All 3 statements I felt were completely necessary... I guess I should have realised that an LDAP search should have used that... "Richard Mueller [MVP]" wrote: > > "UselessUser" <UselessUser@discussions.microsoft.com> wrote in message > news:D47208F6-D261-4B06-842B-FF60A1295509@microsoft.com... > > Hi all, > > > > I am having trouble using the Find users section on ADUC... > > > > If I go to advanced for example, and put in the field... > > > > User -> Member Of > > Condition -> Is exactly > > Value -> Group Name > > > > I get no results back?? I have had other examples of this... like trying > > to > > find who has a certain SMTP address on their account which has not worked > > either? Any ideas? > > > > Also just a quick query to see if anyone can point me to some good free > > documentation about SQL server (MSDE and full) and also what are the > > differences (Besides cost?!) > > You must specify the full Distinguished Name of the group in your query (not > the NetBIOS name of the group). Similar to: > > cn=MyGroup,ou=Sales,ou=West,dc=MyDomain,dc=com > > -- > Richard Mueller > Microsoft MVP Scripting and ADSI > Hilltop Lab - http://www.rlmueller.net > -- > > >
Recommended Posts