Office 365 activity report
Who downloaded the most last month? Why does that take a day to answer?
A typical activity request - top downloaders, what left the tenant, which sites went quiet - costs an admin half a day of exports and scripting, and the spreadsheet is stale before it is mailed. 1Security keeps the Office 365 activity report as a live screen: filter, sort, export, save the view, and have it mailed every Monday. With up to three years of history behind every number.
The problem
Monday morning: management wants the numbers. Again.
Someone asks for last month's activity: who was most active, how many files were downloaded, what was shared outside, which sites nobody touched. The answer is spread across audit search, usage reports, sign-in logs and message trace - each with its own export format and its own window. Half a day later there is a spreadsheet describing a tenant that has already changed.
Next month the same request comes back slightly different, the spreadsheet is rebuilt by hand, and the numbers do not match the previous one. Nobody can say why, because each export was a one-off with its own filters. Meanwhile the events that mattered - the account that downloaded 4,000 files in a week, the site that went silent the day a project ended - are buried in the averages.
And the trail needs to be long. With 1Security you go from 180 days of activity history to up to three years on the licenses you already have, so a question about last spring still has data behind it and the report you build today runs on the same data next year.
In practice
From a one-off export to a report that runs itself.
What replacing manual activity reporting looks like in the first week.
- 01
Ask the question once, on the Activities board
Open Activities and pick the cut: top downloaders, top sharers, most-shared files, most-active devices, unused sites - over 24 hours, 7, 30 or 90 days, or a year. Each card is a ranked list with a sparkline: "top 20 downloaders in the last 30 days" is one click, and the number one row is often a surprise.
- 02
Save the view and share it
Filter Activity logs to the exact slice management asked for - time window, action types, resource - and save it under a name. Saved views are visible tenant-wide, so the next admin opens the same definition instead of rebuilding it. Export gives you exactly the rows on screen, not a mystery CSV.
- 03
Schedule the digest
Turn the cut into a policy and attach a digest: hourly, daily or weekly, to the recipients who asked. The Monday report now mails itself, computed at send time. Add an instant alert on top - "any user downloading more than 1,000 files in 24 hours" - and the report doubles as a tripwire.
- 04
Feed the people who want raw data
Where a SIEM, MSSP or a BI team wants the feed rather than the screen, the read-only REST API serves logs and alerts with cursor pagination - the same data, pulled on their schedule. One source of numbers instead of four exports.


What makes it work
Live data underneath, not exports.
Three parts of the platform carry this use case - each goes deeper than reporting alone.
Office 365 reporting
Numbers an auditor accepts, saved and shared views, full-list exports and the read-only API - answers instead of attachments.
Explore the feature →Microsoft 365 audit tool
Up to three years of searchable history behind every number, each event tied to a user, app, device and location.
Explore the feature →Microsoft 365 monitoring tool
The live layer the reports read from: new activity visible within about ten minutes, at any tenant size.
Explore the feature →
FAQ
Common questions.
Can the report be scheduled and emailed automatically?
Yes. Digests run hourly, daily or weekly to the recipients you choose, and instant alerts mail the moment a threshold is crossed. Mail is sent through Microsoft Graph from a dedicated mailer app, so it arrives from your own tenant.
How far back does the data go?
Up to three years of activity history on a standard Microsoft 365 license - go from 180 days to three years without a premium add-on. Long windows are served from daily rollups, so a 90-day question answers instantly even on tenants with tens of millions of files.
How is this different from the usage reports we already have?
It complements them. Usage reports answer adoption per workload; 1Security answers the people questions - named users, files, sites, devices and apps ranked by what they did, cross-filtered with who can access what. It needs no E5, no agent and no log forwarder.
Can our SIEM pull these numbers?
Yes. The read-only REST API exposes logs, 1Security detections and security alerts with per-tenant keys and cursor pagination, with documented wiring for Sentinel, Splunk, QRadar and Elastic.
The 1Security platform
Activity Reporting is just the beginning
Activity Reporting is one screen of the 1Security platform for Microsoft 365. Locations, devices, apps, AI agents, logs, permissions, sensitive data, compliance, reports and actions run on the same read-only connection, on the licence you already have.
- Trends and the daily briefWhat moved this month, what needs a decision today, ranked, for the client meeting and for your own morning.


- LocationsWhere every sign-in and every action really comes from, on a map, per tenant. Breaches by location, impossible travel, allow lists per person. Works without premium sign-in logs.


- DevicesRegistered, unregistered and shadow devices, attributed from activity rather than from an agent. The device nobody enrolled still shows up.


- Apps and consentEvery app with access to the tenant, what it can reach, who consented, and whether it still needs to.


