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.

See Also

Other Resources

Command Events Event Category

Help and Information

Getting SQL Server 2005 Assistance