User Excessive Group Membership (10)
The question it answers: Which users are direct members of more than 10 groups?
At a glance
Section titled “At a glance”| Where in the app | Entra ID › Users › Excessive Group Membership |
| Workload | Entra ID |
| Kind | Table |
| Data | Read from Microsoft 365 when someone first opens it, then kept for the report cache lifetime (Settings > Data & cache, 1 hour unless changed). |
| Licence | No extra licence needed. |
| Report id (API and MCP) | entra.users.excessive-group-membership |
Columns
Section titled “Columns”| Column | Key | Type |
|---|---|---|
| Display Name | DisplayName | Text |
| User Principal Name | UserPrincipalName | Text |
| Groups | GroupCount | Text |
What it needs
Section titled “What it needs”Licence: No extra licence needed.
Application permissions on the IntensiveReports app registration (all permissions):
| Permission | API | What it allows | Note |
|---|---|---|---|
User.Read.All | Microsoft Graph | Read all users’ full profiles | |
GroupMember.Read.All | Microsoft Graph | Read all group memberships |
Data sources it reads
GET /v1.0/users?$select=id,displayName,userPrincipalNameGET /v1.0/users/{id}/memberOf (per user)
Through the API and MCP
Section titled “Through the API and MCP”GET /ir-api/v1/reports/entra.users.excessive-group-membership?size=100An AI assistant reads it with the MCP tool get_report and the id entra.users.excessive-group-membership. The client needs the Read grant for Entra ID. See Using the API.