Link to home
Start Free TrialLog in
Avatar of pramod1
pramod1Flag for United States of America

asked on

ACTIVE DIRECTORY, EXCHANGE, distribution groups

i have around 60 to 70 distribution groups in on premise active directory which are synced through AAD sync to Azure AD.

i have been asked to find distribution groups which are stale not being used or sort by very less members to highest members
or find overlapping members in groups.

basically asked to clean the groups.

any idea which i should look what to clean in distribution groups
Avatar of Saif Shaikh
Saif Shaikh
Flag of India image

Create a non-sync OU and move the unwanted DG's to this group.

Run the delta sync which will sync the required only DG's in O365.

and you are done.

Basically you will have to find the one's on your own which are not being used or does not have members in it or email addresses.
any idea which i should look what to clean in distribution groups

Well what exactly are you trying to do? You listed several different scenarios in the original question, all of which require different approach. If you want to determine which DGs are "being used", you will have to query the message tracking logs, you can find an example here: https://social.technet.microsoft.com/Forums/exchange/en-US/a9ca95d8-16ec-4916-86b0-e1c6ced3521a/determine-the-last-time-distribution-group-recieved-email?forum=exchangesvradminlegacy
Avatar of pramod1

ASKER

istribution group members.

how can we find and export the name and members of every distribution list on our active directory  so i can find in which distribution group the members are very low
There are literally dozens of script out there that do just that. Here's a sample one: https://gallery.technet.microsoft.com/scriptcenter/Distribution-Group-Report-d32c4788

Or if you want to do it directly in O365: https://gallery.technet.microsoft.com/office/List-all-Users-Distribution-7f2013b2
Here is my suggestion:

You pull the DG owners, send them an email and ask them to review, if they need these DG or members in the DG. As per the reply from DG owner, you take next action.
ASKER CERTIFIED SOLUTION
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial