Orphaned Account Checker

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=500

The fields read

Field in the exportRead as
userPrincipalNamethe account (mail when it is missing)
displayNamethe display name
userType, employeeTypethe type: Guest reads as a guest; for a member, employeeType when it is filled
accountEnabledenabled: true is enabled, false is disabled and set aside
signInActivity.lastSignInDateTimelast used, an interactive sign-in field; absent, empty or the zero date reads as not recorded
signInActivity.lastNonInteractiveSignInDateTimea note
lastPasswordChangeDateTimelast changed
createdDateTimecreated
manager (displayName, when expanded)the manager
memberOf (displayName, when expanded)member of: an administrative group or directory role marks the account privileged
department, employeeIdnotes
idjoins pages of the same user; not shown

What the users export does not carry

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.

The documents this reads from

Back to the checker