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:

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