WhatsApp
← Blog·Method·18/08/2026·7 min read

Who Downloaded That Confidential File? Using M365 Logs to Find Out

Determining whether a departing employee or unauthorized party downloaded confidential documents from Microsoft 365 requires systematic analysis of cloud audit records. This guide outlines the technical mechanisms, log retention limitations, and legal standards needed for a defensible cloud investigation.

Diagram showing the Microsoft 365 forensic investigation path correlating user identity, IP address, device, file name, and download action using the Unified Audit Log.

To determine who downloaded a confidential file from Microsoft 365, digital forensic practitioners analyze the Unified Audit Log (UAL) alongside Microsoft Entra ID (formerly Azure Active Directory) sign-in records and SharePoint or OneDrive access logs. When an account interacts with a file stored within the environment, Microsoft 365 records specific event operations—such as FileDownloaded, FileAccessed, or FileSyncDownloadedFull—which capture the associated user principal name (UPN), IP address, user agent string, timestamp, and target document path.

In commercial litigation and internal investigations, establishing who accessed or exfiltrated sensitive data relies on prompt log preservation and methodical interpretation. Microsoft 365 log artifacts are detailed, but distinguishing between automated background processes and intentional human exfiltration requires specialized knowledge of tenant telemetry and evidentiary standards.

Understanding the Microsoft 365 Audit Logging Architecture

Microsoft 365 centralizes security and user activity telemetry across Exchange Online, SharePoint Online, OneDrive for Business, Teams, and Microsoft Entra ID. For any cloud forensics investigation, the Unified Audit Log serves as the primary repository of user and administrative actions.

However, audit data is not recorded or retained indefinitely by default. A critical preliminary step in any inquiry is understanding the logging configuration and licensing tier of the tenant in question:

  • Audit Standard (Default): Under standard licensing (such as Microsoft 365 E3 or Business Premium), audit records for user and admin activities are typically retained for 180 days. Older entries are permanently purged unless explicitly ingested into an external SIEM or log repository.
  • Audit Premium (E5 / Compliance Add-on): Tenants with Microsoft 365 E5 or specialized compliance licensing retain audit records for up to one year by default, with options to extend retention up to 10 years for designated high-value accounts. Premium auditing also captures high-value events such as MailItemsAccessed and Send.
  • Microsoft Entra ID Sign-in Logs: User authentication events, including IP addresses, multi-factor authentication (MFA) status, and device compliance metrics, are retained in the Entra ID portal for only 30 days under P1/P2 licensing, or 7 days under free tiers, unless forwarded to Azure Log Analytics.

Because default retention periods are finite, early intervention is vital. If an organization suspects data exfiltration by a departing director or employee, failing to preserve the log environment within the applicable retention window can permanently preclude recovery of crucial evidence.

Key Event Operations in File Download Investigations

When conducting a digital forensics investigation into file access, examiners extract records using the Microsoft Purview Audit search interface or via PowerShell using the Search-UnifiedAuditLog cmdlet. The log entries contain specific event names (operations) that describe the precise nature of the user's interaction with a file.

1. FileDownloaded

The FileDownloaded operation indicates that a local copy of a file was explicitly transferred from SharePoint Online or OneDrive for Business to a user's client device. This event commonly occurs when a user clicks 'Download' within a web browser interface or exports a document through a web application.

2. FileAccessed

The FileAccessed operation is generated when a file is viewed or opened. Crucially, viewing a file within the Microsoft 365 web viewer (Office Online) generates a FileAccessed record rather than a FileDownloaded event. However, because viewing a document transmits file data to the local browser cache, web viewing may still represent unauthorized data access, depending on the context of the dispute.

3. FileSyncDownloadedFull

This event is triggered when the OneDrive for Business sync client synchronizes a file from the cloud server to a user's local workstation or mobile device. A single FileSyncDownloadedFull event does not necessarily prove that a user deliberately saved or opened a file; it often reflects automated synchronization of an entire library or folder structure assigned to that user account.

4. SharingInvitationCreated and AnonymousLinkCreated

Exfiltration does not always occur via direct downloads to a corporate device. Individuals seeking to remove data discreetly may generate shared links or send external sharing invitations to private email accounts. Tracking events like SharingInvitationCreated, AnonymousLinkCreated, and AddedToSecureLink reveals whether internal file access permissions were modified to allow external retrieval.

Comparison of Microsoft 365 Log Sources

Different log sources within the Microsoft 365 ecosystem capture distinct elements of user activity. The table below outlines the primary log types evaluated during an exfiltration inquiry.

Log TypeDefault RetentionKey Events CapturedPrimary Forensic Purpose
Unified Audit Log (Standard)180 DaysFileDownloaded, FileAccessed, FileMovedTracking user file interactions across SharePoint and OneDrive
Unified Audit Log (Premium)1 Year (Up to 10 Years)MailItemsAccessed, SearchQueryPerformedIn-depth analysis of mailbox access and user search intent
Entra ID Sign-in Logs30 Days (P1/P2)UserSignIn, MFA Status, Client AppCorrelating file operations with session IPs and locations
SharePoint Admin Logs90 DaysSite Collection Scopes, External Sharing SettingsEstablishing site configuration changes and global access rules

Distinguishing Web Downloads, Sync Activity, and External Sharing

Interpreting raw log data requires careful analysis to differentiate deliberate manual exfiltration from normal background system operation. Forensic examiners evaluate the surrounding context of each logged action to build a reliable timeline.

For instance, if a user account records hundreds of FileSyncDownloadedFull events outside standard working hours, an investigator must correlate this activity with local workstation artifacts. If the user recently installed the OneDrive sync client on a personal laptop, the cloud log will record a surge of sync downloads as the client populates the local disk. Corroborating this with endpoint forensic analysis—such as analyzing shellbags, web history, or USB connection logs on the target device—establishes whether files were subsequently copied off the corporate estate.

