๐ง Recipe ยท Troubleshooting & Diagnostics
Review OneDrive, SharePoint, and Exchange Sync Failures Using Service Health and Sign-In Logs
Correlate Microsoft 365 service health incidents with Entra sign-in failures to diagnose weekend sync outages across Exchange, SharePoint, and OneDrive
Complexity
Intermediate
Impact
troubleshooting + monitoring + incident-response + microsoft-365 + entra-id
Context
Why This Matters
When users report that Outlook, OneDrive, or SharePoint stopped syncing during off-hours โ a weekend, holiday, or overnight window โ the root cause is almost always one of three things: a Microsoft-side service incident, a tenant-wide authentication or Conditional Access change, or a per-user credential/token problem. Manually opening each user ticket wastes time when a single 10-minute sweep of Service Health plus Entra sign-in logs will tell you which bucket the incident falls into.
This recipe walks through the correlation workflow admins should run first thing Monday morning (or immediately after any reported sync outage). It pulls active and resolved service health issues for Exchange Online, SharePoint Online, and OneDrive for Business, then joins that data with sign-in failures scoped to the sync client apps (OneDrive, Outlook, SharePoint, Microsoft OneNote Sync, etc.) across the incident window.
Run this when: multiple users report sync issues at once, Help Desk ticket volume spikes after a weekend, or you receive a Microsoft message center advisory and want to confirm which of your users were impacted.
Expected Outcomes
After completing this recipe you will have:
- A list of active and recently resolved Microsoft service health issues affecting Exchange Online, SharePoint Online, and OneDrive for Business during the incident window.
- A categorized report of sign-in failures (by user, app, error code, and timestamp) for sync-related clients during the same window.
- Clear identification of the failure pattern: Microsoft service incident, tenant-wide misconfiguration (Conditional Access, MFA), or individual user/credential issues.
- An action list โ which users need password resets, session revocations, or MFA re-registration, versus which tickets can be closed with a "Microsoft-side incident, auto-resolved" note.
- Exportable CSV evidence for the incident ticket or post-incident review.
Risks & Considerations
Warnings and gotchas
- ServiceHealth.Read.All is required to query
/admin/serviceAnnouncement/issues. The older/serviceAnnouncement/issuespath is deprecated โ use the/admin/prefix. - Sign-in logs require Entra ID P1 or higher. Tenants on the free tier will not have
/auditLogs/signInsdata available. - Graph filter syntax is strict. Combining
status/errorCode ne 0withcreatedDateTime ge ...andcontains()in a single $filter often returns HTTP 400. Build queries incrementally โ filter by date on the server, then filter by app name client-side. - Do not bulk-revoke sessions across all impacted users as a knee-jerk response. If the cause is a Microsoft service incident, revocation adds no value and forces users to re-authenticate unnecessarily.
- Error code 53003 (Conditional Access blocked) over a weekend frequently points to a policy change that was deployed Friday afternoon. Check policy audit logs before assuming user error.
- PII and retention: sign-in log exports contain UPNs and IP addresses. Store CSVs in a compliance-appropriate location and purge per your data retention policy.
Required Permissions
| Permission | Why It's Needed |
|---|---|
| ServiceHealth.Read.All | Read Microsoft 365 service health issues and message center advisories for Exchange, SharePoint, and OneDrive. |
| AuditLog.Read.All | Query Entra ID sign-in logs to identify authentication failures tied to sync clients. |
| Directory.Read.All | Resolve user principal names and enrich sign-in log entries with display names and department. |
| User.Read.All | Look up impacted user details when preparing remediation actions. |
The fastest way to get this done โ just ask Dex. Copy the prompt below and paste it into your Dex conversation.
For IT Admins
Paste into Dex CoAdmin
For End Users
How an employee would ask Dex for help