A client's page has a Breakdown of its Microsoft 365 people, what their licenses cost each month and the waste SeatReaper found, split three ways. Choose under Group by:
- Email domain: one Microsoft 365 tenant often holds several businesses (a group of shops, a parent and its brands), each with its own domain. This shows which business the waste belongs to. Guests are listed together.
- Location: the person's office in Microsoft 365, or else their city (with the state). "Hazelwood" and "Hazelwood, MO" count as one place.
- Department: the department in Microsoft 365.
When you have not chosen, the page shows the domain view if the tenant has two or more businesses' domains, else the location view, else the department view; the breakdown is hidden when none of them has anything to group on.
The columns
| Column | What it is |
|---|---|
| People | Everyone in the group, licensed or not |
| Licensed | People holding at least one license you have not set to Ignore |
| Licenses / month | What those licenses cost each month, from your price book. Licenses with no price are counted below the amount |
| Blocked or inactive | People in the queue as blocked or inactive and still licensed, and what they cost |
| Already included | Licenses a person already has inside another license (see License already included in another), and what they cost |
Items you marked Keep (needed) in the queue are left out. Unassigned licenses belong to the whole tenant, not to a person, so they are not split; they are in the queue.
Where the data comes from
Office, city, state and department come from each person's Microsoft 365 account: from the daily sync when the tenant is connected, or from the Active users export. They are only as complete as the client keeps them; people without them are grouped as No location set or No department set. To fill them in, update the people in the Microsoft 365 admin center and sync (or export and import) again.
Download CSV saves the view you are looking at, with plain numbers for a spreadsheet.