All Microsoft 365 Groups

The question it answers: Which Microsoft 365 groups exist, with their primary address and number of direct members?

Note

Member counts come from one Graph call per group (direct members), so large tenants take a while. A failed lookup shows an error instead of an incomplete list.

At a glance

Where in the app	Entra ID › Groups › Microsoft 365
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	Exchange Online.
Report id (API and MCP)	entra.groups.microsoft365

Columns

Column	Key	Type
Display Name	DisplayName	Text
Primary Address	Mail	Text
Member Count	MemberCount	Text

What it needs

Licence: Exchange Online.

Application permissions on the IntensiveReports app registration (all permissions):

Permission	API	What it allows	Note
Exchange.ManageAsApp	Office 365 Exchange Online	Manage Exchange As Application	+ View-Only Recipients
Group.Read.All	Microsoft Graph	Read all groups

Data sources it reads

• PowerShell: Get-UnifiedGroup -ResultSize Unlimited
• PowerShell: Get-MgGroupMemberCount -GroupId (per group; GET /v1.0/groups/{id}/members/$count)

Through the API and MCP

GET /ir-api/v1/reports/entra.groups.microsoft365?size=100

An AI assistant reads it with the MCP tool get_report and the id entra.groups.microsoft365. The client needs the Read grant for Entra ID. See Using the API.