Discover Events Data Columns

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.

Zobacz także

Inne zasoby

Discover Events Event Category