Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Content-Type: multipart/alternative;
boundary="_000_206E053EFD8D754CB67242D59E47B8373A530A7FWin2008R2Ex2010_"
MIME-Version: 1.0
--_000_206E053EFD8D754CB67242D59E47B8373A530A7FWin2008R2Ex2010_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Just in case you haven't read enough about this already, I wrote a blog pos=
t on it. :)
<http://bit.ly/cjHMky>
Regards,
Michael B. Smith
Consultant and Exchange MVP
http://TheEssentialExchange.com
From: Michael B. Smith
Sent: Wednesday, August 18, 2010 4:10 PM
To: NT System Admin Issues
Subject: RE: Generating report for Exchange Distribution groups?
Interestingly, mine had a bug...
ManagedBy can be: [a] empty, [b] a single value, or [c] an array of values
My solution only properly handles [a], and [b].
So...we have to get a little smarter, and I wanted to make the formatting a=
little nicer anyway. So that's below (I would consider this a "somewhat ad=
vanced" solution - it uses the format operator and embedded pipelines). To =
make it advanced would only require the addition of a delegate function to =
do the formatting, so the formatting wouldn't have to be repeated on each "=
manager" line.
A lesson learned here is this: to get q-and-d results, you can get by with =
a few lines of PowerShell. If you want "production quality", then you'll st=
ill need "production effort". It'll still be a quarter the size of doing it=
in vbscript... :-P
get-distributiongroup -resultsize unlimited |% {
$group =3D $_
"Group Name & Identity: {0}, {1}" -f $group.Name, $group.Id=
entity
$managedBy =3D $group.ManagedBy
if( $managedBy.Count -gt 1 )
{
[bool]$first =3D $true
foreach( $manager in $managedBy )
{
if( $first )
{
"Group mana=
gers: {0}, {1}" -f $manager.Name, ($manager.Parent.ToString() + "/" + $mana=
ger.RDN.ToString().SubString(3))
$first =3D =
$false
}
else
{
" =
{0}, {1}" -f $manager.Name, ($manager.Parent.ToString() + "/" + $mana=
ger.RDN.ToString().SubString(3))
}
}
}
elseif( $managedBy.Count -gt 0 )
{
$manager =3D $managedBy[0]
"Group manager: {0}, {1}" -f $manager.Name,=
($manager.Parent.ToString() + "/" + $manager.RDN.ToString().SubString(3))
}
"Members:"
Get-DistributionGroupMember -Identity $group.Identity -Resu=
ltSize Unlimited |% {
foreach( $member in $_ )
{
"`t$($member.Name)"
}
}
"---"
}
Regards,
Michael B. Smith
Consultant and Exchange MVP
http://TheEssentialExchange.com
From: Steven Peck [mailto:[email protected]]
Sent: Wednesday, August 18, 2010 3:35 PM
To: NT System Admin Issues
Subject: Re: Generating report for Exchange Distribution groups?
Different tack..... exploration rather then answer.
The PowerShell team tries hard to make cmdlet names 'discoverable' so
the Exchange module is a snapin and has 2 elements so this will get all the=
Exchange cmdlets loaded
Get-Command -Module Microsoft.Exchange.*
or you can guess by the name distribution group
Get-Command *distri*
Get-Command *group*
Either way this will get you to two commands
Get-DistributionGroup
Get-DistributionGroupMember
Using help to get examples and Get-member to see what is available
help Get-DistributionGroup -examples # (turns out to be sort of useless o=
n this command)
Get-DistributionGroup 'some group' | Get-Member # (more useful)
We see a managed by and Name property
So now you have the main command (get-distributiongroup) and need to expand=
it. Yay foreach-object (alias % expands to foreach-object) and do similia=
r Get-Memeber for the Get-DistributionGroupMember
Now Micheal's one liner is awesome and actually more useful then my quick t=
ry (you can pipe it to out-text) but I can't quite get there that fast yet.=
If the process is what caught you out, hopefully this will be helpful in =
a different way then his script.
Link to cool ebook: http://powershell.com/cs/blogs/ebook/
Have fun,
Steven Peck
http://www.blkmtn.org
On Wed, Aug 18, 2010 at 12:11 PM, Steven Peck <[email protected]<mailto:sepe=
[email protected]>> wrote:
No surprise, Micheals is better then mine. SO much for beating him :)
On Wed, Aug 18, 2010 at 12:03 PM, Greg Olson <[email protected]<mailto=
:[email protected]>> wrote:
Awesome, I will give this a shot.
Thanks MBS!
-Greg
-----Original Message-----
From: Michael B. Smith [mailto:[email protected]<mailto:mich...@smithco=
ns.com>]
Sent: Wednesday, August 18, 2010 12:01 PM
To: NT System Admin Issues
Subject: RE: Generating report for Exchange Distribution groups?
Ehhhh. You might also need a couple of resultsize parameters there, dependi=
ng on the size of your organization. (I just ran it at a larger customer of=
mine and ran into this.)
get-distributiongroup -resultsize unlimited |% {
$group =3D $_;
"Name: $($group.Name), ManagedBy: $($group.ManagedBy), Identity: $($=
group.Identity)"
$members =3D Get-DistributiongroupMember -identity $group.Identity -=
resultsize unlimited;
foreach ($member in $members) {
"`t$($member.Name)"
}
}
Regards,
Michael B. Smith
Consultant and Exchange MVP
http://TheEssentialExchange.com
-----Original Message-----
From: Michael B. Smith [mailto:[email protected]<mailto:mich...@smithco=
ns.com>]
Sent: Wednesday, August 18, 2010 2:55 PM
To: NT System Admin Issues
Subject: RE: Generating report for Exchange Distribution groups?
[PS] C:\>get-distributiongroup |% {
>> $group =3D $_;
>> "Name: $($group.Name), ManagedBy: $($group.ManagedBy), Identity: $($grou=
p.Identity)"
>> $members =3D Get-DistributiongroupMember -identity $group.Identity;
>> foreach ($member in $members) {
>> "`t$($member.Name)"
>> }
>> }
>>
Name: j-and-m, ManagedBy: smithcons.local/Users/Administrator, Identity: sm=
ithcons.local/Users/j-and-m
Michael B. Smith
Jacqui
...
Etc.
...
Regards,
Michael B. Smith
Consultant and Exchange MVP
http://TheEssentialExchange.com
-----Original Message-----
From: Greg Olson [mailto:[email protected]<mailto:[email protected]=
om>]
Sent: Wednesday, August 18, 2010 2:48 PM
To: NT System Admin Issues
Subject: Generating report for Exchange Distribution groups?
All,
Is there any way to generate a report that lists out all of our Distributio=
n groups, along with the members and owners of the lists? I see how to gene=
rate a listing of the groups, but not a way to have it put the members of e=
ach group and the owners as well.
I'm sure there is probably a PowerShell way of doing this, but my ps skills=
are weak and Google Fu is failing today. This is on Exchange 2007 and Out=
look 2010.
Thanks in advance for any help!
-Greg
~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http:=
//www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http:=
//www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http:=
//www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
--_000_206E053EFD8D754CB67242D59E47B8373A530A7FWin2008R2Ex2010_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"; xmlns=3D"http:=
//www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV=3D"Content-Type" CONTENT=
=3D"text/html; charset=3Dus-ascii"><meta name=3DGenerator content=3D"Micros=
oft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue vli=
nk=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><font size=3D2 c=
olor=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family=
:"Calibri","sans-serif";color:#1F497D'>Just in case you haven’t read =
enough about this already, I wrote a blog post on it. </span></font><font s=
ize=3D2 color=3D"#1f497d" face=3DWingdings><span style=3D'font-size:11.0pt;=
font-family:Wingdings;color:#1F497D'>J</span></font><font size=3D2 color=3D=
"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calib=
ri","sans-serif";color:#1F497D'><o:p></o:p></span></font></p><p class=3DMso=
Normal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-=
size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </=
o:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d"=
face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans=
-serif";color:#1F497D'><<a href=3D"http://bit.ly/cjHMky";>http://bit.ly/c=
jHMky</a>><o:p></o:p></span></font></p><p class=3DMsoNormal><font size=
=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-=
family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></font=
></p><div><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCali=
bri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";colo=
r:#1F497D'>Regards,<o:p></o:p></span></font></p><p class=3DMsoNormal><font =
size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;f=
ont-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></=
font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalib=
ri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color=
:#1F497D'>Michael B. Smith<o:p></o:p></span></font></p><p class=3DMsoNormal=
><font size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:1=
1.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Consultant and Exch=
ange MVP<o:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 co=
lor=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:=
"Calibri","sans-serif";color:#1F497D'>http://TheEssentialExchange.com<o:p><=
/o:p></span></font></p></div><p class=3DMsoNormal><font size=3D2 color=3D"#=
1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri=
","sans-serif";color:#1F497D'><o:p> </o:p></span></font></p><div><div =
style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0=
in'><p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span style=3D'fon=
t-size:10.0pt;font-family:"Tahoma","sans-serif";font-weight:bold'>From:</sp=
an></font></b><font size=3D2 face=3DTahoma><span style=3D'font-size:10.0pt;=
font-family:"Tahoma","sans-serif"'> Michael B. Smith <br><b><span style=3D'=
font-weight:bold'>Sent:</span></b> Wednesday, August 18, 2010 4:10 PM<br><b=
><span style=3D'font-weight:bold'>To:</span></b> NT System Admin Issues<br>=
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Generating repo=
rt for Exchange Distribution groups?<o:p></o:p></span></font></p></div></di=
v><p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=
=3D'font-size:12.0pt'><o:p> </o:p></span></font></p><p class=3DMsoNorm=
al><font size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size=
:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Interestingly, mi=
ne had a bug…<o:p></o:p></span></font></p><p class=3DMsoNormal><font =
size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;f=
ont-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></=
font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalib=
ri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color=
:#1F497D'>ManagedBy can be: [a] empty, [b] a single value, or [c] an array =
of values<o:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 c=
olor=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family=
:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></font></p><=
p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span s=
tyle=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>=
My solution only properly handles [a], and [b].<o:p></o:p></span></font></p=
><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span=
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D=
'><o:p> </o:p></span></font></p><p class=3DMsoNormal><font size=3D2 co=
lor=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:=
"Calibri","sans-serif";color:#1F497D'>So…we have to get a little smar=
ter, and I wanted to make the formatting a little nicer anyway. So thatR=
17;s below (I would consider this a “somewhat advanced” solutio=
n – it uses the format operator and embedded pipelines). To make it a=
dvanced would only require the addition of a delegate function to do the fo=
rmatting, so the formatting wouldn’t have to be repeated on each R=
20;manager” line.<o:p></o:p></span></font></p><p class=3DMsoNormal><f=
ont size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0=
pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></spa=
n></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DC=
alibri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";c=
olor:#1F497D'>A lesson learned here is this: to get q-and-d results, you ca=
n get by with a few lines of PowerShell. If you want “production qual=
ity”, then you’ll still need “production effort”. I=
t’ll still be a quarter the size of doing it in vbscript… :-P<o=
:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f=
497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";color:#1F497D'><o:p> </o:p></span></font></p><p class=3DM=
soNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'fon=
t-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>get-distrib=
utiongroup -resultsize unlimited |% {<o:p></o:p></span></font></p><p class=
=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D=
'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> &=
nbsp; &nbs=
p; $group =3D $_<o:p></o:p></span></font></p><p class=3DMsoNormal><fo=
nt size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0p=
t;font-family:"Calibri","sans-serif";color:#1F497D'>  =
; "G=
roup Name & Identity: {0}, {1}" -f $group.Name, $group.Identity<o:=
p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f4=
97d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri","=
sans-serif";color:#1F497D'> =
$managedBy =3D $group.ManagedBy<=
o:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1=
f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri"=
,"sans-serif";color:#1F497D'> &nbs=
p; if( $managedBy.Count -gt 1 )<o=
:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f=
497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";color:#1F497D'>  =
; {<o:p></o:p></span></font></p><=
p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span s=
tyle=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>=
&nb=
sp; =
[bool]$first =3D $true<o:p></o:p></spa=
n></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DC=
alibri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";c=
olor:#1F497D'> &=
nbsp; &nbs=
p; foreach( $manager in $ma=
nagedBy ) <o:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 =
color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-famil=
y:"Calibri","sans-serif";color:#1F497D'>  =
; &n=
bsp;  =
; {<o:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=
=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Ca=
libri","sans-serif";color:#1F497D'> &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; if( $first ) <o:p></o:p></span></font></p><p class=3DMsoN=
ormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-s=
ize:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> &n=
bsp;  =
; &n=
bsp;  =
; {<o:p></o:p></span></font></p><=
p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span s=
tyle=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>=
&nb=
sp; =
&nb=
sp; =
&nb=
sp; "Group managers: {0}, {1}" -f $manager.Name, ($manager.Parent=
.ToString() + "/" + $manager.RDN.ToString().SubString(3))<o:p></o=
:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" =
face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-=
serif";color:#1F497D'>  =
; &n=
bsp;  =
; &n=
bsp;  =
; $first =3D $false<o:p></o:p></span></font></p><p =
class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span sty=
le=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>&n=
bsp;  =
; &n=
bsp;  =
; }<o:p></o:p></span>=
</font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCal=
ibri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";col=
or:#1F497D'> &nb=
sp; =
&nb=
sp; else<=
o:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1=
f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri"=
,"sans-serif";color:#1F497D'> &nbs=
p; &=
nbsp; &nbs=
p; &=
nbsp; {<o:p></o:p></span></font></p><p class=3DMsoNormal><font size=
=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-=
family:"Calibri","sans-serif";color:#1F497D'> =
&nb=
sp; =
&nb=
sp; =
" &n=
bsp; {0},=
{1}" -f $manager.Name, ($manager.Parent.ToString() + "/" + =
$manager.RDN.ToString().SubString(3))<o:p></o:p></span></font></p><p class=
=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D=
'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> &=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; }<o:p></o:p></span></fon=
t></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri>=
<span style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1=
F497D'> &n=
bsp;  =
; }<o:p></o:p></span></font></p><=
p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span s=
tyle=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>=
&nb=
sp; }<o:p></o:p></span></font></p><p class=3DMsoNormal><font si=
ze=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;fon=
t-family:"Calibri","sans-serif";color:#1F497D'> &nbs=
p; elseif( $man=
agedBy.Count -gt 0 )<o:p></o:p></span></font></p><p class=3DMsoNormal><font=
size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;=
font-family:"Calibri","sans-serif";color:#1F497D'> &=
nbsp; {<o:p></o=
:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" =
face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-=
serif";color:#1F497D'>  =
; &n=
bsp; $manager =3D $ma=
nagedBy[0]<o:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 =
color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-famil=
y:"Calibri","sans-serif";color:#1F497D'>  =
; &n=
bsp;  =
; "Group manager: {0}, {1}" -f $manager.Name, ($manager.Parent.To=
String() + "/" + $manager.RDN.ToString().SubString(3))<o:p></o:p>=
</span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" fac=
e=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-ser=
if";color:#1F497D'> &n=
bsp; }<o:p></o:p></span></font></p><p class=
=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D=
'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p>&n=
bsp;</o:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1=
f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri"=
,"sans-serif";color:#1F497D'> &nbs=
p; "Members:"<o:p></o:p=
></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" fa=
ce=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-se=
rif";color:#1F497D'> &=
nbsp; Get-DistributionGroupMember -Identity $=
group.Identity -ResultSize Unlimited |% {<o:p></o:p></span></font></p><p cl=
ass=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span style=
=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>&nbs=
p; &=
nbsp; &nbs=
p; foreach( $member in $_ )<o:p></o:p></span>=
</font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCal=
ibri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";col=
or:#1F497D'> &nb=
sp; =
{<o:p></o:p></span></font>=
</p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><s=
pan style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F4=
97D'> &nbs=
p; &=
nbsp; &nbs=
p; "`t$($m=
ember.Name)"<o:p></o:p></span></font></p><p class=3DMsoNormal><font si=
ze=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;fon=
t-family:"Calibri","sans-serif";color:#1F497D'> &nbs=
p; &=
nbsp; &nbs=
p; }<o:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 =
color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-famil=
y:"Calibri","sans-serif";color:#1F497D'>  =
; }<o:p></o:p></span>=
</font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCal=
ibri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";col=
or:#1F497D'> &nb=
sp; "---"<o:p></o:p></span></font></p><p =
class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span sty=
le=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>}<=
o:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1=
f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri"=
,"sans-serif";color:#1F497D'><o:p> </o:p></span></font></p><p class=3D=
MsoNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'fo=
nt-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Regards,<o=
:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f=
497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";color:#1F497D'><o:p> </o:p></span></font></p><p class=3DM=
soNormal><font size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'fon=
t-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Michael B. =
Smith<o:p></o:p></span></font></p><p class=3DMsoNormal><font size=3D2 color=
=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Ca=
libri","sans-serif";color:#1F497D'>Consultant and Exchange MVP<o:p></o:p></=
span></font></p><p class=3DMsoNormal><font size=3D2 color=3D"#1f497d" face=
=3DCalibri><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-seri=
f";color:#1F497D'><a href=3D"http://TheEssentialExchange.com";>http://TheEss=
entialExchange.com</a><o:p></o:p></span></font></p><p class=3DMsoNormal><fo=
nt size=3D2 color=3D"#1f497d" face=3DCalibri><span style=3D'font-size:11.0p=
t;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span=
></font></p><p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span styl=
e=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";font-weight:bold'>F=
rom:</span></font></b><font size=3D2 face=3DTahoma><span style=3D'font-size=
:10.0pt;font-family:"Tahoma","sans-serif"'> Steven Peck [mailto:sep...@gmai=
l.com] <br><b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, =
August 18, 2010 3:35 PM<br><b><span style=3D'font-weight:bold'>To:</span></=
b> NT System Admin Issues<br><b><span style=3D'font-weight:bold'>Subject:</=
span></b> Re: Generating report for Exchange Distribution groups?<o:p></o:p=
></span></font></p><p class=3DMsoNormal><font size=3D3 face=3D"Times New Ro=
man"><span style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p><p=
class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D3 face=3D"Ti=
mes New Roman"><span style=3D'font-size:12.0pt'>Different tack..... e=
xploration rather then answer. <br><br>The PowerShell team tries hard=
to make cmdlet names 'discoverable' so <br>the Exchange module is a snapin=
and has 2 elements so this will get all the Exchange cmdlets loaded<br>&nb=
sp; Get-Command -Module Microsoft.Exchange.*<br>or you can guess by the nam=
e distribution group<br> Get-Command *distri*<br> Get-Command *=
group*<br> <br>Either way this will get you to two commands<br> =
Get-DistributionGroup<br> Get-DistributionGroupMember<br><br>Using h=
elp to get examples and Get-member to see what is available<br> help =
Get-DistributionGroup -examples # (turns out to be sort of useless on this =
command)<br> Get-DistributionGroup 'some group' | Get-Member # =
(more useful)<br>We see a managed by and Name property<br><br>So now you ha=
ve the main command (get-distributiongroup) and need to expand it. Ya=
y foreach-object (alias % expands to foreach-object) and do similiar Get-Me=
meber for the Get-DistributionGroupMember<br><br>Now Micheal's one liner is=
awesome and actually more useful then my quick try (you can pipe it to out=
-text) but I can't quite get there that fast yet. If the process is w=
hat caught you out, hopefully this will be helpful in a different way then =
his script.<br><br>Link to cool ebook: <a href=3D"http://powershell.com/cs/=
blogs/ebook/">http://powershell.com/cs/blogs/ebook/</a><br><br>Have fun,<br=
>Steven Peck<br><a href=3D"http://www.blkmtn.org";>http://www.blkmtn.org</a>=
<o:p></o:p></span></font></p><div><p class=3DMsoNormal><font size=3D3 face=
=3D"Times New Roman"><span style=3D'font-size:12.0pt'>On Wed, Aug 18, 2010 =
at 12:11 PM, Steven Peck <<a href=3D"mailto:[email protected]";>sep...@gma=
il.com</a>> wrote:<o:p></o:p></span></font></p><div><p class=3DMsoNormal=
style=3D'margin-bottom:12.0pt'><font size=3D3 face=3D"Times New Roman"><sp=
an style=3D'font-size:12.0pt'>No surprise, Micheals is better then mine.&nb=
sp; SO much for beating him :)<o:p></o:p></span></font></p></div><div><div>=
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D=
'font-size:12.0pt'>On Wed, Aug 18, 2010 at 12:03 PM, Greg Olson <<a href=
=3D"mailto:[email protected]"; target=3D"_blank">[email protected]=
</a>> wrote:<o:p></o:p></span></font></p></div><div><div><blockquote sty=
le=3D'border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt=
;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'><=
p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:12.0pt'>Awesome, I will give this a shot.<br>Thanks MBS!<br><font=
color=3D"#888888"><span style=3D'color:#888888'>-Greg</span></font><o:p></=
o:p></span></font></p><div><p class=3DMsoNormal><font size=3D3 face=3D"Time=
s New Roman"><span style=3D'font-size:12.0pt'><br><br>-----Original Message=
-----<br>From: Michael B. Smith [mailto:<a href=3D"mailto:mich...@smithcons=
.com" target=3D"_blank">[email protected]</a>]<br>Sent: Wednesday, Augu=
st 18, 2010 12:01 PM<br>To: NT System Admin Issues<o:p></o:p></span></font>=
</p></div><div><p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"=
><span style=3D'font-size:12.0pt'>Subject: RE: Generating report for Exchan=
ge Distribution groups?<br><br>Ehhhh. You might also need a couple of resul=
tsize parameters there, depending on the size of your organization. (I just=
ran it at a larger customer of mine and ran into this.)<br><br>get-distrib=
utiongroup -resultsize unlimited |% {<br> $group =
=3D $_;<br> "Name: $($group.Name), ManagedBy=
: $($group.ManagedBy), Identity: $($group.Identity)"<br> =
$members =3D Get-DistributiongroupMember -identity $group.Iden=
tity -resultsize unlimited;<br> foreach ($member =
in $members) {<br> &q=
uot;`t$($member.Name)"<br> }<br>}<br><br>Reg=
ards,<br><br>Michael B. Smith<br>Consultant and Exchange MVP<br><a href=3D"=
http://TheEssentialExchange.com"; target=3D"_blank">http://TheEssentialExcha=
nge.com</a><br><br><br>-----Original Message-----<o:p></o:p></span></font><=
/p></div><div><p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman">=
<span style=3D'font-size:12.0pt'>From: Michael B. Smith [mailto:<a href=3D"=
mailto:[email protected]"; target=3D"_blank">[email protected]</a>]<=
br>Sent: Wednesday, August 18, 2010 2:55 PM<br>To: NT System Admin Issues<o=
:p></o:p></span></font></p></div><div><p class=3DMsoNormal style=3D'margin-=
bottom:12.0pt'><font size=3D3 face=3D"Times New Roman"><span style=3D'font-=
size:12.0pt'>Subject: RE: Generating report for Exchange Distribution group=
s?<br><br>[PS] C:\>get-distributiongroup |% {<br>>> $group =3D $_;=
<br>>> "Name: $($group.Name), ManagedBy: $($group.ManagedBy), Id=
entity: $($group.Identity)"<br>>> $members =3D Get-Distributiong=
roupMember -identity $group.Identity;<br>>> foreach ($member in $memb=
ers) {<br>>> "`t$($member.Name)"<br>>> =
}<br>>> }<br>>><br>Name: j-and-m, ManagedBy: smithcons.local/Us=
ers/Administrator, Identity: smithcons.local/Users/j-and-m<br> =
Michael B. Smith<br> Jacqui<br>...<=
br>Etc.<br>...<br><br>Regards,<br><br>Michael B. Smith<br>Consultant and Ex=
change MVP<br><a href=3D"http://TheEssentialExchange.com"; target=3D"_blank"=
>http://TheEssentialExchange.com</a><o:p></o:p></span></font></p></div><div=
><div><p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D3 fa=
ce=3D"Times New Roman"><span style=3D'font-size:12.0pt'>-----Original Messa=
ge-----<br>From: Greg Olson [mailto:<a href=3D"mailto:[email protected]=
m" target=3D"_blank">[email protected]</a>]<br>Sent: Wednesday, August=
18, 2010 2:48 PM<br>To: NT System Admin Issues<br>Subject: Generating repo=
rt for Exchange Distribution groups?<br><br>All,<br>Is there any way to gen=
erate a report that lists out all of our Distribution groups, along with th=
e members and owners of the lists? I see how to generate a listing of the g=
roups, but not a way to have it put the members of each group and the owner=
s as well.<br>I'm sure there is probably a PowerShell way of doing this, bu=
t my ps skills are weak and Google Fu is failing today. This is on Exchange=
2007 and Outlook 2010.<br>Thanks in advance for any help!<br>-Greg<b=
r><br><br>~ Finally, powerful endpoint security that ISN'T a resource hog! =
~ ~ <<a href=3D"http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise=
/" target=3D"_blank">http://www.sunbeltsoftware.com/Business/VIPRE-Enterpri=
se/</a>> ~<br><br><br>~ Finally, powerful endpoint security that I=
SN'T a resource hog! ~ ~ <<a href=3D"http://www.sunbeltsoftware.com/Busi=
ness/VIPRE-Enterprise/" target=3D"_blank">http://www.sunbeltsoftware.com/Bu=
siness/VIPRE-Enterprise/</a>> ~<br><br><br>~ Finally, powerful end=
point security that ISN'T a resource hog! ~ ~ <<a href=3D"http://www.sun=
beltsoftware.com/Business/VIPRE-Enterprise/" target=3D"_blank">http://www.s=
unbeltsoftware.com/Business/VIPRE-Enterprise/</a>> ~<br><br><br>~ =
Finally, powerful endpoint security that ISN'T a resource hog! ~<br>~ <<=
a href=3D"http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/"; target=
=3D"_blank">http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/</a>&g=
t; ~<o:p></o:p></span></font></p></div></div></blockquote></div></div=
></div><p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span s=
tyle=3D'font-size:12.0pt'><o:p> </o:p></span></font></p><p><font size=
=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p><=
/o:p></span></font></p><pre><font size=3D2 face=3D"Courier New"><span style=
=3D'font-size:10.0pt'> <o:p></o:p></span></font></pre></div><p class=
=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'font-si=
ze:12.0pt'><o:p> </o:p></span></font></p><p><font size=3D3 face=3D"Tim=
es New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></fo=
nt></p><pre><font size=3D2 face=3D"Courier New"><span style=3D'font-size:10=
.0pt'> <o:p></o:p></span></font></pre></div>
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
<BR>
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
</BODY></html>=
--_000_206E053EFD8D754CB67242D59E47B8373A530A7FWin2008R2Ex2010_--
