dsquery

Hi All,

My client is looking for a list of all mail enabled groups and each groups
members. (Don't need any security groups that have e-mail addresses
enabled). Is this possible with dsquery and if so what would be the correct
command? If not is there something else I could use?

Thanks Much!

Matt

"Matt" <> wrote in message
news:...
> Hi All,
>
> My client is looking for a list of all mail enabled groups and each groups
> members. (Don't need any security groups that have e-mail addresses
> enabled). Is this possible with dsquery and if so what would be the
> correct command? If not is there something else I could use?
>
> Thanks Much!
>
> Matt
>


You are better off using a script to pull this info. Take a look at the
following link.

"This script exports all smtp address, I only want the primary..."
http://www.petri.co.il/forums/archiv...p/t-19411.html


--
Ace

This posting is provided "AS-IS" with no warranties or guarantees and
confers no rights.

Please reply back to the newsgroup or forum for collaboration benefit among
responding engineers, and to help others benefit from your resolution.

Ace Fekay, MCT, MCITP EA, MCTS Windows 2008 & Exchange 2007, MCSE & MCSA
2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer

For urgent issues, please contact Microsoft PSS directly. Please check
http://support.microsoft.com for regional support phone numbers.

Howdie!

Matt schrieb:
> My client is looking for a list of all mail enabled groups and each groups
> members. (Don't need any security groups that have e-mail addresses
> enabled). Is this possible with dsquery and if so what would be the correct
> command? If not is there something else I could use?

Using ADFind from joeware.net, you could go with a query like this:

adfind -default -f
"&(objectClass=group)(legacyexchangedn=*)(groupTyp e<=8)" samaccountname

That should print out all sAMAccountNames of all distribution groups.

Cheers,
Florian
--
Microsoft MVP - Group Policy
eMail: prename [at] frickelsoft [dot] net.
blog: http://www.frickelsoft.net/blog.
ANY advice you get on the Newsgroups should be tested thoroughly in your
lab.

Florian,

Thanks for the input. The command gave me all the mail enabled groups but I
also need a list of the members of each group. What can I change in the
command to supply the group and the members?

Thanks!

Matt


"Florian Frommherz [MVP]" <> wrote in
message news:%...
> Howdie!
>
> Matt schrieb:
>> My client is looking for a list of all mail enabled groups and each
>> groups members. (Don't need any security groups that have e-mail
>> addresses enabled). Is this possible with dsquery and if so what would be
>> the correct command? If not is there something else I could use?
>
> Using ADFind from joeware.net, you could go with a query like this:
>
> adfind -default -f
> "&(objectClass=group)(legacyexchangedn=*)(groupTyp e<=8)" samaccountname
>
> That should print out all sAMAccountNames of all distribution groups.
>
> Cheers,
> Florian
> --
> Microsoft MVP - Group Policy
> eMail: prename [at] frickelsoft [dot] net.
> blog: http://www.frickelsoft.net/blog.
> ANY advice you get on the Newsgroups should be tested thoroughly in your
> lab.

You can add the member attribute to the list. For example (one line):

adfind -default -f
"(&(objectCategory=group)(legacyExchangeDN=*)(grou pType<=8))"
sAMAccountName, member

The member attribute is a collection of group DN's.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--

"Matt" <> wrote in message
news:...
> Florian,
>
> Thanks for the input. The command gave me all the mail enabled groups but
> I also need a list of the members of each group. What can I change in the
> command to supply the group and the members?
>
> Thanks!
>
> Matt
>
>
> "Florian Frommherz [MVP]" <> wrote in
> message news:%...
>> Howdie!
>>
>> Matt schrieb:
>>> My client is looking for a list of all mail enabled groups and each
>>> groups members. (Don't need any security groups that have e-mail
>>> addresses enabled). Is this possible with dsquery and if so what would
>>> be the correct command? If not is there something else I could use?
>>
>> Using ADFind from joeware.net, you could go with a query like this:
>>
>> adfind -default -f
>> "&(objectClass=group)(legacyexchangedn=*)(groupTyp e<=8)" samaccountname
>>
>> That should print out all sAMAccountNames of all distribution groups.
>>
>> Cheers,
>> Florian
>> --
>> Microsoft MVP - Group Policy
>> eMail: prename [at] frickelsoft [dot] net.
>> blog: http://www.frickelsoft.net/blog.
>> ANY advice you get on the Newsgroups should be tested thoroughly in your
>> lab.
>
>

