Compare
SharePoint permission history: Microsoft tools and Access Witness
Short answer: Microsoft's tools are a good place to start. SharePoint shows current permissions. Microsoft Purview records many permission-related changes. SharePoint Advanced Management can produce reports showing permissions at the time the information was collected.
If you need to know who has access today, start with SharePoint. If you need to investigate a specific change, start with Purview. If you need a report of current access across sites, check SharePoint Advanced Management.
The harder question is: who had access on a particular past date? An audit log records events, but an event is not necessarily a complete list of everyone who had access. A snapshot helps only for the date it covers.
Microsoft also provides other ways to investigate or recover earlier information, including Graph Data Connect and Microsoft 365 Backup. Each has its own purpose and limits.
In the Microsoft documentation reviewed on November 4, 2026, we did not find a built-in report that lets an administrator select an arbitrary past date and see the full effective SharePoint permissions for a particular file. This is a statement about the documentation reviewed, not a claim that Microsoft cannot do it.
If your organization needs historical access answers regularly, you need to keep suitable records before those questions arise. You can build your own collection process, retain Microsoft reports and audit records, or use a product such as Access Witness.
Access Witness is made by NATHELVO TECHNOLOGIES INC. This page compares the options, including situations where Microsoft's tools are sufficient.
Three Microsoft tools and Access Witness compared
| What it shows | How far back | Who had access on a past date? | |
|---|---|---|---|
| Current SharePoint permissions | Who has access now, through people, groups and links | Now | We saw no option to pick a past date in the steps Microsoft gives |
| Microsoft Purview audit logs | Changes: who did what, to what, and when | 180 days on Audit (Standard). One year on Audit (Premium). Up to ten years with an add-on | The pages we read describe activities, not a list of who held access on a date |
| SharePoint Advanced Management reports | Permissions at the time a report was generated, and oversharing activity in the last 28 days | A saved snapshot of the report's collection period; its data can be up to 48 hours older than the report generation time. Activity reports cover 28 days. Change history can cover up to 180 days | Only for people you named in a per-user report that you ran at the time and kept. The organization report gives counts, not names |
| Access Witness | A dated record of permissions, groups, members, sharing links and changes on the SharePoint sites it scans | From each site's first completed full scan, for as long as you keep the database and the installed product | For covered dates and sites, it can show the recorded or reconstructed answer, with an evidence label and any warnings. Missing records or scan coverage can limit the answer |
Which should you use?
"Who has access to this today?" Use SharePoint's own screens. Microsoft's tools are enough.
"Who shared this, or changed this group, and when?" Search the Purview audit log. If the date is inside your retention period, Microsoft's tools are enough.
"Which sites are overshared?" or "What can these people reach today?" Use SharePoint Advanced Management reports, if you have the license. Microsoft's tools are enough.
"Who had access last month, before we started keeping records?" No tool can guarantee a complete answer without suitable earlier evidence. Check Microsoft's audit events, any saved permission reports and other records you already have. You may be able to work backward from a known state, but missing changes can make the result uncertain. Access Witness does not fill in the period before its first completed scan.
"We need the site put back as it was." Microsoft 365 Backup can restore a protected SharePoint site to an earlier restore point, including its file and folder permissions. Full-site recovery can extend up to 10 years, depending on the configured recovery window and when protection began. Restoring over the original site replaces its current content and permissions, so review the consequences first. Restoring selected files does not restore their item-level permissions.
"We are asked this often, or about dates older than our audit retention." Start keeping a record now. Lengthen audit retention if your licenses allow it, send audit events to a SIEM, set up a Microsoft service in advance, build your own record from exports, or use Access Witness. None of these fills in the time before you started.
Current SharePoint permissions
This means the Manage access panel, site permissions and Check Permissions.
Advantages
- Manage access shows the people, groups and links that give access to a file or folder.
- Check Permissions takes a name and shows the permissions that person has.
- They are already in SharePoint, so for a question about today, start here. Site owners and admins can also export a CSV of content shared with external users. You can't choose a time period, but a saved copy shows how things stood that day.
Limits
- Microsoft describes what these screens show now, and its Manage access page describes no sharing history or log.
- On team sites, Microsoft 365 group membership gives site access. A change to the group changes who can reach the site, so check the group too.
Microsoft Purview audit logs
Advantages
- It records sharing and unsharing, sharing link changes, SharePoint group changes, changes to site collection admins (people with full control of a site), changes to permission level definitions and items that stop or go back to using their parent's permissions. Entra group membership changes appear too.
- Sharing records show who shared what, with whom and when.
- You can search by activity, user and date range, and by file, folder or site.
Limits
- It lists activities. If someone's access did not change during the period you search, there may be nothing to find.
- For people, how long records last depends on the license of the person who acted and on any custom retention policy, which can shorten the period. Records made by apps, service principals and system events are kept for a fixed one year. Guests, and users with neither E5 nor a Microsoft Purview Suite or E5 eDiscovery and Audit add-on, stay at 180 days, even in an E5 tenant. Ten years needs an add-on for each user on top of an E5 license, plus a 10-year retention policy, and is not retroactive. Our article on how long Microsoft 365 keeps SharePoint audit history has more.
- For SharePoint and OneDrive, records typically appear 60 to 90 minutes after the event. Other services can take longer. Microsoft does not commit to a specific time.
- One search covers at most 180 days. Exports are limited to 50,000 rows on Audit (Standard) and 1,000,000 on Audit (Premium). Broad searches in large tenants can take up to 48 hours.
- A sharing event is often paired with a second event showing how access was granted, so look for both.
- Entra's own audit log is separate from this one. It keeps 7 days on Free and 30 days on P1 or P2, unless you route it to Azure storage through Azure Monitor.
SharePoint Advanced Management reports
Advantages
- The organization report shows the current permission structure across SharePoint and OneDrive sites, with counts for each site. It helps you find oversharing.
- The per-user report lists the sites a chosen person can reach, and how, at one point in time.
- Activity reports track potential oversharing in the last 28 days.
- Change history reports give you CSV files of site actions and organization setting changes from up to the last 180 days, depending on the user license.
- Site access reviews ask site owners to review what a report found on their sites.
Limits
- Snapshot reports, meaning the organization and per-user reports above, show data as of the date they were generated, and they capture data from up to 48 hours before. A saved report is a useful record of that moment. It is not a complete reconstruction of every file's permissions, and it helps with a past date only if you ran a per-user report then, kept it and named the person in it. The organization report gives counts, not names.
- You can rerun the organization report every 30 days, and Microsoft recommends running it quarterly. It leaves out sites locked to no access and archived sites. Sites with a read-only lock are included. Creating a sharing link, or giving access to "Everyone except external users" (all internal users), does not automatically raise its user count.
- You can have up to five per-user reports and rerun them every 30 days, with up to 100 users in one PowerShell request. The organization report must run once first, and that first run can take up to 5 days.
- Microsoft's pages differ on change history. One says to use it to find recent permission changes. The report's own page talks about site property changes. We could not confirm that individual grants appear.
- These reports depend on your licenses, and those requirements can change, so check Microsoft's current prerequisites. Microsoft 365 E5 alone gives activity reports, without snapshot reports. You must turn on data collection first, reports cover only the time since then, and they return up to 10,000 sites.
Access Witness
Access Witness, from NATHELVO TECHNOLOGIES INC., runs on your own Windows Server. It keeps a dated history of SharePoint permissions in your own SQL Server database.
Advantages
- Access History is built for the past-date question. Choose a person, a SharePoint site or file, and a past date. You see their access level, each way they got it and the records behind the answer. You can also compare two dates.
- Permission Structure shows how someone gets access, through groups, sharing links and permissions set higher up.
- It records direct permissions, SharePoint groups, Entra security groups, Microsoft 365 groups, site collection admins and sharing links.
- Recorded history is not deleted for being old. You can view it in your installed Dashboard for as long as you keep that installation and the database working, even after a license ends. Once recorded, it does not depend on Microsoft's audit retention.
- Each answer about the past has a label that says how much Access Witness can confirm:
- Verified snapshot: an answer supported by a recorded permission state and the changes available up to the requested date. Read any warnings too; this label does not guarantee that every permission or intervening change was captured.
- Reconstructed: Access Witness worked out the answer from recorded permissions and changes.
- Partial: some records are available, but Access Witness cannot confirm every permission, group membership or change for that date.
- Unknown: there is not enough information to say what access existed on that date.
Limits
- Historical answers need recorded coverage. Access Witness starts building its permission history with the first full scan. It does not establish a reliable access answer for a date before the relevant site's first completed scan: that answer is Unknown. Older Microsoft audit events may be available as change records, shown apart from the answer, but they do not establish the complete earlier permission state. How far back they go depends on your tenant. On large tenants, completing the initial scan can take days.
- It covers the SharePoint sites it has scanned. A site that was never scanned is outside every answer. A site scanned earlier that is now excluded, archived, locked or failing keeps its old record, so answers for later dates can rest on that last scan. Access History warns when a site is no longer being scanned, so read the warning as well as the label. If a site is missing from an answer, that does not mean the person had no access to it. The Sites page shows the state of each site. Personal OneDrive sites are left out of a whole-tenant scan. To record one, you switch to scanning only the sites you list and add it to that list.
- It cannot list everyone who holds an Anyone or Organization link. It names someone only if Microsoft 365 logged a signed-in person on that link. It records the link and its level, and shows it as possible access, separately from the answer.
- It records who could reach something, not who did. It does not show who opened, downloaded or edited a file. The one exception is a sharing link use that Microsoft 365 logged, which appears as a change record.
- It does not say whether a sign-in would have worked. It weighs permissions, memberships and links, not sign-in policies or sensitivity labels.
- It depends on what Microsoft reports. Changes can take hours to appear, so an answer can change when a late record arrives. If Microsoft 365 did not record who made a change, Access Witness cannot name that person.
- Some changes are seen late or not at all. A scan can catch a change the audit log missed, but it dates the change when the scan saw it and names no one. Anything added and removed between scans leaves no trace unless Microsoft logged it. If Access Witness stops running for a long time, it can miss changes, and answers may not show that gap.
- Some details use today's state. An item moved since your date is judged from where it is now. A custom permission level shows its latest recorded rights. The Latest view shows each site as of its last scan, which on a large tenant can be days ago. For who has access right now, check SharePoint.
- It reads SharePoint and is designed not to change it. It will not remove access or revoke links for you.
- It needs infrastructure you run. That means Windows Server 2019 or later, SQL Server 2019 or later, approved applications in Microsoft Entra ID, a Global Administrator to sign in during setup, and Microsoft 365 audit logging turned on. There is no hosted version. Government and sovereign clouds are not supported. If the license cannot be confirmed, recording and updates stop. You can still view recorded history, but a stop of more than 7 days can leave a gap. See the full requirements.
Other products
Other vendors work in this area too, and historical answers and self-hosting are not unique to Access Witness. Syskit Point describes answering an auditor's question, "who had access during this period?". Netwrix Auditor describes state-in-time reports using configuration snapshots for supported data sources. Its documentation explicitly says that importing historical snapshots is not available for Office 365. We have not verified whether it can answer the specific past-date SharePoint Online permission question discussed here.
We read those pages on November 5, 2026, and have not tested these products. Ask each vendor what it can show for your own question.
Other Microsoft ways to look at an earlier state
- Microsoft Graph Data Connect. This service gives you Microsoft 365 data in bulk for analysis, and it must be set up in Azure first. It provides dated SharePoint datasets for analysis, including permission information, but building an effective-access answer requires additional processing. It can return SharePoint objects as they existed on a date, and its datasets include permissions and SharePoint groups with their members. Microsoft blog posts say the date must be between 23 days ago and 2 days ago, and no earlier than the day you turned on data collection. The data is meant for analytics, is updated daily and is billed through Azure.
- Microsoft 365 Backup. A full SharePoint site restore to its original location restores content and file and folder permissions from a selected restore point. Restore points are available approximately every 10 minutes for the most recent 14 days, then weekly through the configured recovery window, which can extend up to 10 years. Protection must already have been enabled. Restoring over the original site replaces its current state; restoring to a new URL avoids overwriting the original site. Selected-file restores are available only for recent restore points and do not restore item-level permissions. This is a recovery tool, not a historical permissions report.
- Microsoft Sentinel data lake. Once set up, it keeps daily snapshots that include Entra group membership, for 30 days by default and up to 12 years. Microsoft charges for both bringing this data in and keeping it. This covers Entra groups. Microsoft's list of the data it stores shows no SharePoint permissions.
- Microsoft Entra Backup and Recovery. With Entra ID P1 or P2, it backs up Entra objects once a day with no setup and keeps up to seven days. A difference report compares a backup with today and shows group membership changes. It does not cover SharePoint permissions, and membership changes to groups synced from on-premises may not appear.
- Your own exports. PowerShell and Microsoft Graph return site users, site groups and file permissions, and past audit events can be read by API. Saved on a schedule, these become your own record. It takes upkeep. One Microsoft audit feed holds content for 7 days, so keeping it longer means collecting it all the time. Our guide to auditing historical SharePoint permissions shows one way to start.
What we could not confirm
- New Microsoft features. Message center posts need a tenant sign-in, so we did not read them. A keyword search of the public Microsoft 365 roadmap found no past-date access report, but a keyword search can miss items. A past-date feature may already be announced, so check your own message center.
- Full audit coverage. We could not confirm that audit events cover every way access can change, such as a link expiring, a dynamic group changing or a change to a group synced from on-premises.
- Anyone links. One Microsoft page says access through an Anyone link can't be audited. Current audit pages list a link-use event. Microsoft says the person's identity might be unknown, but the record can give other details such as the IP address.
- Report lifetime. The pages we read do not say how long a generated snapshot report stays available.
Sources
We consulted every Microsoft page below on November 4, 2026, and rechecked Microsoft 365 Backup on November 5, 2026. The date after each link is when Microsoft last updated that page, where it shows one.
Microsoft Purview Audit
- Audit log activities, updated November 3, 2026
- Sharing auditing in the audit log, updated June 25, 2026
- Search the audit log, updated July 14, 2026
- Auditing solutions overview, updated July 8, 2026
- Audit log retention policies, updated June 24, 2026
SharePoint Advanced Management
- Data access governance reports, updated July 30, 2026
- Site permissions across your organization report, dated July 16, 2026
- Site permissions for users report, dated July 1, 2026
- PowerShell for data access governance, updated October 31, 2026
- Change history reports, updated July 1, 2026
- Site access reviews, dated July 9, 2026
- SharePoint Advanced Management prerequisites, updated August 18, 2026
SharePoint permissions
- See who a file is shared with, no date shown
- Access denied troubleshooting, with the Check Permissions steps, dated December 2, 2025
- Sharing and permissions in the SharePoint modern experience, updated July 1, 2026
- View usage data for your SharePoint site, no date shown
- Get-SPOUser, updated December 30, 2025
- Get-SPOSiteGroup, updated September 18, 2025
- List permissions on a file or folder in Microsoft Graph, updated July 23, 2025
Microsoft Entra
- Microsoft Entra data retention, updated March 25, 2026
- Microsoft Entra Backup and Recovery overview, updated June 30, 2026
- Create and review difference reports, updated June 30, 2026
- Supported objects and recoverable properties, updated August 25, 2026
- Backup, difference report, and recovery model, updated August 25, 2026
Other ways to look at an earlier state
- Data Connect FAQ: delta state datasets, updated October 15, 2026
- Data Connect FAQ: which date should I query, updated October 15, 2026
- Data Connect FAQ: what is in the Permissions dataset, updated October 30, 2024
- Data Connect FAQ: estimating your Azure bill, updated October 15, 2026
- Data Connect datasets, updated August 6, 2025
- Microsoft Graph Data Connect overview, updated August 6, 2025
- Microsoft 365 Backup: restore data, updated November 4, 2026
- Sentinel data lake: asset data tables, updated April 22, 2026
- Sentinel data lake: enable data connectors, updated May 14, 2026
- Office 365 Management Activity API reference, updated August 6, 2025
Microsoft documentation reviewed: November 4 and 5, 2026.
See how it answers a past-date question.
Request a demo using sample data, or start a free 15-day trial on up to 10 sites you choose.