LDAP query construction and LDAP query tool

LDAP query construction and LDAP query tool

Post by Bob » Wed, 15 Feb 2006 10:33:48


I am trying to find out which users have a limit set that restricts the size
of emails they can send.
The attribute that gets populated is "SubmissionContLength" and it is blank
(or null) when there is no limit set.
Does anyone have an LDAP query that I can issue against Active DIrectory
that will return the info I need?

Also is there a tool like SQL Query Analyser that I can use to execute LDAP
commands and examine the results

Thanks

Bob
 
 
 

LDAP query construction and LDAP query tool

Post by andy web » Wed, 22 Feb 2006 12:55:22

You can use LDP to do queries through a GUI.

You can use ldifde to get the properties from the command line.

for ldifde, it would look something like:
ldifde -f export.txt -r
"(&(legacyExchangeDN=*)(mailNickname=*)(objectCategory=person)(objectClass=user))"
-l "(submissionContlength)"

to get just the users that have the value set and exclude those without it,
use:
ldifde -f export.txt -r
"(&(legacyExchangeDN=*)(mailNickname=*)(objectCategory=person)(objectClass=user)(submissionContlength=*))"
-l "(submissionContlength)"

 
 
 

LDAP query construction and LDAP query tool

Post by Bob » Sat, 25 Feb 2006 07:10:58

Thanks Andy,

Where would I get LDP

Bob
 
 
 

LDAP query construction and LDAP query tool

Post by Leif Peder » Sun, 26 Feb 2006 04:32:38

Hi,

LDP is part of the windows support tools that can be installed from the
windows server cd.

Leif
 
 
 

LDAP query construction and LDAP query tool

Post by Bob » Tue, 28 Feb 2006 08:34:39

Thanks