table

CloudAppEvents

CloudAppEvents contains events involving accounts and objects in Microsoft 365 and other SaaS/cloud apps and services. Microsoft documents this table as populated by Microsoft Defender for Cloud Apps.

tablesCurrent

Relationships

Schema

FieldTypeDescriptionCopy
TimestampdatetimeDate and time when the event was recorded.
ActionTypestringType of activity that triggered the event.
ApplicationstringApplication that performed the recorded action.
AccountObjectIdstringUnique identifier for the account in Microsoft Entra ID.
IPAddressstringIP address assigned to the device during communication.
AuditSourcestringAudit source such as Defender for Cloud Apps access control, session control, or app connector.
RawEventDatadynamicRaw event information from the source application or service in JSON format.
OAuthAppIdstringOAuth application identifier assigned when an app is registered in Microsoft Entra ID.

Sample KQL

Recent SaaS activity by app

Summarize connected SaaS activity recorded through Defender for Cloud Apps.

kql
CloudAppEvents
| where Timestamp > ago(24h)
| summarize Events=count() by Application, ActionType
| top 20 by Events