Unified Audit Logs

What this module is for

The Unified Audit Logs module searches the Microsoft 365 unified audit log — the single record of user and administrator activity across Exchange, SharePoint, OneDrive, Teams, Microsoft Entra ID, Power BI, Copilot and the other Microsoft 365 workloads. Use it to answer questions such as who opened, shared or deleted a file, who changed a mailbox, what a particular user did over a period, or every time a given activity happened across the tenant.

Admin audit logs and Unified Audit Logs cover different ground. Admin audit logs shows directory changes recorded by Microsoft Entra ID. Unified Audit Logs spans every workload that writes to the Microsoft 365 audit log, including file, mailbox and Teams activity by ordinary users.

How to open it

Open Unified Audit Logs from the Reports area of the sapio365 dashboard.

An Exchange PowerShell connection is required. The unified audit log is searched over Exchange PowerShell, so sapio365 establishes that connection when the module opens.

Choosing what to load

Opening the module presents Unified Audit Logs - Options, and Change Options reopens it later. Every option narrows the search before anything is fetched:

Option

What it controls

Get logs from

Last 180 days (Max), or Specify range with a From and Up to day and time. A specified range must fall within the last year and be no more than 180 days long.

Keyword Search

Free text matched against the audit records.

ALL record types / Record Type

Either every record type, or a single record type chosen from the list — for example ExchangeAdmin, SharePointFileOperation, MicrosoftTeams or AzureActiveDirectory. The list holds close to 500 types.

Activities (Operations)

One or more activity names to match, such as a particular file or mailbox operation.

User IDs

One or more users whose activity you want.

Target Object IDs

One or more objects the activity was performed on.

Target Site IDs

One or more SharePoint sites the activity took place in.

High Completeness

Where available in your tenant, returns more accurate results at the cost of a longer retrieval.

Limit the number of records

A hard cap on how many records are fetched.

Activities, User IDs, Target Object IDs and Target Site IDs each accept several values; enter each value once.

Narrow the search before you run it. Every user action in every workload writes to this log, so 180 days of all record types for a whole tenant is a very large result. A record type, a handful of activities or users, and a record limit turn it into a quick, targeted load. Once the logs are in, Change Options retrieves more with different settings.

What it shows

The grid is flat: one row per audit record.

The default view

The module opens with five columns that every record shares:

Column

What it tells you

Created On

When the activity happened

User Ids

Who performed it

Operations

What was done

Record Type

Which workload and kind of activity recorded it

Object State

The state of the audit record

Is Valid is also available through the column picker.

Audit detail columns

Each record carries detail specific to its record type — the file path of a SharePoint operation, the parameters of an Exchange admin command, the client IP of a sign-in, and so on. sapio365 unpacks that detail into columns of its own, one per property, and files them under a column category named after the record type. A property nested inside another is titled Sub-property - Property.

  • The detail columns depend on what you loaded: loading two record types produces two categories of columns, each relevant only to its own rows.

  • Properties that hold a list arrive as multi-value columns. Use Explode Cells to split them into one value per row.

  • When a reload no longer returns a record type, its detail columns are removed.

The default view is built from the first load. Record types that first appear after a later Change Options are not part of it, so reapplying the default view hides their detail columns. Bring them back through the column picker or save a view of your own.

For the fixed columns of this module, see the Unified Audit Logs column reference. Audit detail columns depend on the records loaded, so they are not listed there.

What you can do here

Action

What it does

Change Options

Changes the date range, filters, record limit and High Completeness setting, and retrieves the matching records.

This module is for reading. The standard grid actions — Refresh, Snapshot, Freeze point and Export — are available as they are everywhere.

You can also create and save custom views to use in the Quick GridView.

Requirements and limits

  • An Exchange PowerShell connection, as above.

  • Access rights or permission to search the audit log in Microsoft 365.

  • Logs reach back one year at most, and a single load covers at most 180 days. Investigating a longer period means several loads.

  • Records arrive in batches until the search is complete, so a broad search fills the grid progressively.

These are in the sapio365 space: