PowerAutomateActivity

PowerAutomateActivity Schema #

Table description #

TableSection TableType TableSectionName Description
Usx Regular Microsoft Sentinel Contains Microsoft Power Automate audit logs. It’s typically used to track Power Automate activities.

Table retention #

HotDays ColdDays TotalInteractiveDays
14 76 90

Schema #

Name Description Type
_BilledSize Double
_IsBillable String
ActorName The UPN (User Principal Name) of the user who performed the action (specified in the Operation property) that resulted in the record being logged; for example, my_name@my_domain_name. Note that records for activity performed by system accounts (such as SHAREPOINT\system or NT AUTHORITY\SYSTEM) are also included. In SharePoint, another value display in the UserId property is app@sharepoint. This indicates that the “user” who performed the activity was an application that has the necessary permissions in SharePoint to perform organization-wide actions (such as search a SharePoint site or OneDrive account) on behalf of a user, admin, or service. For more information, see the app@sharepoint user in audit records. String
ActorUserId An alternative ID for the user identified in the UserId property. For example, this property is populated with the passport unique ID (PUID) for events performed by users in SharePoint, OneDrive for Business, and Exchange. This property may also specify the same value as the UserID property for events occurring in other services and events performed by system accounts. String
ActorUserType The type of user that performed the operation. Possible types are: Admin, System, Application, Service Principal and Other. String
AdditionalInfo More information, for example, the environment name. Object
EventOriginalType The name of the user or admin activity that performed the activity. For a description of the most common operations/activities, see “Search the audit log” in the Office 365 Protection Center. For Exchange admin activity, this property identifies the name of the cmdlet that was run. For Dlp events, this can be “DlpRuleMatch”, “DlpRuleUndo” or “DlpInfo”, which are described under “DLP schema” below. String
EventOriginalUid Unique identifier of an audit record. String
EventResult Indicates whether the action (specified in the Operation property) was successful or not. Possible values are Succeeded, PartiallySucceeded, or Failed. String
FlowConnectorNames Connector names listed in the flow. String
FlowDetailsUrl Link to the flow’s details page. String
LicenseDisplayName Display name of the license. String
ObjectId The full path name of the file or folder accessed by the user. For Exchange admin audit logging, the name of the object that was modified by the cmdlet. String
OrganizationId The GUID for your organization’s Office 365 tenant. This value will always be the same for your organization, regardless of the Office 365 service in which it occurs. String
RecipientUpn If permission was updated, shows the UPN of the permission recipient. String
RecordType The type of operation indicated by the record. See the AuditLogRecordType table for details on the types of audit log records. String
SharingPermission Type of permission shared with another user (3 = Owner/ReadWrite, 2 = Run-only user/Read). String
SourceSystem String
SrcIpAddr The IP address of the device that was used when the activity was logged. The IP address is displayed in either an IPv4 or IPv6 address format. For some services, the value displayed in this property might be the IP address for a trusted application (for example, Office on the web apps) calling into the service on behalf of a user and not the IP address of the device used by person who performed the activity. Also, for Azure Active Directory-related events, the IP address isn’t logged and the value for the ClientIP property is null. String
TenantId String
TimeGenerated The date and time in (UTC) when the user performed the activity. DateTime
Type The name of the table String
UserUpn Unique ID of the user. Always equivalent to UserKey. String
Workload The Office 365 service where the activity occurred. String

Schema changes #

Date Action
2024-10-18 Table added to tracking