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 Analysis Services 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: Sub Class Id Sub Class Name Sub Class Id Sub Class Name 0 Create 13 BeginTransaction 1 Alter 14 CommitTransaction 2 Delete 15 RollbackTransaction 3 Process 16 GetTransactionState 4 DesignAggregations 17 Cancel 5 WBInsert 18 Synchronize 6 WBUpdate 19 Import80MiningModels 7 WBDelete 20 Attach 8 Backup 21 Detach 9 Restore 22 SetAuthContext 10 MergePartitions 23 ImageLoad 11 Subscribe 24 ImageSave 12 Batch 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: Sub Class Id Sub Class Name Sub Class Id Sub Class Name 0 Create 13 BeginTransaction 1 Alter 14 CommitTransaction 2 Delete 15 RollbackTransaction 3 Process 16 GetTransactionState 4 DesignAggregations 17 Cancel 5 WBInsert 18 Synchronize 6 WBUpdate 19 Import80MiningModels 7 WBDelete 20 Attach 8 Backup 21 Detach 9 Restore 22 SetAuthContext 10 MergePartitions 23 ImageLoad 11 Subscribe 24 ImageSave 12 Batch 10000 Other
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.

See Also

Other Resources

Command Events Event Category