Notification Events Data Columns

Notification events are events that are not directly caused by users of Microsoft SQL Server Analysis Services. For example, notifications occur because of users updating underlying tables for proactive caching.

The Notifications Events event category has the following event class:

Event ID	Event Name	Event Description
39	Notification	Notification event.
40	User Defined	User defined Event.

The following table lists the data columns for the event class.

Notification

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 0 Proactive Caching Begin 1 Proactive Caching End 2 Flight Recorder Started 3 Flight Recorder Stopped 4 Configuration Properties Updated 5 SQL Trace 6 Object Created 7 Object Deleted 8 Object Altered 9 Proactive Caching Polling Begin 10 Proactive Caching Polling End 11 Flight Recorder Snapshot Begin 12 Flight Recorder Snapshot End 13 Proactive Caching: notifiable object updated 14 Lazy Processing: start processing 15 Lazy Processing: processing complete 16 SessionOpened Event Begin 17 SessionOpened Event End 18 SessionClosing Event Begin 19 SessionClosing Event End 20 CubeOpened Event Begin 21 CubeOpened Event End 22 CubeClosing Event Begin 23 CubeClosing Event End 24 Transaction abort requested
CurrentTime	2	5	Contains the current time of the notification event, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime	3	5	Contains the time at which the event started, when available. 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 amount of time (in milliseconds) taken by the event.
IntegerData	10	1	Contains the integer data associated with the notification event. When the EventSubclass column is 8, values are: 1 = Created 2 = Deleted 3 = Changed object's properties 4 = Changed properties of the object's children 6 = Children added 7 = Children deleted 8 = Object fully processed 9 = Object partially processed 10 = Object unprocessed 11 = Object fully optimized 12 = Object partially optimized 13 = Object not optimized
ObjectID	11	8	Contains the Object ID for which this notification is issued; this is a string value.
ObjectType	12	1	Contains the object type associated with the notification event.
ObjectName	13	8	Contains the object name associated with the notification event.
ObjectPath	14	8	Contains the object path associated with the notification event. The path is returned as a comma-separated list of parents, starting with the object's parent.
ObjectReference	15	8	Contains the object reference for the progress report end event. The object reference is encoded as XML by all parents by using tags to describe the object.
ConnectionID	25	1	Contains the unique connection ID associated with the notification event.
DatabaseName	28	8	Contains the name of the database in which the notification event occurred.
NTUserName	32	8	Contains the Windows user name associated with the notification event.
NTDomainName	33	8	Windows domain to which the user belongs.
SessionID	39	8	Contains the session ID associated with the notification event.
NTCanonicalUserName	40	8	Contains the Windows user name associated with the notification 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 notification event. The SPID directly corresponds to the session GUID used by XMLA.
TextData	42	9	Contains the text data associated with the notification event.
ServerName	43	8	Contains the name of the Analysis Services instance on which the notification event occurred.
RequestProperties	45	9	Contains the properties of the XMLA request.

User Defined

Column Name	Column Id	Column Type	Column Description
EventClass	0	1	Event Class is used to categorize events.
EventSubclass	1	1	A specific user event subclass that provides additional information about each event class.
CurrentTime	2	5	Contains the current time of the notification event, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
IntegerData	10	1	A specific user defined event information.
ConnectionID	25	1	Contains the unique connection ID associated with the notification event.
DatabaseName	28	8	Contains the name of the database in which the notification event occurred.
NTUserName	32	8	Contains the Windows user name associated with the notification event.
NTDomainName	33	8	Windows domain to which the user belongs.
SessionID	39	8	Contains the session ID associated with the notification event.
NTCanonicalUserName	40	8	Contains the Windows user name associated with the notification 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 notification event. The SPID directly corresponds to the session GUID used by XMLA.
TextData	42	9	Contains the text data associated with the notification event.
ServerName	43	8	Contains the name of the Analysis Services instance on which the notification event occurred.

See Also

Other Resources

Notification Events Event Category