Server Instance

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

Table Type: System

Table Name: Server Instance
Database Table Name: Server Instance

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 Server Instance can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Server Instance]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Server Instance ID]
   ,[Service Name]
   ,[Server Computer Name]
   ,[Last Active]
   ,[Server Instance Name]
   ,[Server Port]
   ,[Management Port]
   ,[Status]
   ,[Last Tenant Config Version]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Server Instance]

Show/hide columns in Server Instance table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Server Instance ID Primary Key Searchint
3Service Name Searchnvarchar(500)
4Server Computer Name Searchnvarchar(500)
5Last Active Searchdatetime
6Server Instance Name Searchnvarchar(500)
7Server Port Searchint
8Management Port Searchint
9Status Searchint
10Last Tenant Config Version Searchbigint
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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