Vista - How to create a list with all distrubtion groups and it's members

Hello everyone,
I want to create a single list, which contains all distribution groups and
it's members. The fields should be like this:
Groupname,Organizationalunit of Group,Username

Thanks in advance

Hello Dominik,


If you have Quest AD cmdlets (http://www.quest.com/activeroles-server/arms.aspx)
then you can try this (one-liner):


Get-QADGroup -GroupType distribution -sizeLimit 0 -ldap '(member=*)' | select
@{n="GroupName";e={$_.name}},@{n="GroupOU";e={(Get-QADGroup $_.Name).canonicalName}}
-expand members | select @{n="UserName";e={ (Get-QADObject $_).samAccountName}},GroupName,GroupOU




UserName GroupName GroupOU
-------- --------- -------
User1 DG1 Domain/Users
User2 DG1 Domain/Users
User3 DG1 Domain/Users
User1 DG2 Domain/Users/DGOU
User2 DG2 Domain/Users/DGOU
User3 DG2 Domain/Users/DGOU
User1 DG3 Domain/Users/SomeOU
User2 DG3 Domain/Users/SomeOU
User3 DG3 Domain/Users/SomeOU





---
Shay Levy
Windows PowerShell MVP
http://blogs.microsoft.co.il/blogs/ScriptFanatic

D> Hello everyone,
D> I want to create a single list, which contains all distribution
D> groups and
D> it's members. The fields should be like this:
D> Groupname,Organizationalunit of Group,Username
D> Thanks in advance
D>

Dear Shay,

"Shay Levy [MVP]" wrote:
This really looks good, thank you! Is there a way, to limit the results only
to e-Mail activated groups?

Thanks and best Regards
Dominik