Teams Inventory - Ownerless & Inactive Teams

The question it answers: Which teams have no working owner, only one owner, or no activity in the last 90 days?

A team without a working owner cannot be governed: nobody approves members, renews the group or cleans up guests. Teams nobody used for 90 days still hold files, chats and guest access. Both are listed first.

Note

If ‘Display concealed user, group, and site names in all reports’ is on in the Microsoft 365 admin centre (Settings > Org settings > Reports), the activity columns cannot be matched and stay empty.

At a glance

Where in the app	Tenant › Teams Inventory
Workload	Teams and collaboration
Kind	Table
Data	Built from the tenant data IntensiveReports keeps in memory and refreshes in the background, so it opens at once.
Licence	Microsoft Teams.
Report id (API and MCP)	tenant.teams.inventory

Columns

Column	Key	Type
Team	DisplayName	Link
Findings	FindingsString	Status
Owners	Owners	Text
Active owners	ActiveOwnerCount	Text
Visibility	Visibility	Text
Last activity	LastActivityDate	Date
Active users (90d)	ActiveUsers90Days	Text
Guests	Guests	Text
Created	CreatedDateTime	Date

Filters

Filter	Key (API)	On when the page opens
Only teams with a finding	finding	Yes

What it needs

Licence: Microsoft Teams.

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

Permission	API	What it allows	Note
Group.Read.All	Microsoft Graph	Read all groups
Reports.Read.All	Microsoft Graph	Read all usage reports

Data sources it reads

• GET /v1.0/groups?$filter=resourceProvisioningOptions/Any(x:x eq 'Team')
• GET /v1.0/groups/{id}/owners
• GET /v1.0/reports/getTeamsTeamActivityDetail(period='D90')

Through the API and MCP

GET /ir-api/v1/reports/tenant.teams.inventory?size=100
GET /ir-api/v1/reports/tenant.teams.inventory?filter=finding

An AI assistant reads it with the MCP tool get_report and the id tenant.teams.inventory. The client needs the Read grant for Teams and collaboration. See Using the API.