Microsoft 365 Adoption by Department

The question it answers: How actively does each department use Teams, Outlook, the Office apps, OneDrive and Copilot?

Licences are bought per person; value comes from use. Which departments actually work in Teams, Outlook, the Office apps and OneDrive - and which pay for suites they barely touch? Low-adoption departments are candidates for training, champions or a cheaper licence.

Note

Only enabled, licensed members are counted. Hashed names in usage reports (concealed-names setting) make every department look inactive. See Directory Data Quality for users without a department.

At a glance

Where in the app	Licensing › Adoption by Department
Workload	Licensing
Kind	Table
Data	Built from the tenant data IntensiveReports keeps in memory and refreshes in the background, so it opens at once.
Licence	None; the Copilot column needs Microsoft 365 Copilot (for the users scored).
Report id (API and MCP)	entra.licensing.department-adoption

Columns

Column	Key	Type
Department	Department	Text
Users	Users	Text
Active	ActivePercent	Status
Teams	TeamsPercent	Text
Outlook	OutlookPercent	Text
Word	WordPercent	Text
Excel	ExcelPercent	Text
PowerPoint	PowerPointPercent	Text
OneDrive	OneDrivePercent	Text
Copilot	CopilotPercent	Text

What it needs

Licence: None; the Copilot column needs Microsoft 365 Copilot (for the users scored).

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

Permission	API	What it allows	Note
Reports.Read.All	Microsoft Graph	Read all usage reports
User.Read.All	Microsoft Graph	Read all users’ full profiles
User-LifeCycleInfo.Read.All	Microsoft Graph	Read all users’ lifecycle information

Data sources it reads

• GET /v1.0/reports/getM365AppUserDetail(period='D30')
• GET /v1.0/reports/getOffice365ActiveUserDetail(period='D90') (OneDrive)
• GET /v1.0/copilot/reports/getMicrosoft365CopilotUsageUserDetail(period='D30')
• GET /v1.0/users (department)

Through the API and MCP

GET /ir-api/v1/reports/entra.licensing.department-adoption?size=100

An AI assistant reads it with the MCP tool get_report and the id entra.licensing.department-adoption. The client needs the Read grant for Licensing. See Using the API.