Entra ID Groups Licence Statistics
The question it answers: How many members does each licensing group have, how many of them got the licence from it, and how many failed?
At a glance
Section titled “At a glance”| Where in the app | Licensing › Groups › Groups Licence Statistics |
| 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). It reads through PowerShell (Exchange Online or SharePoint Online), so the first load takes longer than a Graph report. |
| Licence | Microsoft Entra ID P1 (group-based licensing). |
| Report id (API and MCP) | entra.groups.licence-statistics |
Columns
Section titled “Columns”| Column | Key | Type |
|---|---|---|
| Display Name | DisplayName | Text |
| Licences | Licenses | Text |
| Licence Total User Count | LicenseTotalUserCount | Text |
| Licensed User Count | LicensedUserCount | Text |
| Licence Error Count | LicenseErrorCount | Text |
What it needs
Section titled “What it needs”Licence: Microsoft Entra ID P1 (group-based licensing).
Application permissions on the IntensiveReports app registration (all permissions):
| Permission | API | What it allows | Note |
|---|---|---|---|
Group.Read.All | Microsoft Graph | Read all groups | |
User.Read.All | Microsoft Graph | Read all users’ full profiles |
Data sources it reads
PowerShell: Get-MgGroup -All -Property DisplayName, Id, AssignedLicensesPowerShell: Get-MgUser -All -Property Id, LicenseAssignmentStatesPowerShell: Get-MgGroupMember -GroupId -All (per licensed group)
Through the API and MCP
Section titled “Through the API and MCP”GET /ir-api/v1/reports/entra.groups.licence-statistics?size=100An AI assistant reads it with the MCP tool get_report and the id entra.groups.licence-statistics. The client needs the Read grant for Entra ID. See Using the API.