Hello All I need to be able to qrite a fairly simple LDAP query in AD to bring back the following: All active users (in an OU called users) who don't have an SMTP email address which starts username@domain for example (the user name is a number). Can this be easily be done I use AD 2003 daily and need this information. Thanks in Advance
You can't base an LDAP query dynamically upon what the object name is being checked. You would need to dump all users with smtp addresses and compare the username with the address. joe -- Joe Richards Microsoft MVP Windows Server Directory Services www.joeware.net slinkydonkey@hotmail.com wrote: > Hello All > > I need to be able to qrite a fairly simple LDAP query in AD to bring > back the following: > > All active users (in an OU called users) who don't have an SMTP email > address which starts username@domain for example (the user name is a > number). > > Can this be easily be done I use AD 2003 daily and need this > information. > > > Thanks in Advance >
Hi Joe I finaly managed to write an LDAP query to bring back all email address that don't end with the SMTP email address @myworksdomain.co.uk. I didnt understand your reply but thanks anyway. :O) Joe Richards [MVP] wrote: > You can't base an LDAP query dynamically upon what the object name is being > checked. You would need to dump all users with smtp addresses and compare the > username with the address. > > joe > > -- > Joe Richards Microsoft MVP Windows Server Directory Services > www.joeware.net > > > slinkydonkey@hotmail.com wrote: > > Hello All > > > > I need to be able to qrite a fairly simple LDAP query in AD to bring > > back the following: > > > > All active users (in an OU called users) who don't have an SMTP email > > address which starts username@domain for example (the user name is a > > number). > > > > Can this be easily be done I use AD 2003 daily and need this > > information. > > > > > > Thanks in Advance > >
That is different from what you asked for. It is much easier. That query would look something like (!(mail=*@myworksdomain.co.uk)) or if you wanted to make sure it was users who had a mail attribute but not one with the value you specified (&(objectcategory=person)(objectclass=user)(mail=*)(!(mail=*@myworksdomain.co.uk))) -- Joe Richards Microsoft MVP Windows Server Directory Services www.joeware.net slinkydonkey@hotmail.com wrote: > Hi Joe > > I finaly managed to write an LDAP query to bring back all email address > that don't end with the SMTP email address @myworksdomain.co.uk. > > I didnt understand your reply but thanks anyway. :O) > > > Joe Richards [MVP] wrote: > >>You can't base an LDAP query dynamically upon what the object name is being >>checked. You would need to dump all users with smtp addresses and compare the >>username with the address. >> >> joe >> >>-- >>Joe Richards Microsoft MVP Windows Server Directory Services >>www.joeware.net >> >> >>slinkydonkey@hotmail.com wrote: >> >>>Hello All >>> >>>I need to be able to qrite a fairly simple LDAP query in AD to bring >>>back the following: >>> >>>All active users (in an OU called users) who don't have an SMTP email >>>address which starts username@domain for example (the user name is a >>>number). >>> >>>Can this be easily be done I use AD 2003 daily and need this >>>information. >>> >>> >>>Thanks in Advance >>> > >