Similarly, when assessing external sharing links, log analysis can pinpoint the exact UPN that created the link, the target external email address, the timestamp of creation, and whether the recipient successfully accessed or downloaded the underlying assets.

Forensic Challenges and Evidentiary Pitfalls

While Microsoft 365 audit logs offer detailed oversight, relying on raw exported CSV files without expert validation introduces several evidentiary risks in legal proceedings:

  • Shared Accounts and Credential Misuse: A log entry links an event to a User Principal Name (e.g., user@company.co.uk), not directly to a physical person. If account credentials were shared, compromised, or accessible on an unattended terminal, proving who operated the keyboard requires correlating sign-in locations, IP addresses, device identifiers, and simultaneous activities.
  • IP Address Obfuscation: Users connecting via commercial Virtual Private Networks (VPNs), mobile hotspots, or anonymizing proxies may obscure their true physical location. Forensic examiners analyze source IP metadata, autonomous system numbers (ASNs), and device enrollment status to identify proxy usage.
  • Log Incompleteness and Delay: Telemetry ingestion into the Unified Audit Log is not always instantaneous. Delays ranging from several minutes to hours can occur. Furthermore, if audit logging was disabled for specific mailboxes or administrative scopes prior to the incident, critical records may be missing entirely.
  • Mass Data Volume Limits: Exporting large volumes of audit data via standard administrative interfaces can lead to truncated datasets if request limits are exceeded. Forensic exports must utilize scriptable API interfaces (such as Microsoft Graph API or Exchange Online Management PowerShell) with pagination to ensure full dataset completeness.

Preservation and Evidence Handling under UK Standards

For evidence derived from cloud environments to be relied upon in UK civil litigation or criminal proceedings, adherence to established legal standards is mandatory. Under Civil Procedure Rules (CPR) Part 35 and Criminal Procedure Rules (CrimPR) Part 19, digital evidence must be collected, preserved, and presented in a manner that guarantees data integrity and chain of custody.

Following national guidelines published by the National Police Chiefs' Council (NPCC) for digital evidence, forensic specialists observe strict protocols when extracting Microsoft 365 logs:

Immediate Log Preservation: Exporting complete log datasets in native JSON or structured formats before retention limits expire, alongside cryptographic hashing (such as SHA-256) to prove the files remain unaltered post-collection.
  • Audit Log Retention Holds: Enabling tenant-level retention policies and Audit Premium retention configurations to prevent automated purging during ongoing proceedings.
  • Documented Collection Methodology: Recording all PowerShell scripts, API queries, and administrative credentials used during extraction to ensure the process is repeatable by independent experts.
  • For a detailed overview of procedural standards for electronic evidence, consult our digital forensic evidence guide.

    What This Means for Your Case: Recommended Next Steps

    If your organization suspects that proprietary files, client databases, or intellectual property have been inappropriately accessed or downloaded from Microsoft 365, swift procedural action is required:

    Secure the Environment: Revoke active session tokens, reset credentials for suspected accounts, and enforce multi-factor authentication (MFA). Do not delete or reallocate the user's license, as this may trigger automated log purging.
  • Issue an Immediate Preservation Order: Instruct your IT administration team or managed service provider (MSP) to preserve all audit logs immediately. Standard 180-day limits mean that historical data disappears automatically every day.
  • Export Raw Telemetry Safely: Ensure logs are extracted using scriptable API methods that capture full event payloads, including extended properties, user agent strings, and device IDs.
  • Engage an Independent Specialist: Retain an independent digital forensics expert to analyze the telemetry, correlate cloud logs with endpoint devices, and prepare an expert report compliant with CPR Part 35 or CrimPR Part 19.
  • To discuss a cloud investigation or obtain assistance with Microsoft 365 log extraction and analysis, contact our laboratory through our secure inquiry page.

    Frequently asked questions

    How long are Microsoft 365 audit logs retained by default?
    For standard licensing tiers like E3 or Business Premium, Microsoft 365 Unified Audit Logs are retained for 180 days. Accounts assigned Audit Premium (E5) licenses retain audit records for one year by default, with options to extend retention up to 10 years. Entra ID sign-in logs are typically retained for only 30 days under P1/P2 licenses.
    Can an employee delete or alter Microsoft 365 audit logs to hide file downloads?
    Standard users cannot alter or delete Microsoft 365 audit logs. Even tenant global administrators cannot directly edit or delete specific lines within the Unified Audit Log, as it is an append-only system. However, a compromised administrative account could potentially disable auditing globally, making early log preservation and administrative access control vital.
    What is the difference between FileAccessed and FileDownloaded in M365 logs?
    FileDownloaded indicates that a user explicitly saved or downloaded a copy of a file onto a local storage device or client machine. FileAccessed indicates that a user opened or viewed the file within the application or web viewer. While FileAccessed does not explicitly record a local file transfer, viewing a document causes content data to buffer in the local browser cache.
    How does a VPN impact the identification of an IP address in cloud logs?
    If a user accesses Microsoft 365 while connected to a commercial VPN, the audit log records the IP address of the VPN exit node rather than the user's physical IP address. Investigators resolve this by correlating sign-in timestamps with local device artifacts, MFA push notification logs, or contextual user activity across other corporate services.
    Are Microsoft 365 audit log exports admissible in UK courts?
    Yes, Microsoft 365 audit log exports are admissible in UK civil and criminal courts provided they are collected using forensically sound procedures. The extraction process must maintain a clear chain of custody, utilize cryptographic hashing to prove data integrity, and adhere to CPR Part 35 or CrimPR Part 19 expert evidence standards.