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.
Related articles
These are in the sapio365 space: