Command Events Data Columns
The following table lists the data columns for each event class in the Command Events event category.
The Command Events event category has the following event classes:
The following tables list the data columns for each of these event classes.
Command Begin Class—Data Columns
| Data Column | Description |
|---|---|
| ConnectionID | Contains the unique connection ID associated with the command event. |
| TextData | Contains the text data associated with the command event. |
| ServerName | Contains the name of the instance on which the command event occurred. |
| CurrentTime | Contains the current time of the command event. |
| DatabaseName | Contains the name of the database in which the command is running. |
| EventSubclass | Contains the class of event within the command event. Supported values are: 0: Create 1: Alter 2: Delete 3: Process 4: DesignAggregations 5: WBInsert 6: WBUpdate 7: WBDelete 8: Backup 9: Restore 10: MergePartitions 11: Subscribe 12: Batch 13: BeginTransaction 14: CommitTransaction 15: RollbackTransaction 16: GetTransactionState 17: Cancel 18: Synchronize 19: Import80MiningModels 20: Attach 21: Detach 22: SetAuthContext 23: ImageLoad 24: ImageSave 25: CloneDatabase 26: CreateTabular 27: AlterTabular 28: DeleteTabular 29: Refresh 30: Interpret 31: ExtAuth1 32: DBCC (Database Consistency Checks) 33: RenameTabular 34: SequencePointTabular 35: UpgradeTabular 36: MergePartitionsTabular 37: DisableDatabase 38: Tabular JSON Command 39: Evict 40: CommitImport 10000: Other |
| NTUserName | Contains the user name associated with the command event. Depending on the environment, the user name is in the following form: - Windows user account (DOMAIN\UserName) - User Principal Name (UPN) (username@domain.com) - Service Principal Name (SPN) (appid@tenantid) - Power BI Service Account (Power BI Service) - Power BI Service on behalf of a UPN or SPN (Power BI Service (UPN/SPN)) |
| RequestProperties | Contains the XML for Analysis (XMLA) request properties associated with the command event. |
| SPID | Contains the server process ID (SPID) that uniquely identifies the user session that is associated with the command event. The SPID directly corresponds to the session GUID used by XMLA. |
| StartTime | Contains the time at which the command event started, if available. |
| SessionType | Contains the entity that caused the operation. |
| NTDomainName | Contains the domain name associated with the user account that triggered the command event. - Windows domain name for Windows user accounts - AzureAD for Microsoft Entra accounts - NT AUTHORITY accounts without a Windows domain name, such as the Power BI service |
| ClientProcessID | Contains the unique client process ID associated with the command event. |
Command End Class—Data Columns
| Data Column | Description |
|---|---|
| ConnectionID | Contains the unique connection ID associated with the command event. |
| TextData | Contains the text data associated with the command event. |
| ServerName | Contains the name of the instance on which the command event occurred. |
| CurrentTime | Contains the current time of the command event. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS. |
| DatabaseName | Contains the name of the database in which the command is running. |
| Duration | Contains the approximate amount of time between the command begin and the command end event. |
| EndTime | Contains the time at which the command event ended. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS. |
| EventSubclass | Contains the class of event within the command event. Supported values are: 0: Create 1: Alter 2: Delete 3: Process 4: DesignAggregations 5: WBInsert 6: WBUpdate 7: WBDelete 8: Backup 9: Restore 10: MergePartitions 11: Subscribe 12: Batch 13: BeginTransaction 14: CommitTransaction 15: RollbackTransaction 16: GetTransactionState 17: Cancel 18: Synchronize 19: Import80MiningModels 20: Attach 21: Detach 22: SetAuthContext 23: ImageLoad 24: ImageSave 25: CloneDatabase 26: CreateTabular 27: AlterTabular 28: DeleteTabular 29: Refresh 30: Interpret 31: ExtAuth1 32: DBCC (Database Consistency Checks) 33: RenameTabular 34: SequencePointTabular 35: UpgradeTabular 36: MergePartitionsTabular 37: DisableDatabase 38: Tabular JSON Command 39: Evict 40: CommitImport 10000: Other |
| NTCanonicalUserName | Contains the user name associated with the command event. Depending on the environment, the user name is in the following form: - Windows user account (DOMAIN\UserName) - User Principal Name (UPN) (username@domain.com) - Service Principal Name (SPN) (appid@tenantid) - Power BI Service Account (Power BI Service) |
| NTUserName | Contains the user name associated with the command event. Depending on the environment, the user name is in the following form: - Windows user account (DOMAIN\UserName) - User Principal Name (UPN) (username@domain.com) - Service Principal Name (SPN) (appid@tenantid) - Power BI Service Account (Power BI Service) - Power BI Service on behalf of a UPN or SPN (Power BI Service (UPN/SPN)) |
| SPID | Contains the server process ID (SPID) that uniquely identifies the user session associated with the command event. The SPID directly corresponds to the session GUID used by XMLA. |
| StartTime | Contains the time at which the command end event started, if available. |
| CPUTime | Contains the amount of CPU time (in milliseconds) used by the process between the time of the command begin event and the command end event. |
| Error | Contains the error number of any error associated with the command event. |
| Severity | Contains the severity level of an exception associated with the command event. Values are: 0 = Success 1 = Informational 2 = Warning 3 = Error |
| Success | Contains the success or failure of the command event. Values are: 0 = Failure 1 = Success |
| SessionType | Contains the entity that caused the operation associated with the command end event. |
| NTDomainName | Contains the domain name associated with the user account that triggered the command event. - Windows domain name for Windows user accounts - AzureAD for Microsoft Entra accounts - NT AUTHORITY accounts without a Windows domain name, such as the Power BI service |
| ClientProcessID | Contains the unique client process ID associated with the command event. |
1 - An internal service-generated command to perform authentication.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for