ShareMaster is shaped by your feedback. Tell us what to build next →
Features All features overview
Migration Tools Overview Structure and content OneDrive ↔ SharePoint Content only Structure only Move / Copy Upload from this computer Download to this computer Dropbox to SharePoint Copy a team Resume and incremental runs
Recycling Bin Overview Browse a site's recycle bin Empty recycle bins in bulk Restore and purge history
Archive Overview Configure the tenant On Demand Archive Restore Archived Files Archive Savings Report Blob Viewer
Optimise Storage Tools Overview Delete all items in a list Delete all files and folders in a library Remove empty folders Remove duplicate files Reduce image sizes Delete sites and subsites
SharePoint Tools Overview Tenant Explorer SharePoint Explorer Easy Settings Fix renamed groups List Explorer Search the Preservation Hold Library
Search & Indexing Overview Search query Item search properties Reindex Crawl log
Replace Overview Replace in SharePoint Replace in local files Find password-protected files
Shared Links Overview Report shared links Report unique permissions Remove a person from sharing links Remove shared links Remove unique permissions
Version History Overview Version trimming Version trimming report Reset file version
Reports Overview Inventory report Folder inventory Site and subsite storage Storage growth Security matrix Teams permissions Pre-migration analysis Compare items Dropbox to Microsoft 365 compare Duplicate file report Empty folder report Image size report Recycle bin report Unused licences Report history
Developer Tools Overview Query Builder PnPjs Console Property Bags SPFx Customizers Webhooks Customisation audit
V2 Pricing Services Demos Blog Guides Use cases Compare Tools Alerts FAQ Contact
  1. Home
  2. Documentation
  3. Reports

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

  1. Sign in once. Reports › Guests. Sign in as a SharePoint administrator so every site is read.
  2. Pick the threshold. Flag guests who have not signed in for 30, 90, 180 or 365 days.
  3. 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.
  4. 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.

See every feature