ADComputer Table

The ADComputer table is populated with data from Active Directory in preparation for an Active Directory reconciliation.

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 ADComputer table

Database Column

Details

DomainID

Type: integer. Key

OrganizationID of the domain in which the computer resides.

ComputerCN

Type: text (max 64 characters). Key

The computer’s common name.

ComputerOURDN

Type: text (max 384 characters). Key

The relative distinguished name of the organizational unit or container holding this computer.

GUID

Type: binary (max 16 bytes). Key

The objectGUID of the Active Directory object that represents this computer, if known.

SID

Type: text (max 256 characters). Nullable

The computer’s SID.