Read a Microsoft Graph users export
Paste the JSON that Microsoft Graph returns for List users, or drop the file on the paste box. Every user becomes one line: the user principal name, whether the account is enabled, the last sign-in, when the password last changed, the user type and, when the request expands them, the manager and the groups and roles.
What to export
The users, from GET /users on the v1.0 endpoint, with a $select naming the fields below: most of them are returned only when selected. signInActivity needs the AuditLog.Read.All permission and a P1 or P2 licence; when it is selected a page holds up to 500 users. Follow @odata.nextLink for the next page and paste each page one after another. manager and memberOf are relationships, read only when the request expands them.
GET https://graph.microsoft.com/v1.0/users?$select=id,userPrincipalName,displayName,accountEnabled,userType,employeeType,createdDateTime,lastPasswordChangeDateTime,signInActivity,department,employeeId,mail&$top=500The fields read
| Field in the export | Read as |
|---|---|
userPrincipalName | the account (mail when it is missing) |
displayName | the display name |
userType, employeeType | the type: Guest reads as a guest; for a member, employeeType when it is filled |
accountEnabled | enabled: true is enabled, false is disabled and set aside |
signInActivity.lastSignInDateTime | last used, an interactive sign-in field; absent, empty or the zero date reads as not recorded |
signInActivity.lastNonInteractiveSignInDateTime | a note |
lastPasswordChangeDateTime | last changed |
createdDateTime | created |
manager (displayName, when expanded) | the manager |
memberOf (displayName, when expanded) | member of: an administrative group or directory role marks the account privileged |
department, employeeId | notes |
id | joins pages of the same user; not shown |
What the users export does not carry
- No sign-in for some users. The documentation says signInActivity is not returned for a user who never signed in or who last signed in before Microsoft Graph began recording it; those lines read last used not recorded, never as dormant.
- Applications are not users. App registrations and service principals are listed elsewhere in Microsoft Graph and are not in this export; paste their own export as a table.
- No owner column. The manager, when expanded, owns a service or shared account; otherwise a non-person account comes back as finding 3.
The checker reads the JSON in your browser: nothing is uploaded and no connection is made to the system it came from. The JSON is flattened into the same lines a pasted table becomes, so every finding, clause and export works the same. The format name is used to describe the file; the checker is not affiliated with its publisher. Never paste passwords, keys or tokens; the list needs names and dates only.