Discover Events Data Columns

  • Article

The Discover Events category has the following event classes:

  • Discover Begin class

  • Discover End class

The following tables list the data columns for each of these event classes.

Discover Begin Class—Data Columns

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

Sub Class Id

Sub Class Name

0

DBSCHEMA_CATALOGS

24

DMSCHEMA_MINING_COLUMNS

1

DBSCHEMA_TABLES

25

DISCOVER_DATASOURCES

2

DBSCHEMA_COLUMNS

26

DISCOVER_PROPERTIES

3

DBSCHEMA_PROVIDER_TYPES

27

DISCOVER_SCHEMA_ROWSETS

4

MDSCHEMA_CUBES

28

DISCOVER_ENUMERATORS

5

MDSCHEMA_DIMENSIONS

29

DISCOVER_KEYWORDS

6

MDSCHEMA_HIERARCHIES

30

DISCOVER_LITERALS

7

MDSCHEMA_LEVELS

31

DISCOVER_XML_METADATA

8

MDSCHEMA_MEASURES

32

DISCOVER_TRACES

9

MDSCHEMA_PROPERTIES

33

DISCOVER_TRACE_DEFINITION_PROVIDERINFO

10

MDSCHEMA_MEMBERS

34

DISCOVER_TRACE_COLUMNS

11

MDSCHEMA_FUNCTIONS

35

DISCOVER_TRACE_EVENT_CATEGORIES

12

MDSCHEMA_ACTIONS

36

DMSCHEMA_MINING_STRUCTURES

13

MDSCHEMA_SETS

37

DMSCHEMA_MINING_STRUCTURE_COLUMNS

14

DISCOVER_INSTANCES

38

DISCOVER_MASTER_KEY

15

MDSCHEMA_KPIS

39

MDSCHEMA_INPUT_DATASOURCES

16

MDSCHEMA_MEASUREGROUPS

40

DISCOVER_LOCATIONS

17

MDSCHEMA_COMMANDS

41

DISCOVER_PARTITION_DIMENSION_STAT

18

DMSCHEMA_MINING_SERVICES

42

DISCOVER_PARTITION_STAT

19

DMSCHEMA_MINING_SERVICE_PARAMETERS

43

DISCOVER_DIMENSION_STAT

20

DMSCHEMA_MINING_FUNCTIONS

44

MDSCHEMA_MEASUREGROUP_DIMENSIONS

21

DMSCHEMA_MINING_MODEL_CONTENT

49

DISCOVER_XEVENT_TRACE_DEFINITION

22

DMSCHEMA_MINING_MODEL_XML

23

DMSCHEMA_MINING_MODELS

CurrentTime

2

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

ConnectionID

25

1

Contains the unique connection ID associated with the discover event.

DatabaseName

28

8

Name of the database in which the statement of the user is running.

NTUserName

32

8

Contains the Windows user name associated with the discover event. The user name is in canonical form. For example, engineering.microsoft.com/software/user.

NTDomainName

33

8

Contains the Windows domain associated with the discover event.

ClientProcessID

36

1

Contains the process ID of the client application.

ApplicationName

37

8

Name of the client application that created the connection to the server. This column is populated with the values passed by the application rather than the displayed name of the program.

SessionID

39

8

Contains the session ID associated with the discover event.

NTCanonicalUserName

40

8

Contains the Windows user name associated with the discover event. The user name is in canonical form. For example, engineering.microsoft.com/software/user.

SPID

41

1

Contains the server process ID (SPID) that uniquely identifies the user session associated with the discover event. The SPID directly corresponds to the session GUID used by XMLA.

TextData

42

9

Contains the text data associated with the event.

ServerName

43

8

Contains the name of the instance of Microsoft SQL Server Analysis Services on which the discover event occurred.

RequestProperties

45

9

Contains the XML for Analysis (XMLA) request properties associated with the discover event.

Discover End Class—Data Columns

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Contains the event class; this is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

Sub Class Id

Sub Class Name

0

DBSCHEMA_CATALOGS

24