Richard,

Thanks that worked great! One last question. I didn't see in the options how
to output the results to a txt file. Is that possible?

Thanks,

Matt

"Richard Mueller [MVP]" <rlmueller-> wrote in
message news:ODw5E%...
> You can add the member attribute to the list. For example (one line):
>
> adfind -default -f
> "(&(objectCategory=group)(legacyExchangeDN=*)(grou pType<=8))"
> sAMAccountName, member
>
> The member attribute is a collection of group DN's.
>
> --
> Richard Mueller
> MVP Directory Services
> Hilltop Lab - http://www.rlmueller.net
> --
>
> "Matt" <> wrote in message
> news:...
>> Florian,
>>
>> Thanks for the input. The command gave me all the mail enabled groups but
>> I also need a list of the members of each group. What can I change in the
>> command to supply the group and the members?
>>
>> Thanks!
>>
>> Matt
>>
>>
>> "Florian Frommherz [MVP]" <> wrote in
>> message news:%...
>>> Howdie!
>>>
>>> Matt schrieb:
>>>> My client is looking for a list of all mail enabled groups and each
>>>> groups members. (Don't need any security groups that have e-mail
>>>> addresses enabled). Is this possible with dsquery and if so what would
>>>> be the correct command? If not is there something else I could use?
>>>
>>> Using ADFind from joeware.net, you could go with a query like this:
>>>
>>> adfind -default -f
>>> "&(objectClass=group)(legacyexchangedn=*)(groupTyp e<=8)" samaccountname
>>>
>>> That should print out all sAMAccountNames of all distribution groups.
>>>
>>> Cheers,
>>> Florian
>>> --
>>> Microsoft MVP - Group Policy
>>> eMail: prename [at] frickelsoft [dot] net.
>>> blog: http://www.frickelsoft.net/blog.
>>> ANY advice you get on the Newsgroups should be tested thoroughly in your
>>> lab.
>>
>>
>
>

There is a -csv option for adfind. Check the syntax help at a command line
with adfind /?, or at this link:

http://www.joeware.net/freetools/tools/adfind/usage.htm

Also, you can always redirect the output of any command line utility to a
text file. For example:

adfind -default -f "(objectCategory=group)" sAMAccountName, member >
report.txt

However, the -csv option creates a comma delimited file, which may be
better. You can specify the delimiter.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--

"Matt" <> wrote in message
news:...
> Richard,
>
> Thanks that worked great! One last question. I didn't see in the options
> how to output the results to a txt file. Is that possible?
>
> Thanks,
>
> Matt
>
> "Richard Mueller [MVP]" <rlmueller-> wrote in
> message news:ODw5E%...
>> You can add the member attribute to the list. For example (one line):
>>
>> adfind -default -f
>> "(&(objectCategory=group)(legacyExchangeDN=*)(grou pType<=8))"
>> sAMAccountName, member
>>
>> The member attribute is a collection of group DN's.
>>
>> --
>> Richard Mueller
>> MVP Directory Services
>> Hilltop Lab - http://www.rlmueller.net
>> --
>>
>> "Matt" <> wrote in message
>> news:...
>>> Florian,
>>>
>>> Thanks for the input. The command gave me all the mail enabled groups
>>> but I also need a list of the members of each group. What can I change
>>> in the command to supply the group and the members?
>>>
>>> Thanks!
>>>
>>> Matt
>>>
>>>
>>> "Florian Frommherz [MVP]" <> wrote in
>>> message news:%...
>>>> Howdie!
>>>>
>>>> Matt schrieb:
>>>>> My client is looking for a list of all mail enabled groups and each
>>>>> groups members. (Don't need any security groups that have e-mail
>>>>> addresses enabled). Is this possible with dsquery and if so what would
>>>>> be the correct command? If not is there something else I could use?
>>>>
>>>> Using ADFind from joeware.net, you could go with a query like this:
>>>>
>>>> adfind -default -f
>>>> "&(objectClass=group)(legacyexchangedn=*)(groupTyp e<=8)" samaccountname
>>>>
>>>> That should print out all sAMAccountNames of all distribution groups.
>>>>
>>>> Cheers,
>>>> Florian
>>>> --
>>>> Microsoft MVP - Group Policy
>>>> eMail: prename [at] frickelsoft [dot] net.
>>>> blog: http://www.frickelsoft.net/blog.
>>>> ANY advice you get on the Newsgroups should be tested thoroughly in
>>>> your lab.
>>>
>>>
>>
>>
>
>

