Finding users, contacts and groups? / SQL query

[Guest UselessUser]

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]]

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]

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

> --

>

>

>