Notification Events Data Columns

Notification events are events that are not directly caused by users of 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.

The following Sub Class Id:
Sub Class Name pairs are defined:

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 user name associated with the command event. Depending on the environment, the user name is in the following form:
- Windows user account (DOMAIN\UserName)
- User Principal Name (UPN) (username@domain.com)
- Service Principal Name (SPN) (appid@tenantid)
- Power BI Service Account (Power BI Service)
- Power BI Service on behalf of a UPN or SPN (Power BI Service (UPN/SPN))
NTDomainName 33 8 Contains the domain name associated with the user account that triggered the command event.
- Windows domain name for Windows user accounts
- AzureAD for Microsoft Entra accounts
- NT AUTHORITY accounts without a Windows domain name, such as the Power BI service
SessionID 39 8 Contains the session ID associated with the notification event.
NTCanonicalUserName 40 8 Contains the user name associated with the command event. Depending on the environment, the user name is in the following form:
- Windows user account (DOMAIN\UserName)
- User Principal Name (UPN) (username@domain.com)
- Service Principal Name (SPN) (appid@tenantid)
- Power BI Service Account (Power BI Service)
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 user name associated with the command event. Depending on the environment, the user name is in the following form:
- Windows user account (DOMAIN\UserName)
- User Principal Name (UPN) (username@domain.com)
- Service Principal Name (SPN) (appid@tenantid)
- Power BI Service Account (Power BI Service)
- Power BI Service on behalf of a UPN or SPN (Power BI Service (UPN/SPN))
NTDomainName 33 8 Contains the domain name associated with the user account that triggered the command event.
- Windows domain name for Windows user accounts
- AzureAD for Microsoft Entra accounts
- NT AUTHORITY accounts without a Windows domain name, such as the Power BI service
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.