Forum Discussion
Office 365 Users who are not a member of any group
Hi,
I want to get (Powershell & GUI) the users who are not included in any one of the my office 365 groups (Ex: ind_sol, indian_all_employees,client_sol, BD-internal groups)
The Get-Mailbox cmdlet will not return any group membership, including that to unified groups. Since I seem t have forgotten to include a link to the script in my first post, try it now: https://gallery.technet.microsoft.com/Office-365-MemberOf-aec693c9?redir=0
6 Replies
Well, define groups? If you only care about Exchange groups, this script will go over the list of users, generate a report of the group membership for each of them, and export to CSV file, where you can easily filter out "empty" values (when a user is not a member of any group).
As the script runs Exchange Remote PowerShell, it will only include groups Exchange "knows" about, such as DGs, mail-enabled SGs and "modern" Office 365 groups. If you want to include "regular" security groups as well, you will need to query Azure AD directly.
I am running below script, but i am unable to get users belonging group
Get-MailBox | Select-Object UserPrincipalName, DisplayName, UnifiedGroup, Alias |
Export-CSV "C:\users\xxxx\desktop\users.csv"The Get-Mailbox cmdlet will not return any group membership, including that to unified groups. Since I seem t have forgotten to include a link to the script in my first post, try it now: https://gallery.technet.microsoft.com/Office-365-MemberOf-aec693c9?redir=0
