Guests
Every guest, where they can get in, last sign-in
Every guest account in your tenant: who invited them, whether they accepted, when they last signed in, and the teams, groups and sites where they have access. Nothing is removed.
Reads only. Nothing in SharePoint is changed.
What does it tell you?
- One row per guest with invitation state, invited by and when, last sign-in, and counts of teams, groups and sites.
- One row per place each guest can get in.
- Guests who never accepted, or have not signed in for the number of days you pick, are flagged.
How it runs
- Sign in once. Reports › Guests. Sign in as a SharePoint administrator so every site is read.
- Pick the threshold. Flag guests who have not signed in for 30, 90, 180 or 365 days.
- 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?
- App or Cert authentication.
- Last sign-in needs Microsoft Entra ID P1 and the AuditLog.Read.All permission. Without them it reads Not readable, never Never.
- On App authentication, a site you are not an admin of is opened by making you a site collection admin for the run and removing that again at the end (the site-admin rule). Cert authentication needs no grant.
What will it not do?
- Who invited a guest comes from the directory audit log, which keeps 30 days (7 without Entra ID P1). Older invitations read Not in the audit log.
- 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.