- AI agents and CopilotThe agent registry: owners, reach, who each agent acts as, what Copilot will see. The EU AI Act checks per agent, accountable owner, instruction transparency and impact assessment, measured from the tenant. Readiness before the licences, governance after.


- Anomalies and detectionsSpikes in sharing, downloads, sign-ins, consent and agent activity, scored against each tenant’s own pattern, with curated response actions.


- Microsoft 365 Alerts ToolOne alert model across policies, activity and anomalies - with the evidence attached and the alert threshold in your hands.
- Microsoft 365 Monitoring ToolReal-time monitoring that catches a mass download while it is unfolding - across users, files, apps, AI agents and devices.
- Copilot Security ToolEvery AI agent's real blast radius - quantified before rollout, watched and constrained after.
- Shadow Device DetectionEvery device touching your data, reconstructed from real activity - including the machines that never enrolled anywhere.
- Impossible Travel DetectionLocations as identities, not IPs: country, city and network for every action, first-seen origins, travel timelines with verdicts - no E5, no P2.
- Conditional Access MonitoringDeclared Conditional Access compared against observed sign-ins: coverage verdicts, ungoverned traffic share, and the ranges your offices outgrew.
- Office 365 Access ManagementEffective access, resolved - who can reach what, through which grant, and one place to take it away.
- SharePoint Governance ToolEvery site ranked by exposure and abandonment - links, guests and Copilot access under control.
- Office 365 User ProvisioningLifecycle access from day one to offboarding - reach, dormant accounts and license reclaim in one flow.
- Microsoft 365 Audit ToolUp to three years of searchable activity history - every action tied to an actor, device and location.
- Microsoft 365 Inventory ToolEight live inventories on one permission graph - including the sites, devices and AI agents that were never registered anywhere.
- Office 365 ReportingAnswers, not exports - regulator-grade numbers, saved views and a read-only API for your SOC.
- Microsoft 365 File PermissionsWho has access to any file, and why - people, links, apps and AI agents on one map, with the fix in the same place.
- Sensitive Data DiscoveryWhere regulated data lives and everything that can reach it - two detection engines, no premium licence required.
- Office 365 Email MonitoringOutbound sensitive content, delegated-send abuse and whole-thread evidence that survives deletion.
- Purview Label CoverageWhat your sensitivity labels actually cover, and which of them protect anything at all.
- AI Agent InventoryEvery agent in the tenant with its real reach counted, its blueprint reviewed, and guardrails you can verify.
- AI Data RestrictionDeclare a data type off-limits to AI and every agent, app and user still reaching it becomes a live violation - recorded for the auditor.
- AI Spend TrackingInteractions, Copilot credits and Azure tokens in one ledger per agent - with the spend column next to what each agent can reach.
- Microsoft 365 User Access ReviewEvery identity with what it can reach, what it did, and whether it should still exist - including SharePoint-only guests that live outside the directory.
- Group Access AnalysisWhat membership in a group actually unlocks - nesting resolved, external members surfaced, blast radius counted.
- App and OAuth Consent GovernanceEvery app with a foothold in the tenant: how it got in, who let it in, and what it can actually read.
- Remediation AutomationFindings become fixes at tenant scale, counted before you enable them and staged behind a review window.
- Microsoft 365 Licence OptimizationThe seats you pay for and nobody uses - unassigned units, licences on guests, and dormant accounts still billing.
- Microsoft 365 Anomaly DetectionEvery policy, user, app and agent measured against its own baseline - with an alert line you move and see the answer to at once.
- Office 365 Sign-in LocationsEvery place your tenant is reached from, with your Conditional Access configuration laid over observed reality.
- Microsoft 365 Unified Audit LogWho did what, when, from where and on which device - retained up to three years on a standard licence.
- SharePoint Site InventoryEvery site, channel site and OneDrive in one list, ranked by external reach, abandonment and what Copilot can read.
- Microsoft 365 Activity AnalyticsThe extremes rather than the averages - a mass download inside the hour, and everything nobody has touched in a year.
- Microsoft 365 Trend TrackingAny number in the tenant followed over time, with the change and the deviation attached - and alerting on the same object.
- Microsoft 365 Compliance MonitoringReadiness for eleven regulations measured from live tenant data - with weekly snapshots and a dated evidence pack per framework.
- Microsoft 365 Security ScoreMicrosoft Secure Score beside the score measured from what actually happens - one worklist ranked by points still on the table.
- External Domain MonitoringEvery organisation your tenant exchanges data with, resolved to a real company - with drift flags and an enforceable verdict per domain.
- All featuresExplore everything
Stop rebuilding the same spreadsheet.
Connect read-only, save the views your team keeps asking for and let the digests deliver themselves. First numbers the same day.
Or export it all again next month, cell by cell.