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:
- Command Begin class
- Command End class
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 Microsoft SQL Server 2005 Analysis Services (SSAS) 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. Values are: 0 = CREATE 1 = ALTER 2 = DELETE 3 = PROCESS 4 = DESIGNAGGREGATIONS 5 = WBINSERT 6 = WBUPDATE 7 = WBUPDATE 8 = BACKUP 9 = RESTORE 10 = MERGEPARTITIONS 11 = SUBSCRIBE 12 = BATCH 13 = BEGINTRANSACTION 14 = COMMITTRANSACTION 15 = ROLLBACKTRANSACTION 16 = GETTRANSACTIONSTATE 17 = CANCEL 18 = SYNCHRONIZE 19 = IMPORT80MININGMODELS 10000 = OTHER |
NTUserName |
Contains the Windows user name associated with the command event. The user name is in canonical form. For example, engineering.microsoft.com/software/user. |
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 Windows domain account associated with the object permission event. |
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 Analysis Services 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. Values are: 1 = CREATE 2 = DELETE 3 = ALTER 5 = PROCESS 6 = INSERT 7 = UPDATE 8 = DROP 9 = BACKUP 10 = RESTORE 11 = MERGEPARTITIONS 12 = SUBSCRIBE 13 = BATCH 14 = BEGINTRANSACTION 15 = COMMITTRANSACTION 16 = ROLLBACKTRANSACTION 17 = GETTRANSACTIONSTATE 18 = CANCEL 19 = SYNCHRONIZE 20 = INTERNAL 21 = LOCK 22 = UNLOCK 23 = STATEMENT 24 = DESIGNAGGREGATION |
NTCanonicalUserName |
Contains the Windows user name associated with the command event. The user name is in canonical form. For example, engineering.microsoft.com/software/user. |
NTUserName |
Contains the Windows user account associated with the command event. |
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 Windows domain account associated with the command event. |
ClientProcessID |
Contains the unique client process ID associated with the command event. |