Forum Discussion
Office 365 Users who are not a member of any group
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
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
Thanks for the reply Michev.
While i am running "Get-DGMembershipInventory -IncludeUserMailboxes | Export-Csv C:\users\xxxx\desktop\Gusers.csv " it is throwing unrecognized error " Get-DGMembershipInventory : The term 'Get-DGMembershipInventory' is not recognized as the name of a cmdlet, function,script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again." I am tryning to install the module but it won't available : Install-Module -Name DGMembershipInventory.
As i am new to PowerShell i don't want to use whole script which is available in the url which you have shared with me.
The script is pretty much this one cmdlet, just run it as shown in the examples.