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
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)" "Bob" wrote in message news:%23a$BRYQMGHA.3432@tk2msftngp13.phx.gbl... >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 >
Thanks Andy, Where would I get LDP Bob "andy webb" wrote in message news:e4GCkqpNGHA.3936@TK2MSFTNGP12.phx.gbl... > 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)" > > > > "Bob" wrote in message > news:%23a$BRYQMGHA.3432@tk2msftngp13.phx.gbl... >>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 >> > >
Hi, LDP is part of the windows support tools that can be installed from the windows server cd. Leif "Bob" wrote in message news:ONHXXVMOGHA.648@TK2MSFTNGP14.phx.gbl... > Thanks Andy, > > Where would I get LDP > > Bob > "andy webb" wrote in message > news:e4GCkqpNGHA.3936@TK2MSFTNGP12.phx.gbl... >> 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)" >> >> >> >> "Bob" wrote in message >> news:%23a$BRYQMGHA.3432@tk2msftngp13.phx.gbl... >>>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 >>> >> >> > >
Thanks "Leif Pedersen [MVP]" wrote in message news:%23rBlTkXOGHA.3888@TK2MSFTNGP12.phx.gbl... > Hi, > > LDP is part of the windows support tools that can be installed from the > windows server cd. > > Leif > > "Bob" wrote in message > news:ONHXXVMOGHA.648@TK2MSFTNGP14.phx.gbl... >> Thanks Andy, >> >> Where would I get LDP >> >> Bob >> "andy webb" wrote in message >> news:e4GCkqpNGHA.3936@TK2MSFTNGP12.phx.gbl... >>> 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)" >>> >>> >>> >>> "Bob" wrote in message >>> news:%23a$BRYQMGHA.3432@tk2msftngp13.phx.gbl... >>>>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 >>>> >>> >>> >> >> > >
