Skip to content
All articlesArchiving

SharePoint Archiving Audit Trail: What Squirrel Records

What a SharePoint archiving audit trail should record, and how Squirrel logs each archive, restore and captured deletion with the user, time and CSV export.

21 Nov 20269 min read
SharePoint Archiving Audit Trail: What Squirrel Records

SharePoint archiving with an audit trail

Squirrel keeps an audit trail of everything it does to a SharePoint file. Each archive, each restore and each captured deletion is recorded with the file, the site, the time and the person who asked for it. Administrators read that record in four places in the Squirrel portal: the Log Viewer, File History, the Archived Files list and the Reports page. The Log Viewer and every report export to CSV, so the evidence goes straight into an audit pack.

An archive moves files out of SharePoint, so an auditor asks three questions about it: what moved, who moved it, and where it is now. This page sets out what a SharePoint archiving service should record to answer them, and how Squirrel, SmiKar's SharePoint archiving product, records each one.

What the audit trail records

EventWhat is recordedWhere you read it
A file is archived by the nightly policy run, by a user's Archive button or by an administratorThe file, its SharePoint path, its size including versions, the date archived, and the person where a person started itArchived Files, File History, Log Viewer
A file or folder is restoredWho asked for it, when, the site, the file or folder, and whether the restore completedFile History, Log Viewer, History
A user deletes a file and Recycle Bin Capture preserves itThe original location, the date deleted, who deleted it and the original sizeRecycle Bin Capture, File History
Someone signs in to the Squirrel portalThe login attempt and the accountLog Viewer
An administrator changes a retention settingThe change, logged with the administrator's email addressSquirrel's logs
An archive or restore failsThe error, the file and the timeLog Viewer

The Log Viewer: every action, searchable

The Squirrel Log Viewer listing archive, restore and recycle bin capture entries with timestamps, with search, an event filter, a date picker and Export to CSV

The Log Viewer is the full record. It lists login attempts, archive and restore actions, system processes, errors and warnings, newest first. Each entry carries three things:

  • Timestamp: the date and time of the event.
  • Event type: Info, Warning or Error.
  • Details: the action taken (archive, restore, login), the user involved, the file or site and the outcome.

Four controls find the entries you need:

  • Search by username, file identifier or action, for example "restore".
  • Filter by event type to see only errors or warnings.
  • Pick a date to see one day's activity.
  • Export to CSV to hand the current view to an auditor or open it in Excel.

File History: what happened to one file or folder

The Squirrel File History page for a folder: six state counters, a plain-English summary of what happened, deletions by person, and a timeline entry for each file

Auditors and help desks rarely ask for a log. They ask what happened to a contract, or where a project folder went. File History answers that in one search. Pick a site, give it a folder path or the start of a filename, and it returns:

  • Six counts: files found, archived with a stub in place, deleted by a user and captured, orphaned, already restored, and restorable now.
  • A plain-English summary of what happened, for example that six files were deleted by two people and all six copies are held in the archive.
  • Deletions by person: who deleted files in that folder, how many, and the first and last time.
  • A timeline for each file: when it was stubbed, archived, deleted, captured or restored, and by whom where a person was involved.
  • A link to where a restored file is now, and a link to the page that restores each archived file.

Switch the search to By user to see what one person restored: each folder restore and file restore, with the site, the date and the status.

File History reads Squirrel's own records of the archive, the recycle bin captures and the restore history, so it is safe to run at any time.

Reports and history for auditors

The Reports page generates CSV reports on demand, in three groups:

GroupReports
File reportsFiles archived and files restored today, this month and this year; files archived by extension; storage by file type; the 100 largest files
Storage reportsData archived and data restored, in GB, today, this month and this year
Site reportsData archived and data restored per site over the last 30, 90, 180 and 365 days

The History page lists completed archive and restore activity: what ran, when, and whether it succeeded. Archived files stay on the Archived Files list after they are restored, with their status updated, so the list is a record of everything that has been through the archive.

Who can read the audit trail

Squirrel uses your Microsoft 365 identities, so there is one directory to manage. There are three roles:

RoleSigns in withSees
Squirrel administratorA Microsoft 365 account with multi-factor authenticationEvery page, including the Log Viewer, reports and settings
Archive administratorA Microsoft 365 account with multi-factor authenticationA restricted view: archived files, archive and restore by path, the activity monitor and History
End userWorks in SharePoint, Teams and synced foldersTheir own libraries, where archive and restore follow their SharePoint permissions

Auditing SharePoint itself

Squirrel's audit trail covers what the archive did. For what users did in SharePoint, two things sit alongside it:

  • The Microsoft 365 audit log records SharePoint activity such as file access, deletion and sharing. How to view and search the SharePoint audit log covers the native tools and how long they keep records.
  • Burrow, the security add-on to Squirrel, reads the SharePoint audit log for you, raises alerts on the activity that matters and keeps the history searchable through Hunt, so "what did this user do in March" is one search.

Audit trail questions to ask any archiving vendor

Use these when you compare SharePoint archiving services. Each has an answer you can test in a proof of concept.

  1. Is every archive and every restore logged with the user and the time?
  2. Can you trace one file from the day it was archived to the day it was restored?
  3. Can the log be searched by user, by file and by date?
  4. Can the log and the reports be exported for an auditor?
  5. Who can read the log, and how do they sign in?
  6. When a user deletes a file, is there a record of who deleted it and where the copy is?

Squirrel's answer to each is on this page. The SharePoint archiving buyer's checklist has the wider set of tests.

Frequently asked questions

What SharePoint archiving services include audit trail capabilities?

Squirrel by SmiKar includes an audit trail as standard. Every archive and restore is logged with the file, the site, the time and the user, the Log Viewer is searchable and exports to CSV, File History shows the timeline of any file or folder, and Recycle Bin Capture records who deleted a file and when. Microsoft 365 records SharePoint activity in its own audit log, which you search in Microsoft Purview. When you compare services, check that archive and restore actions are logged with the user and the time, and that the log can be exported.

Does Squirrel log who restored a file?

Yes. A restore started by a person is recorded with their name, the time, the site and the file or folder. The By user search in File History lists everything one person restored.

Can the audit trail be exported?

Yes. The Log Viewer exports the current view to CSV, and every report downloads as a CSV file for Excel, Power BI or an audit pack.

How do I find out who deleted a file from SharePoint?

With Recycle Bin Capture switched on, Squirrel preserves deleted files into your Azure storage and stamps each one with its original location, the date it was deleted and who deleted it. File History then shows deletions by person for any folder.

Does the audit trail cover files users archive themselves?

Yes. A file archived with the Archive button in SharePoint follows the same archive process as the nightly policy run, and the Log Viewer shows who archived it and when.

Next steps

An archive you can account for

Squirrel archives inactive SharePoint files into an Azure Blob Storage account in your own subscription, and records every archive, restore and captured deletion with the user and the time.

See how Squirrel works

Request a demo

About the author
Mark Smith - Co-Founder, SmiKar Software

Mark Smith co-founded SmiKar Software in 2015 and has spent the past decade helping organisations solve Microsoft 365 data management challenges. He works with the SmiKar team to build solutions for SharePoint archiving, storage optimisation, governance and compliance, supporting customers from growing businesses through to Fortune 500 enterprises.

More about SmiKar

Ready when you are

Cut your Microsoft 365 storage bill - keep your data in your tenant.