Entra security
MFA, admin roles, inactive and licensed-but-disabled accounts
Reads Microsoft Entra for the four things an identity review asks first: who has not registered for MFA, who holds an admin role, who has not signed in for a while, and who is disabled or deleted but still holds a licence. Nothing is changed.
Reads only. Nothing in SharePoint is changed.
What does it tell you?
- One row per account: MFA registered, MFA capable, passwordless capable, password reset registered, the methods registered and the default one, with admins who have no MFA method flagged first.
- Every holder of every admin role: active, or eligible through Privileged Identity Management; people in a role-assignable group are listed through that group. Disabled holders, holders without MFA and holders who have stopped signing in are flagged.
- Accounts with no sign-in for 30, 60, 90, 180 or 365 days, licensed ones first.
- Disabled or deleted accounts still holding licences: the same verdict as the Unused licences report, from the same read.
How it runs
- Sign in once. Reports › Entra security. Sign in as yourself with a role that can read the directory and its reports, such as Global Reader.
- Pick the threshold. How long without a sign-in counts as inactive; 90 days is the default.
- Run report. The run screen lists each thing it reads as it goes: Microsoft's reports, the directory, and each site. Stop offers Finish, which reads nothing new and builds the report from what was read, or Stop now.
- Read the result. The Done screen gives the headline and anything that could not be read. The workbook goes into History; Save report keeps a copy where you choose. Its About sheet names every source and what came of it.
What do you need?
- Global Reader, Security Reader or Global Administrator. The report makes no SharePoint call.
- MFA registration and last sign-in need Microsoft Entra ID P1. PIM-eligible role holders need Microsoft Entra ID P2.
What will it not do?
- When the tenant does not have the licence a source needs, that source is marked not readable on this tenant and nobody is flagged from it. When the sign-in lacked a permission or role, the report says that instead: it is not a licence problem.
- Exchange-only role groups and Azure subscription roles are not Entra directory roles and are not listed.
- A read that did not happen is shown as not read, never as an empty result: a site the report could not open keeps its row, with why, and nothing is concluded from it.