Session Event – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables SSession 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: 2000000111

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

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

FROM

   [Session Event]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [Session Event] AS [Session Event]
LEFT JOIN
   [User] AS [User]
      ON
         [Session Event].[User SID] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Session Event].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Session Event].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Session Event table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	User SID	User SID	Normal	GUID	16	User SID	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Session Event].[User SID] ,[User].[User Security ID] FROM [Session Event] AS [Session Event] LEFT JOIN [User] AS [User] ON [Session Event].[User SID] = [User].[User Security ID]
2	Server Instance ID	Server Instance ID	Normal	Integer	4	Server Instance ID	int
3	Session ID	Session ID	Normal	Integer	4	Session ID	int
4	Event Type	Event Type	Normal	Option	4	Event Type	int
	Available options are: “Logon” “Logoff” “Start” “Stop” “Close”
5	Event Datetime	Event Datetime	Normal	DateTime	8	Event Datetime	datetime
6	Client Type	Client Type	Normal	Option	4	Client Type	int
	Available options are: “Windows Client” “SharePoint Client” “Web Service” “Client Service” “NAS” “Background” “Management Client” “Web Client” “Unknown” “Tablet” “Phone” “Desktop”
7	Database Name	Database Name	Normal	Text	250	Database Name	nvarchar(500)
8	Client Computer Name	Client Computer Name	Normal	Text	250	Client Computer Name	nvarchar(500)
9	User ID	User ID	Normal	Text	132	User ID	nvarchar(264)
10	Comment	Comment	Normal	Text	132	Comment	nvarchar(264)
11	Session Unique ID	Session Unique ID	Normal	GUID	16	Session Unique ID	uniqueidentifier
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Session Event].[$systemCreatedBy] ,[User].[User Security ID] FROM [Session Event] AS [Session Event] LEFT JOIN [User] AS [User] ON [Session Event].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Session Event].[$systemModifiedBy] ,[User].[User Security ID] FROM [Session Event] AS [Session Event] LEFT JOIN [User] AS [User] ON [Session Event].[$systemModifiedBy] = [User].[User Security ID]