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