|
The audit data exported by this script is highly sensitive. Output may contain user identifiers (UPN, email, GUID), file/site/resource paths, conversation and message IDs, agent identifiers, prompt/response metadata (timestamps, lengths, classifications), and other personally identifiable information drawn directly from your tenant's Unified Audit Log.
|
Portable Audit eXporter (PAX) is a set of enterprise-grade PowerShell scripts that export Microsoft 365 Copilot, AI agent, and broader workload usage data out of Microsoft Purview and Microsoft Graph into analysis-ready CSV or Excel — ready for Power BI, Microsoft Fabric, or your preferred analysis tool.
The flagship script in the set — and the one most customers will use — is the Purview Audit Log Processor. It retrieves Microsoft 365 Copilot, AI agent, and broader workload audit records from the Microsoft Purview Unified Audit Log via Microsoft Graph API (default) or Exchange Online Management (EOM). It is the script designed to power the Microsoft Copilot Growth ROI Analytics team's Power BI templates published in the Microsoft Analytics Hub — the central landing page for our team's PBI templates, dashboards, and companion analytics tooling (AI-in-One Dashboard, M365 Usage Analytics Dashboard, Copilot Chat & Agent Intelligence Dashboards, and the broader ROI / adoption / governance visualization library).
Highlights of the Purview Audit Log Processor:
- Microsoft 365 Copilot, Unlicensed Copilot, and AI agent signal coverage
- Microsoft 365 Usage Bundle for productivity-workload activity (Teams, Exchange, SharePoint, OneDrive, Word, Excel, PowerPoint, OneNote, Forms, Stream, Planner, PowerApps) captured in the same run alongside Copilot telemetry
- Entra ID user + Microsoft 365 Copilot (MAC) licensing enrichment
- Long-running enterprise exports with checkpoint & resume, append capabilities, rolled up data architecture support to shrink data footprint, parallel processing, adaptive time-slicing, and server record limit detection and override
- Flexible filtering by user, group, agent, activity type, record/service type, and date range
- Flexible output destinations: local folder, SharePoint document library, or directly into Microsoft Fabric (OneLake) Delta tables — for unattended Azure-hosted runs, paired with Managed Identities
The PAX set also includes two specialized companion scripts for narrower use cases:
- Copilot Interactions Content Audit Log Processor — pulls the actual prompt and response content of Microsoft 365 Copilot interactions directly from the Graph
aiInteractionresource type (content-rich analysis with optional body text), with incremental watermark exports and user enrichment. Use this when you specifically need interaction content, not just usage telemetry. - Graph Audit Log Processor — a lightweight Graph-API-only export of Copilot usage records together with Entra user/organizational details and Copilot licensing. Use this when you do not need Purview Unified Audit Log coverage.
Most customers only need the Purview Audit Log Processor. The other two scripts are not replacements for it — they target different data sources and narrower scenarios. If you are unsure which to use, start with the Purview Audit Log Processor.
Download the script →
PAX_Purview_Audit_Log_Processor_v1.11.2.ps1| Release Date: 2026-05-17📖 Resources: Latest Documentation | Latest Release Notes
📚 Archives: All Documentation | All Release Notes | Previous Versions
For pulling raw Copilot prompt/response content.
- Download:
PAX_CopilotInteractions_Content_Audit_Log_Processor_v2.0.0.ps1 - Resources: Documentation | Release Notes
- Archives: All Documentation | All Release Notes | Previous Versions
For lightweight Graph-API-only Copilot usage + Entra user/licensing exports.
- Download:
PAX_Graph_Audit_Log_Processor_v1.0.1.ps1 - Resources: Documentation | Release Notes
- Archives: All Documentation | All Release Notes | Previous Versions
For questions or issues, refer to the documentation links next to each script above.
Managed and released by the Microsoft Copilot Growth ROI Advisory Team. Please reach out to copilot-roi-advisory-team-gh@microsoft.com with any feedback.
© Microsoft Corporation — MIT Licensed