ADUser Table

The ADUser table contains is populated with data from Active Directory in preparation for an Active Directory reconciliation. It is a temporary table.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.

Table 1. Database columns for `ADUser` table
Database Column	Details
`DomainID`	Type: integer. Key The domain in which this user resides.
`UserCN`	Type: text (max 64 characters). Key The user’s common name.
`UserOURDN`	Type: text (max 384 characters). Key The relative distinguished name of the organizational unit or container holding this user.
`GUID`	Type: binary (max 16 bytes). Key. Nullable The Active Directory GUID of this user.
`SAMAccountName`	Type: text (max 20 characters). Key. Nullable The user’s logon name used to support clients and servers from versions of Windows prior to Windows 2000.
`Sid`	Type: text (max 512 characters). Nullable User’s Sid
`Email`	Type: text (max 200 characters). Nullable The user’s email address.