AzureActivity

Entries from the Azure Activity log that provides insight into any subscription-level or management group level events that have occurred in Azure.

Categories

  • Azure Resources
  • Audit
  • Security

Solutions

  • LogManagement

Resource types

  • Desktop Virtualization Application Groups
  • Data factory (V2)
  • Recovery Services vault
  • Data Lake Storage Gen1
  • Data Lake Analytics
  • Power BI Dedicated
  • Data Share
  • SQL Managed instance
  • SQL server
  • SQL database
  • Azure Database for MySQL server
  • Azure Database for PostgreSQL server
  • Azure Database for PostgreSQL server
  • Azure Database for MariaDB server
  • Device Provisioning Services
  • Event Hub
  • Application Gateway
  • Firewall
  • ExpressRoute circuit
  • Front Door
  • Load balancer
  • Network interface
  • Network security group
  • Public IP addresses
  • Traffic Manager profile
  • Virtual network gateway
  • Virtual network
  • Search Services
  • Stream Analytics
  • Bastion
  • Automation account
  • API Management services
  • Logic App
  • Service Fabric cluster
  • Desktop Virtualization Host Pools
  • Desktop Virtualization workspaces
  • Time Series Insights
  • Event Grid
  • Workload Monitor
  • Analysis Services
  • HDInsight cluster
  • Batch account
  • CDN profile
  • Azure Spring Cloud
  • Media Services
  • Azure Cache for Redis
  • Cognitive Services
  • Key vault
  • Azure API for FHIR
  • App Service
  • SignalR
  • Container registry
  • Azure Data Explorer cluster
  • Azure AD Domain Services
  • Azure Blockchain service
  • Event Grid domain
  • Virtual machine
  • Virtual machine scale set
  • Kubernetes Services
  • Azure Databricks Services
  • Azure Monitor autoscale settings
  • IoT Hub
  • Azure Cosmos DB account
  • Machine Learning
  • Storage account
  • Service Bus

Columns

Column Type Description
ActivityStatus string
ActivityStatusValue string Status of the operation in display-friendly format. Common values include Started, In Progress, Succeeded, Failed, Active, Resolved.
ActivitySubstatus string
ActivitySubstatusValue string Substatus of the operation in display-friendly format. E.g. OK (HTTP Status Code: 200).
Authorization string Blob of RBAC properties of the event. Usually includes the “action”, “role” and “scope” properties. Stored as string. The use of Authorization_d should be preferred going forward.
Authorization_d dynamic Blob of RBAC properties of the event. Usually includes the “action”, “role” and “scope” properties. Stored as dynamic column.
Caller string GUID of the caller.
CallerIpAddress string IP address of the user who has performed the operation UPN claim or SPN claim based on availability.
Category string
CategoryValue string Category of the activity log e.g. Administrative, Policy, Security.
Claims string The JWT token used by Active Directory to authenticate the user or application to perform this operation in Resource Manager. The use of claims_d should be preferred going forward.
Claims_d dynamic The JWT token used by Active Directory to authenticate the user or application to perform this operation in Resource Manager.
CorrelationId string Usually a GUID in the string format. Events that share a correlationId belong to the same uber action.
EventDataId string Unique identifier of an event.
EventSubmissionTimestamp datetime Timestamp when the event became available for querying.
Hierarchy string Management group hierarchy of the management group or subscription that event belongs to.
HTTPRequest string Blob describing the Http Request. Usually includes the “clientRequestId”, “clientIpAddress” and “method” (HTTP method. For example, PUT).
Level string Level of the event. One of the following values: Critical, Error, Warning, Informational and Verbose.
OperationId string GUID of the operation
OperationName string
OperationNameValue string Identifier of the operation e.g. Microsoft.Storage/storageAccounts/listAccountSas/action.
Properties string Set of pairs (i.e. Dictionary) describing the details of the event. Stored as string. Usage of Properties_d is recommended instead.
Properties_d dynamic Set of pairs (i.e. Dictionary) describing the details of the event. Stored as dynamic column.
Resource string
ResourceGroup string Resource group name of the impacted resource.
ResourceId string
_ResourceId string A unique identifier for the resource that the record is associated with
ResourceProvider string
ResourceProviderValue string Id of the resource provider for the impacted resource - e.g. Microsoft.Storage.
SourceSystem string Azure is used always for AzureActivity
SubscriptionId string Subscription ID of the impacted resource.
TenantId string ID of the worksapce that stores this record
TimeGenerated datetime Timestamp when the event was generated by the Azure service processing the request corresponding the event.
Type string The name of the table