Active Session

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

Table Type: System

Table Name: Active Session
Database Table Name: Active Session

Table Number: 2000000110

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 Active Session can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Active Session]

Show/hide an example select of all columns by name

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

Show/hide columns in Active Session table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Server Instance ID Primary Key Searchint
3Session ID Primary Key Searchint
4User SID Searchuniqueidentifier
5Server Instance Name Searchnvarchar(500)
6Server Computer Name Searchnvarchar(500)
7User ID Searchnvarchar(264)
8Client Type Searchint
9Client Computer Name Searchnvarchar(500)
10Login Datetime Searchdatetime
11Database Name Searchnvarchar(500)
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 *