Microsoft 365 reporting guest access
Who are the guests in your tenant that no guest list shows?
In a typical tenant, hundreds of guests have not signed in for a year but still hold access, and a second class of guests - people who got in through a SharePoint link or site permission - never became directory objects at all. 1Security lists both kinds of guest, shows exactly which sites, files and groups each one can still open, and stages the removal behind a review window.
The problem
Guests are easy to invite, invisible to review, and never leave.
A supplier gets added to a Teams channel. An auditor gets a link to a folder. A contractor is invited into a project site. Each is one click for the person who did it and nobody's job afterwards. Most tenants we connect to hold hundreds to thousands of guests, and a large share of them last signed in over a year ago.
The quarterly review usually starts from a directory export: guest object, sponsor, last sign-in. Two things are hard to get from that alone. First, SharePoint can grant access to external people who never become directory objects - these SharePoint-only guests hold real permissions, and a review that starts from the directory has no row for them, which is exactly why they pile up. Second, an export tells you when a guest signed in, not what the guest can reach.
That second point is the one that matters. A guest who last signed in 14 months ago and still holds access to three project sites and a folder with contracts is the row worth acting on. 1Security ranks by exactly that, because it reads the actual permissions on every site, group and file.
In practice
The guest review, done from what they can reach.
Run it once as a cleanup or every quarter as a standing review - the list is live either way.
- 01
Count every kind of guest
Open Users and filter to external. Entra guests and SharePoint-only guests are broken out as separate types, each with a live count. The second number is usually the surprise: it is common to find dozens or hundreds of external identities that were never on any review list.
- 02
Sort by what each guest can still open
Every guest row shows sites, files and groups in reach, sensitive files among them, and the sharing links they created. Sort by files reachable descending and the top of the list is a single external credential that opens tens of thousands of documents.
- 03
Cut to the ones nobody uses
Add the filter for no activity in the last year. Access still standing, last real activity long gone. Combine with "can reach sensitive information" and you have the guest cleanup list in the order it should be worked - typically a few hundred rows, not the whole population.
- 04
Remove access with a safety net
Enable the suggested automation for idle guests and 1Security stages a proposal per guest behind a 72-hour review window. Site owners can be asked to confirm, so an active collaboration is never cut by mistake; rejecting a proposal snoozes it. Every removal lands in the Actions log.


What makes it work
Three parts of the platform behind the report.
Guest risk is an access question, so the report is built on the permission graph, not on the directory.
Access management
Every guest's effective reach resolved through groups, sharing links and site inheritance - the ranking column that turns a guest list into a work queue.
Explore the feature →Lifecycle management
Idle-guest indicators, offboarding flows and the automations that keep the guest population from growing back after the cleanup.
Explore the feature →SharePoint governance
The site-side view of the same story: which sites hold external users, and which have been abandoned for a year with guests still inside.
Explore the feature →
FAQ
Common questions.
How does this fit with Entra access reviews?
They complement each other. Entra access reviews certify the guests in your directory. 1Security adds the SharePoint-only guests, who are not directory objects, and ranks every guest by what it can really reach and when it was last active - so a review can start from the rows that matter, both classes included.
Can we remove guest access from 1Security?
Yes, under the separately approved write module. Removal resolves every source of access - direct grants, sharing links, group and site membership - shows what each source unlocks, and stages the change behind a review window with optional owner confirmation. Until you approve that module, the connection is read-only.
How current is "last activity"?
New activity shows up within minutes at any tenant size, and up to three years of history sit behind every guest row on standard licenses. "Last activity" means the guest actually opened, edited or downloaded something - not just a sign-in timestamp.
Do we need E5 or Entra P2 for this?
No. Guest reporting, reach and idle-guest detection run on standard Microsoft 365 licensing, with no agent to install.
The 1Security platform
Guest Access Reporting is just the beginning
Guest Access Reporting is one screen of the 1Security platform for Microsoft 365. Locations, devices, apps, AI agents, logs, permissions, sensitive data, compliance, reports and actions run on the same read-only connection, on the licence you already have.
- ComplianceNIS2, DORA, GDPR, EU AI Act, SOC 2 and HIPAA as requirements with a live status, attestations, dated snapshots and evidence packs.


- ReportsSix report types in PDF, PowerPoint, HTML, CSV and JSON, under your brand with the client’s name, one report per client across the whole book.


- AlertingInstant and digest channels per client, routed to the right people, themed under your brand or theirs.


- Trends and the daily briefWhat moved this month, what needs a decision today, ranked, for the client meeting and for your own morning.


