ActiveDirectoryComputer Table

The ActiveDirectoryComputer table stores the active directory data for computers.

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

Database Column

Details

ActiveDirectoryComputerID

Type: integer. Key. Generated ID

Auto-generated Active Directory computer ID

GUID

Type: unique identifier. Key

The GUID of the computer.

ComputerName

Type: text (max 64 characters)

The computer name.

ActiveDirectoryDomainID

Type: integer. Key

Foreign key to the ActiveDirectoryDomain table

SID

Type: text (max 256 characters). Key. Nullable

The SID of the computer.