All tables
Cloud / Audit

OfficeActivity

Office 365 audit events covering Exchange, SharePoint, OneDrive, and Teams user and admin activities

Recommendation

High-value events that need near-real-time detection, low-volume join targets, or high-value tables the lake cannot hold.

How the matrix works

C6 Collaboration, SaaS, and business application activity

Collaboration, SaaS, and business application activity

ACSC

  • 8. Cloud platform loggingOffice 365 and Google Workspace

CISA

  • 7. Microsoft 3657a Unified audit log

MITRE data sources

  • Application Log: Application Log Content

T1 Near-real-time detection

Generic detections need near-real-time matching on single events.

Lake supported in the Azure Monitor table feature matrix

Fields detections use

High-value fields

ClientIPExternalAccessItemNameOfficeObjectIdOfficeWorkloadOperationOrganizationNameParametersRecordTypeResultStatusSourceFileNameSourceRelativeUrlTimeGeneratedUserAgentUserIdUserType

Most used in public rules

  1. Operation50
  2. UserId47
  3. OfficeWorkload41
  4. TimeGenerated41
  5. ClientIP37
  6. RecordType21
  7. Parameters18
  8. UserType16
  9. OfficeObjectId13
  10. ResultStatus12
  11. UserAgent10
  12. OriginatingServer9

Split hints

Rows to keep in Analytics with a split rule.

Keep file sharing, permission changes, mailbox delegation, and external access events in Analytics

(Operation has "SharingSet" or Operation has "AnonymousLinkCreated" or Operation has "SharingInvitationCreated" or Operation has "AddedToSecureLink" or Operation has "MemberAdded" or Operation has "MemberRemoved" or Operation has "Add-MailboxPermission" or Operation has "Set-Mailbox" or Operation has "New-InboxRule" or Operation has "Set-InboxRule" or Operation has "UpdateInboxRules" or Operation has "FileDownloaded" or Operation has "FileSyncDownloadedFull" or ExternalAccess =~ "true")

Sources for this recommendation