DMSCHEMA_MINING_COLUMNS

1

DBSCHEMA_TABLES

25

DISCOVER_DATASOURCES

2

DBSCHEMA_COLUMNS

26

DISCOVER_PROPERTIES

3

DBSCHEMA_PROVIDER_TYPES

27

DISCOVER_SCHEMA_ROWSETS

4

MDSCHEMA_CUBES

28

DISCOVER_ENUMERATORS

5

MDSCHEMA_DIMENSIONS

29

DISCOVER_KEYWORDS

6

MDSCHEMA_HIERARCHIES

30

DISCOVER_LITERALS

7

MDSCHEMA_LEVELS

31

DISCOVER_XML_METADATA

8

MDSCHEMA_MEASURES

32

DISCOVER_TRACES

9

MDSCHEMA_PROPERTIES

33

DISCOVER_TRACE_DEFINITION_PROVIDERINFO

10

MDSCHEMA_MEMBERS

34

DISCOVER_TRACE_COLUMNS

11

MDSCHEMA_FUNCTIONS

35

DISCOVER_TRACE_EVENT_CATEGORIES

12

MDSCHEMA_ACTIONS

36

DMSCHEMA_MINING_STRUCTURES

13

MDSCHEMA_SETS

37

DMSCHEMA_MINING_STRUCTURE_COLUMNS

14

DISCOVER_INSTANCES

38

DISCOVER_MASTER_KEY

15

MDSCHEMA_KPIS

39

MDSCHEMA_INPUT_DATASOURCES

16

MDSCHEMA_MEASUREGROUPS

40

DISCOVER_LOCATIONS

17

MDSCHEMA_COMMANDS

41

DISCOVER_PARTITION_DIMENSION_STAT

18

DMSCHEMA_MINING_SERVICES

42

DISCOVER_PARTITION_STAT

19

DMSCHEMA_MINING_SERVICE_PARAMETERS

43

DISCOVER_DIMENSION_STAT

20

DMSCHEMA_MINING_FUNCTIONS

44

MDSCHEMA_MEASUREGROUP_DIMENSIONS

21

DMSCHEMA_MINING_MODEL_CONTENT

49

DISCOVER_XEVENT_TRACE_DEFINITION

22

DMSCHEMA_MINING_MODEL_XML

23

DMSCHEMA_MINING_MODELS

CurrentTime

2

5

Contains the current time of the discover event, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

StartTime

3

5

Contains the time (if available) at which the discover end event started.. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Contains the time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

Duration

5

2

Contains the approximate amount of time (milliseconds) taken by the discover event.

CPUTime

6

2

Contains the amount of CPU time (in milliseconds) used by the event.

Severity

22

1

Contains the severity level of an exception.

Success

23

1

Contains the success or failure of the discover event. Values are:

0 = Failure

1 = Success

Error

24

1

Contains the error number of any error associated the discover event.

ConnectionID

25

1

Contains the unique connection ID associated with the discover event.

DatabaseName

28

8

Contains the name of the database in which the discover event occurred.

NTUserName

32

8

Contains the Windows user name associated with the object permission event.

NTDomainName

33

8

Contains the Windows domain account associated with the discover event.

ClientProcessID

36

1

Contains the client process ID of the application that initiated the event.

ApplicationName

37

8

Contains the name of the client application that created the connection to the server. This column is populated with the values passed by the application rather than the displayed name of the program.

SessionID

39

8

Contains the session ID associated with the discover event.

NTCanonicalUserName

40

8

Contains the Windows user name associated with the object permission event. The user name is in canonical form. For example, engineering.microsoft.com/software/user.

SPID

41

1

Contains the server process ID (SPID) that uniquely identifies the user session associated with the discover end event. The SPID directly corresponds to the session GUID used by XMLA.

TextData

42

9

Contains the text data associated with the event.

ServerName

43

8

Contains the name of the instance of Analysis Services on which the discover event occurred.

RequestProperties

45

9

Contains the properties in the XMLA request.

See Also

Other Resources

Discover Events Event Category