Select Page

Email Groups Exchange Statistics

Email Groups Exchange Statistics
Advertisement

Email Groups Exchange Statistics

In this blog post, I will be talking about Exchange statistics when it comes to distribution groups. One of the simplest things in Exchange, is to query email distribution groups from the GUI management console, or with one PowerShell command. So why bothering to blog or script about it?. Well, sometimes, you get a project to standardize mailing groups names, or to assign a manager to each mailing group so he can manage it.

Sometimes, you want to get an overall view (statistics) in nice format, so that you can present it in to your team, or may be you want to find out which mailing groups are empty and thus want to do some cleanup.

In all cases, you just need to run a script , identify where you stand in regards to mailing groups, and evaluate if there is something to be done or not. Nothing can go bad if you have an overview script to generate such report at least once. This is what Exchange statistics email groups script is all about.

Running the Script from Exchange PowerShell Console Experience

Exchange statistics email groups script can be scheduled to run in a certain schedule and get nice email reports, or just run it directly without any switches from the Exchange PowerShell console from an account that is member of the Exchange View Only group.

You need only to modify the SMTP setting in the Customize Script section of the Exchange statistics email groups script to receive the output email report.

The Exchange statistics email groups script when run form PowerShell Console, give you a nice and rich experience, where it will list the script description, version , and will breakdown in real time every operation that is running and when possible, a progress bar for long running tasks.

Finally, the Exchange statistics email groups script will give you a timer with the time spent in certain tasks in a nice friendly way.

Exchange Statistics

Script details

By running the Exchange statistics email groups script, you will get an email with HTML table that contains organization statistics for groups and two attached csv files. One for extensive information for non dynamic groups, and one for dynamic groups.

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.
  • Two CSV files, one for dynamic groups and one for non dynamic 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 Type ( universal, global,…) and (security enabled or not)
    • Group Manager.
    • Group Empty or not.
    • Group contains nested groups or not.

Release notes

You just download and run the Exchange statistics email groups script from Exchange PowerShell console with account that has View access to Exchange data. The script will take long time to run (about an hour for medium environment that have 4000 mail groups

The script is a modified version from Serkan Varoğlu script. instead of viewing all data in HTML format, I exported all info in Excel files and aggregate data differently. Please visit his own script version here and have a look.

About The Author

Ammar Hasayen

Ammar is a digital transformer, cloud architect, public speaker and blogger. He is considered a trusted advisory with the ability to quickly navigate complex multi-cultural organizations and continuously improve and motivate cross-functional teams to achieve higher productivity, collaboration, revenue gain and cross-group knowledge sharing. His contributions to the tech community helped him get awarded the Microsoft Most Valuable Professional. Ammar appears in a lot of global conferences, and he has many publications about digital transformation and next generation technologies.

Leave a reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Hi, I’m Ammar Hasayen

Ammar-New-MVP

About Me

Cloud Architect | Cybersecurity | CISSP | Microsoft MVP | Pluralsight Author | Book Author | International Speaker | World Explorer | @ammarhasayen

 

LinkedIn Profile

My Pluralsight Course

Speaking at Microsoft Ignite Dubai

Ammar Hasayen Speaker Ignite

Pin It on Pinterest