Powershell Corporate Report for DistributionGroups

Pu_MailingGroupStatistics

I am working on a new naming convention for a corporate address book. They are running Exchange 2010. The process includes converting group restriction with moderation, and populates the Manager attribute for all groups beside other stuff.

I have created a PowerShell script that will scan the whole organization and send an email to IT Admins that contains three things:

  1.     Summary Statistics
  2.     Detailed CSV about each distribution group
  3.     Detailed CSV about each Dynamic Group

 Summary Statistics includes:

  •      Total Number of Distribution Groups and Total Number of Dynamic Groups
  •      Number of Empty Groups
  •      Number of groups that requires Sender Authentication
  •      Number of empty groups
  •      Number of groups without manager
  •      Number of (Open to Join) groups
  •      Number of (Approve to Join) groups
  •      Number of (Closed to join) groups
  •      Number of (Open to depart) groups
  •      Number of (Closed to depart) groups
  •      Number of invalid groups
  •      Number of Moderated Groups

Each CSV File contains info about each group including:

  •          Group Name
  •          Group Member Count
  •          Group Parent OU
  •          Group Hidden or not
  •          Group Moderated or not
  •         Group Requiring Sender Authentication or not
  •          Group valid or not
  •          Group Type ( universal, global,…) and (security enabled or not)
  •          Group Manager
  •          Group Empty or not
  •          Group contains nested groups or not

Note: Thanks to this article . I took the idea and modify it :

http://gallery.technet.microsoft.com/scriptcenter/Generate-HTML-Report-for-57ed7b33 

Please find the final script attached to this post 

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s