Azure AD App Setup

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

Table Type: System

Table Name: Azure AD App Setup
Database Table Name:

Table Number: 6300

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 Azure AD App Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   []

Show/hide an example select of all columns by name

SELECT

FROM
   []

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

SELECT
   *
FROM
   [] AS [Azure AD App Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [Azure AD App Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Azure AD App Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Azure AD App Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1App ID SearchApp IDNormalGUID16
2Secret Key SearchSecret KeyNormalBLOB8
3Primary Key SearchPrimary KeyNormalInteger4
4Redirect URL Primary Key SearchRedirect URLNormalText150
5Isolated Storage Secret Key SearchIsolated Storage Secret KeyNormalGUID16
2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
Key to join to the User table.

Show/hide example query

SELECT
	       [Azure AD App Setup].[]
	       ,[User].[User Security ID]
	FROM
	       [] AS [Azure AD App Setup]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Azure AD App Setup].[] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8
2000000004SystemModifiedBy SearchModified ByNormalGUID16

Leave a Reply

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