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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | User SID  | uniqueidentifier |
| 3 | Server Instance ID | int |
| 4 | Session ID | int |
| 5 | Event Datetime | datetime |
| 6 | Event Type | int |
| 7 | Client Type | int |
| 8 | Database Name | nvarchar(500) |
| 9 | Client Computer Name | nvarchar(500) |
| 10 | User ID | nvarchar(264) |
| 11 | Comment | nvarchar(264) |
| 12 | Session Unique ID | uniqueidentifier |
| 13 | $systemId | uniqueidentifier |
| 14 | $systemCreatedAt | datetime |
| 15 | $systemCreatedBy | uniqueidentifier |
| 16 | $systemModifiedAt | datetime |
| 17 | $systemModifiedBy | uniqueidentifier |