Event Log Entry

The MSSQL_ErrorLogEntry class represents the entries in a SQL Service error log.

Default Collection Interval — Metric is disabled. Uploads data when an alert is raised.

Table 2-36 Event Log Entry Metrics

Metric	Description
Type of Record (key column)	Specifies the type of event. This is an enumerated string
Record Number (key column)	Identifies the event within the Windows logfile (for example, NT Eventlog logfile). This is specific to the logfile and is used together with the logfile name to uniquely identify an instance of this class.
Event Log Entry	Name of the Windows logfile (for example, NT Eventlog logfile). This is used together with the RecordNumber to uniquely identify an instance of this class.
Event Code	This property has the value of the lower 16-bits of the EventIdentifier property. It is present to match the value displayed in the NT Event Viewer. Two events from the same source may have the same value for this property but may have different severity and EventIdentifier values
Event Identifier	Identifies the event. This is specific to the source that generated the event log entry, and is used, together with SourceName, to uniquely identify an NT event type.
Event Severity	Indicates the severity of the event. Two events from the same source may have may have different severity and EventIdentifier values.
Category	Specifies a subcategory for this event. This subcategory is source specific.
User	User name of the logged on user when the event occurred. If the user name cannot be determined this will be NULL.
Event Message	Event message as it appears in the NT Eventlog. This is a standard message with zero or more insertion strings supplied by the source of the NT event. The insertion strings are inserted into the standard message in a predefined format. If there are no insertion strings or there is a problem inserting the insertion strings, only the standard message will be present in this field.