Richard,

Thanks for the input! Works great..

Matt


"Richard Mueller [MVP]" <rlmueller-> wrote in
message news:...
> There is a -csv option for adfind. Check the syntax help at a command line
> with adfind /?, or at this link:
>
> http://www.joeware.net/freetools/tools/adfind/usage.htm
>
> Also, you can always redirect the output of any command line utility to a
> text file. For example:
>
> adfind -default -f "(objectCategory=group)" sAMAccountName, member >
> report.txt
>
> However, the -csv option creates a comma delimited file, which may be
> better. You can specify the delimiter.
>
> --
> Richard Mueller
> MVP Directory Services
> Hilltop Lab - http://www.rlmueller.net
> --
>
> "Matt" <> wrote in message
> news:...
>> Richard,
>>
>> Thanks that worked great! One last question. I didn't see in the options
>> how to output the results to a txt file. Is that possible?
>>
>> Thanks,
>>
>> Matt
>>
>> "Richard Mueller [MVP]" <rlmueller-> wrote in
>> message news:ODw5E%...
>>> You can add the member attribute to the list. For example (one line):
>>>
>>> adfind -default -f
>>> "(&(objectCategory=group)(legacyExchangeDN=*)(grou pType<=8))"
>>> sAMAccountName, member
>>>
>>> The member attribute is a collection of group DN's.
>>>
>>> --
>>> Richard Mueller
>>> MVP Directory Services
>>> Hilltop Lab - http://www.rlmueller.net
>>> --
>>>
>>> "Matt" <> wrote in message
>>> news:...
>>>> Florian,
>>>>
>>>> Thanks for the input. The command gave me all the mail enabled groups
>>>> but I also need a list of the members of each group. What can I change
>>>> in the command to supply the group and the members?
>>>>
>>>> Thanks!
>>>>
>>>> Matt
>>>>
>>>>
>>>> "Florian Frommherz [MVP]" <> wrote in
>>>> message news:%...
>>>>> Howdie!
>>>>>
>>>>> Matt schrieb:
>>>>>> My client is looking for a list of all mail enabled groups and each
>>>>>> groups members. (Don't need any security groups that have e-mail
>>>>>> addresses enabled). Is this possible with dsquery and if so what
>>>>>> would be the correct command? If not is there something else I could
>>>>>> use?
>>>>>
>>>>> Using ADFind from joeware.net, you could go with a query like this:
>>>>>
>>>>> adfind -default -f
>>>>> "&(objectClass=group)(legacyexchangedn=*)(groupTyp e<=8)"
>>>>> samaccountname
>>>>>
>>>>> That should print out all sAMAccountNames of all distribution groups.
>>>>>
>>>>> Cheers,
>>>>> Florian
>>>>> --
>>>>> Microsoft MVP - Group Policy
>>>>> eMail: prename [at] frickelsoft [dot] net.
>>>>> blog: http://www.frickelsoft.net/blog.
>>>>> ANY advice you get on the Newsgroups should be tested thoroughly in
>>>>> your lab.
>>>>
>>>>
>>>
>>>
>>
>>
>
>