Microsoft 365
Reads the licenses of all customer tenants from Microsoft Graph via GDAP (granular delegated admin privileges): what is booked ("Verkauft" = sold) and what is assigned to users ("Zugewiesen" = assigned).
Prerequisites
- A multi-tenant app registration in the partner tenant with the delegated Graph permissions
Organization.Read.AllandDelegatedAdminRelationship.Read.All— plusUser.Read.Allfor the export of the licensed users. - A service account that is a member of the GDAP security group (the "Directory Readers" role is sufficient) — it reads all customer tenants on your behalf.
Credentials (gear icon)
| Field | Meaning |
|---|---|
| App ID (Client ID) | the multi-tenant app registration |
| Client Secret | secret of the app |
| Partner tenant ID | GUID or partner.onmicrosoft.com |
| Refresh token | do not fill in by hand — set via "Connect service account" in the view and renewed automatically |
Setup: fill in the gear dialog (without refresh token) → in the view, "Connect service account" → Microsoft login with the service account → done.
Metrics
Two rows per customer and product:
Verkauft › <Produkt>— licenses booked in the tenant (subscribedSkus)Zugewiesen › <Produkt>— licenses assigned to users
Free/bundled SKUs (e.g. Flow Free) are filtered out. The dashboard tile counts the assigned licenses.
Export of the licensed users
Licensed users (CSV) in the view's toolbar exports the users of every customer tenant that hold a license the view counts, read live through GDAP when the button is clicked: one row per user and license — customer, user (user principal name), name, license, SKU and whether the account is enabled. Free and self-service SKUs are left out, as everywhere in the view; a disabled account that still holds a license shows "no" under Account enabled — a license to reclaim. The customer filter of the export dialog narrows the tenants.
Reading users needs one more delegated Graph permission, User.Read.All, and Microsoft asks every customer tenant to consent to it — the consent given so far covers only the license counts. Once:
- In the Microsoft Entra admin center of the partner tenant: the app registration → API permissions → Add a permission → Microsoft Graph → Delegated permissions →
User.Read.All→ add it, then Grant admin consent for the partner tenant. - Click Licensed users (CSV). Every tenant that has not consented to the new permission yet is listed in the export dialog with its consent link: open each one, sign in with an account that may consent in that tenant (a GDAP role such as Cloud Application Administrator, or the customer's admin) and accept. Click the export again — the consented tenants are now in it.
The service account's GDAP role "Directory Readers" already reads users; nothing changes there. Until a tenant consents, its users are missing from the export (the dialog says so) — the license counts, the snapshots and the ALSO comparison are not affected.
ALSO comparison & product mappings
The view contains two additional tabs:
- ALSO comparison: sets purchases (ALSO) against the tenant inventory per customer — the join runs on stable IDs (tenant ID, skuId), name matching only as a fallback. Details: product mappings.
- Product mappings: merge list for diverging product names.
Specifics
- Tenant IDs are stable → automatic rename detection.
- Tenants without a readable display name initially appear with their GUID and are upgraded automatically as soon as the first real name arrives.