- LocationsWhere every sign-in and every action really comes from, on a map, per tenant. Breaches by location, impossible travel, allow lists per person. Works without premium sign-in logs.


- DevicesRegistered, unregistered and shadow devices, attributed from activity rather than from an agent. The device nobody enrolled still shows up.


- Microsoft 365 Alerts ToolOne alert model across policies, activity and anomalies - with the evidence attached and the alert threshold in your hands.
- Microsoft 365 Monitoring ToolReal-time monitoring that catches a mass download while it is unfolding - across users, files, apps, AI agents and devices.
- Copilot Security ToolEvery AI agent's real blast radius - quantified before rollout, watched and constrained after.
- Shadow Device DetectionEvery device touching your data, reconstructed from real activity - including the machines that never enrolled anywhere.
- Impossible Travel DetectionLocations as identities, not IPs: country, city and network for every action, first-seen origins, travel timelines with verdicts - no E5, no P2.
- Conditional Access MonitoringDeclared Conditional Access compared against observed sign-ins: coverage verdicts, ungoverned traffic share, and the ranges your offices outgrew.
- Office 365 Access ManagementEffective access, resolved - who can reach what, through which grant, and one place to take it away.
- SharePoint Governance ToolEvery site ranked by exposure and abandonment - links, guests and Copilot access under control.
- Office 365 User ProvisioningLifecycle access from day one to offboarding - reach, dormant accounts and license reclaim in one flow.
- Microsoft 365 Audit ToolUp to three years of searchable activity history - every action tied to an actor, device and location.
- Microsoft 365 Inventory ToolEight live inventories on one permission graph - including the sites, devices and AI agents that were never registered anywhere.
- Office 365 ReportingAnswers, not exports - regulator-grade numbers, saved views and a read-only API for your SOC.
- Microsoft 365 File PermissionsWho has access to any file, and why - people, links, apps and AI agents on one map, with the fix in the same place.
- Sensitive Data DiscoveryWhere regulated data lives and everything that can reach it - two detection engines, no premium licence required.
- Office 365 Email MonitoringOutbound sensitive content, delegated-send abuse and whole-thread evidence that survives deletion.
- Purview Label CoverageWhat your sensitivity labels actually cover, and which of them protect anything at all.
- AI Agent InventoryEvery agent in the tenant with its real reach counted, its blueprint reviewed, and guardrails you can verify.
- AI Data RestrictionDeclare a data type off-limits to AI and every agent, app and user still reaching it becomes a live violation - recorded for the auditor.
- AI Spend TrackingInteractions, Copilot credits and Azure tokens in one ledger per agent - with the spend column next to what each agent can reach.
- Microsoft 365 User Access ReviewEvery identity with what it can reach, what it did, and whether it should still exist - including SharePoint-only guests that live outside the directory.
- Group Access AnalysisWhat membership in a group actually unlocks - nesting resolved, external members surfaced, blast radius counted.
- App and OAuth Consent GovernanceEvery app with a foothold in the tenant: how it got in, who let it in, and what it can actually read.
- Remediation AutomationFindings become fixes at tenant scale, counted before you enable them and staged behind a review window.
- Microsoft 365 Licence OptimizationThe seats you pay for and nobody uses - unassigned units, licences on guests, and dormant accounts still billing.
- Microsoft 365 Anomaly DetectionEvery policy, user, app and agent measured against its own baseline - with an alert line you move and see the answer to at once.
- Office 365 Sign-in LocationsEvery place your tenant is reached from, with your Conditional Access configuration laid over observed reality.
- Microsoft 365 Unified Audit LogWho did what, when, from where and on which device - retained up to three years on a standard licence.
- SharePoint Site InventoryEvery site, channel site and OneDrive in one list, ranked by external reach, abandonment and what Copilot can read.
- Microsoft 365 Activity AnalyticsThe extremes rather than the averages - a mass download inside the hour, and everything nobody has touched in a year.
- Microsoft 365 Trend TrackingAny number in the tenant followed over time, with the change and the deviation attached - and alerting on the same object.
- Microsoft 365 Compliance MonitoringReadiness for eleven regulations measured from live tenant data - with weekly snapshots and a dated evidence pack per framework.
- Microsoft 365 Security ScoreMicrosoft Secure Score beside the score measured from what actually happens - one worklist ranked by points still on the table.
- External Domain MonitoringEvery organisation your tenant exchanges data with, resolved to a real company - with drift flags and an enforceable verdict per domain.
- All featuresExplore everything
Count your guests. All of them.
Connect read-only and see every guest with what they can reach the same day - SharePoint-only ones included.
Or keep reviewing only the guests that were easy to list.