Session Event

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000111

Table Type: System

Table Name: Session Event
Database Table Name: Session Event

Table Number: 0

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Session Event can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Session Event]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[User SID]
   ,[Server Instance ID]
   ,[Session ID]
   ,[Event Datetime]
   ,[Event Type]
   ,[Client Type]
   ,[Database Name]
   ,[Client Computer Name]
   ,[User ID]
   ,[Comment]
   ,[Session Unique ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Session Event]

Show/hide columns in Session Event table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User SID Primary Key Searchuniqueidentifier
3Server Instance ID Primary Key Searchint
4Session ID Primary Key Searchint
5Event Datetime Primary Key Searchdatetime
6Event Type Primary Key Searchint
7Client Type Searchint
8Database Name Searchnvarchar(500)
9Client Computer Name Searchnvarchar(500)
10User ID Searchnvarchar(264)
11Comment Searchnvarchar(264)
12Session Unique ID Searchuniqueidentifier
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *