Groups
Every group, its owners and members, nested expanded
Every group in Microsoft Entra, of every kind, with who owns it and who is in it - including the people who are in it only through another group. Nothing is changed.
Reads only. Nothing in SharePoint is changed.
What does it tell you?
- One row per group: Microsoft 365, security, mail-enabled security or distribution list; its dynamic rule and whether the rule is running; owners and how many can still sign in; direct members; people reached through nested groups; whether it is a team and, if you ask, its SharePoint site.
- A membership sheet with every member of every group, direct or nested, and the path it is reached by (A > B > C).
- Empty groups and groups with no enabled owner, flagged.
How it runs
- Sign in once. Reports › Groups. Sign in as yourself with a role that can read the directory, such as Global Reader.
- Sites, if you want them. Also look up each Microsoft 365 group's SharePoint site. One more call per group.
- Run report. The run screen lists each thing it reads as it goes: Microsoft's reports, the directory, and each site. Stop offers Finish, which reads nothing new and builds the report from what was read, or Stop now.
- Read the result. The Done screen gives the headline and anything that could not be read. The workbook goes into History; Save report keeps a copy where you choose. Its About sheet names every source and what came of it.
What do you need?
- Global Reader, Groups Administrator or Global Administrator. The report makes no SharePoint call.
What will it not do?
- Distribution lists and mail-enabled security groups are managed in Exchange. Their Exchange managers are not Entra owners, so one with no owner in Entra says so rather than being called abandoned.
- A group seen again on its own path (a loop) is listed once and not followed again.
- A Microsoft 365 group's site is made the first time its files are opened; one that has none yet says so.
- A read that did not happen is shown as not read, never as an empty result: a site the report could not open keeps its row, with why, and nothing is concluded from it.