Connecting Microsoft 365 needs an admin of the customer's tenant to approve SeatReaper. When that is not possible yet (a prospect a sales rep is talking to, or a client whose admin will not approve an app), the customer's admin can export two lists from the Microsoft 365 admin center and you import them on the client's page. SeatReaper treats them like a sync: the queue, the client's page and the reports, including the Prospect Waste Assessment, use them.
What to ask the customer's admin for
- Active users (required). In the Microsoft 365 admin center, open Users > Active users and choose Export users. The file has each person's name, user principal name, Object Id, whether sign-in is blocked, the licenses they hold, when the account was created, and their office, city, state and department.
- Licenses (optional): how many of each license were bought. Any CSV with a product name column and a total column (or assigned and available columns) works, for example the licenses list in the admin center if it offers an export, or a list the admin types up.
Exporting is read-only and takes a minute. The files hold names and email addresses, so ask the admin to send them the way they would send any customer data.
Import
A new customer: choose Add client, type the name, and on step 2 (Microsoft 365) leave the tenant ID empty and choose the Active users export under No admin access?. SeatReaper checks the file right away and imports it when you add the client.
A client you already have: on the client's page, under Microsoft 365, find No admin access? Import a CSV, choose the Active users export (and the Licenses export if you have it), and Import CSV.
Owners and techs who may connect client tools can import. Clients > Import CSV is for a list of clients, not these exports.
SeatReaper shows how many users it imported, how many hold licenses, how many blocked accounts still have licenses, how many licenses are unassigned, and how many findings are open.
What it finds
- Blocked accounts that still have licenses: someone who left, whose sign-in was blocked but whose licenses were never removed. The same finding a sync makes.
- Unassigned licenses: bought but not assigned to anyone. How many were bought comes from the Licenses export, or, without it, from this client's Pax8 subscriptions (the API or a Pax8 import) for the same license. With neither, nothing is flagged as unassigned.
- Seats in other tools with no Microsoft 365 account, when other tools are connected for the client.
Set what each license costs in the price book to see the dollar amounts. Free licenses (such as Power Automate Free) start as Ignore.
What it cannot find
- Inactive accounts. The export has no sign-in dates, so SeatReaper does not check who has not signed in, and the user list says sign-in dates are unavailable. Connect Microsoft 365 for that.
- Anything that changed after the export. Nothing updates on its own: import new files to refresh. Importing again replaces everything imported before for that client. Remove imported data deletes it.
Licenses are matched by name
The export names licenses ("Microsoft 365 Business Premium", "Intune") instead of Microsoft's part numbers. SeatReaper recognizes the common Microsoft 365, Office 365, Exchange Online, Entra ID, Intune, Copilot and free licenses; any other license is kept under the name in the file, and its price is set under that name.
When the tenant is connected later
When an admin later approves SeatReaper's access, the first sync replaces the imported data and SeatReaper reads Microsoft 365 directly from then on, sign-in dates included. You cannot import while Microsoft 365 is connected for that client. Findings already in the queue stay; the sync confirms or closes them.
Limits
One file can have up to 10,000 users and must be under 950 KB (about 3,000 users of the standard export). The Licenses file can have up to 500 rows.