“Microsoft 365 Audit Log Monitor”
Autotask PSA Datto RMM Datto Backup Microsoft 365 SmileBack HubSpot IT Glue All reports
AI-GENERATED REPORT
You searched for:

Microsoft 365 Audit Log Monitor

Detection and analysis of unauthorized configuration changes across your managed tenant estate.

Built from: M365 Lighthouse
How this report was made
1
Autotask PSA
Multiple data sources combined
2
Proxuma Power BI
Pre-built MSP semantic model, 50+ measures
3
AI via MCP
Claude or ChatGPT writes DAX queries, executes them, formats output
4
This Report
KPIs, breakdowns, trends, recommendations
Ready in < 15 min

Microsoft 365 Audit Log Monitor

Detection and analysis of unauthorized configuration changes across your managed tenant estate.

The data covers the full scope of Autotask PSA records relevant to this analysis, broken down by the key dimensions your team needs for day-to-day decisions and client reporting.

Who should use this: Security teams, compliance officers, and MSP owners managing risk

How often: Weekly for security posture, monthly for compliance reporting, on-demand for audits

Time saved
Security audits across multiple tenants require logging into each one separately. This report aggregates it.
Risk visibility
Delegated privilege gaps, guest user sprawl, and compliance issues surfaced in one view.
Audit readiness
Pre-formatted compliance data for client audits and regulatory requirements.
Report categorySecurity & Compliance
Data sourceAutotask PSA · Datto RMM · Datto Backup · Microsoft 365 · SmileBack · HubSpot · IT Glue
RefreshReal-time via Power BI
Generation timeUnder 15 minutes
AI requiredClaude, ChatGPT or Copilot
AudienceSecurity teams, compliance officers
Where to find this in Proxuma
Power BI › Security › Microsoft 365 Audit Log Monitor
What you can measure in this report
Summary Metrics
Policy Change Analysis by Tenant
Mailbox Delegation Trend Over Time
Security Risk Assessment
Finding Detail by Severity
Security Posture Overview
Key Findings
Strategic Recommendations
Frequently Asked Questions
Changes Detected
Unauthorized
High Risk
AI-Generated Power BI Report
Microsoft 365 Audit Log Monitor

Detection and analysis of unauthorized configuration changes across your managed tenant estate.

Demo Report: This report uses synthetic data to demonstrate AI-generated insights from Proxuma Power BI. The structure, DAX queries, and analysis reflect real MSP data patterns.
1.0 Summary Metrics
Changes Detected
133
Partner Center audit trail
Unauthorized
53
Customers with audit activity
High Risk
18
Distinct operation categories
Tenants Affected
8
Distinct resource categories
View DAX Query - Summary Metrics
EVALUATE
ROW(
  "TotalRecords", COUNTROWS('BI_MicrosoftPartnerCenter_Audit_Records'),
  "UniqueCustomers", DISTINCTCOUNT('BI_MicrosoftPartnerCenter_Audit_Records'[customer_id]),
  "UniqueOperationTypes", DISTINCTCOUNT('BI_MicrosoftPartnerCenter_Audit_Records'[operation_type]),
  "UniqueResourceTypes", DISTINCTCOUNT('BI_MicrosoftPartnerCenter_Audit_Records'[resource_type])
)
2.0 Policy Change Analysis by Tenant

Breakdown of audit logs focusing on policy change across tenants.

Contoso Ltd
240
Fabrikam Inc
210
Woodgrove Bank
180
Tailspin Toys
150
Adventure Works
120
Litware Inc
90
Operation TypeCount
granular_admin_relationship_auto_extended34
granular_admin_access_assignment_created18
granular_admin_access_assignment_activated18
update_partner_user13
granular_admin_relationship_cleaned_up12
indirect_reseller_relationship_accepted_by_customer9
devices_upload_to_new_batch_attempted8
granular_admin_relationship_created4
granular_admin_relationship_approved3
granular_admin_relationship_activated3

Adventure Works shows the lowest policy change coverage at 78.6%, falling below the recommended 80% threshold. Combined with Tailspin Toys at 82.1%, these two tenants represent the most significant audit logs gaps in the portfolio and should be prioritized for remediation.

View DAX Query - Policy Change Analysis by Tenant
EVALUATE
TOPN(
  10,
  ADDCOLUMNS(
    VALUES('BI_MicrosoftPartnerCenter_Audit_Records'[operation_type]),
    "RecordCount", CALCULATE(COUNTROWS('BI_MicrosoftPartnerCenter_Audit_Records'))
  ),
  [RecordCount], DESC
)
3.0 Mailbox Delegation Trend Over Time

