Intelligent Cloud Status

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

Table Type: System

Table Name: Intelligent Cloud Status
Database Table Name: Intelligent Cloud Status

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 Intelligent Cloud Status can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Intelligent Cloud Status]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Table Name]
   ,[Company Name]
   ,[Table Id]
   ,[Synced Version]
   ,[Blocked]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Intelligent Cloud Status]

Show/hide columns in Intelligent Cloud Status table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Table Name Primary Key Searchnvarchar(500)
3Company Name Primary Key Searchnvarchar(60)
4Table Id Searchint
5Synced Version Searchbigint
6Blocked Searchtinyint
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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