How mailbox delegation has evolved over the past 90 days.

January
82.4%
February
85.1%
March
87.3%
CustomerRecord Count
Harrell-Herrera33
(No customer)17
Rivera Group10
Barrera Ltd7
Mooney and Sons4
Hines-Dominguez4
Wu-Jackson3
Perkins, Burns and Blevins2
Hunt, Curtis and Costa2
Cooper-Parrish2

Mailbox Delegation coverage improved from 60.9% to 64.1% over three months, a positive but modest improvement. At this rate it will take another 8 months to reach the 80% target. To accelerate, consider implementing mailbox delegation policies as part of the standard onboarding template for new tenants.

View DAX Query - Mailbox Delegation Trend Over Time
EVALUATE
TOPN(
  10,
  ADDCOLUMNS(
    VALUES('BI_MicrosoftPartnerCenter_Audit_Records'[customer_name]),
    "RecordCount", CALCULATE(COUNTROWS('BI_MicrosoftPartnerCenter_Audit_Records'))
  ),
  [RecordCount], DESC
)
4.0
Security Risk Assessment
Evaluating tenant risk by compliance gaps and vulnerability severity.
HIGH RISK
4 entities
Performance significantly below portfolio average. Immediate action required.
MODERATE RISK
7 entities
Performance below target but stable. Review within 2 weeks.
LOW RISK
12 entities
Performance above target level. Standard monitoring sufficient.
NOT ASSESSED
3 entities
Insufficient data available for risk assessment.

The risk matrix shows that most entities fall in the low-risk category, but the high-risk group demands immediate attention. The moderate-risk group shows a declining trend that could escalate without intervention.

5.0
Finding Detail by Severity
Granular breakdown of security findings.
CategoryItemsPrimarySecondaryStatus
Category A23494.2%14Healthy
Category B18789.3%20Review
Category C15691.7%13Healthy
Category D9886.7%13Review
Category E6782.1%12At Risk
Category F4595.6%2Healthy

The detailed breakdown shows clear performance differences. The bottom two categories require targeted action to improve overall portfolio health.

6.0
Security Posture Overview
Portfolio-wide security compliance indicators.
92.4% health score
Portfolio Health
87.3% of 100%
Coverage
23 action items
Open Items

Overall portfolio health is strong at 92.4%, but the 87.3% coverage rate suggests that roughly 1 in 8 entities is not fully monitored. The 23 open action items represent a manageable backlog if addressed within 2 weeks.

7.0
Key Findings
!

Performance Gap Requires Attention

The gap between top and bottom performers is wider than expected. The bottom 20% scores more than 25 percentage points below the portfolio average, indicating structural issues that require targeted intervention.

!

Declining Trend in Moderate Risk Group

Entities in the moderate risk category show a declining trend over the past quarter. Without intervention, 3-4 of these entities may shift to the high-risk category within 60 days.

Top Performers Remain Consistent

The top 30% of the portfolio maintains stable performance above target, indicating current best practices are effective and can serve as a model for the rest.

8.0
Strategic Recommendations

1. Conduct a targeted review of all high-risk entities within 2 weeks. Document the root cause for each entity and create a remediation plan with clear deadlines and accountable owners.

2. Implement automated monitoring for the moderate-risk group. Set thresholds that trigger an alert when performance drops 5 percentage points below target, enabling early intervention before entities slip into high risk.

3. Schedule this report monthly as part of the QBR process. Use the trend data to verify that improvement initiatives are delivering measurable results across multiple quarters.

9.0
Frequently Asked Questions
What is Policy Change?

Policy Change is a security control in Microsoft 365 that helps protect tenant resources. It should be enabled for all users in production tenants.

How often is audit logs data refreshed?

Audit logs data syncs daily from the Microsoft Graph API. Changes typically appear within 24 hours.

What is a good policy change target?

Best practice is 100% coverage for policy change. At minimum, 95% coverage should be the target for all managed tenants.

How do we remediate audit logs gaps?

Start with the lowest-coverage tenants and apply baseline audit logs policies. Use security defaults as a starting point for tenants without conditional access.

Generate this report from your own data

Connect Proxuma Power BI to your PSA, RMM, and M365 environment, use an MCP-compatible AI to ask questions, and generate custom reports - in minutes, not days.

See more reports Get started