Domain Table

The Domain table, in combination with the Organization table, contains data about all of the domains, and organizational units that have ever had users or computers report information in a IT Asset Management environment.

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 `Domain` table
Database Column	Details
`OrganizationID`	Type: integer. Key Organizational ID. This is a foreign key into the `Organization` table.
`DN`	Type: text (max 100 characters). Key. Nullable Fully qualified distinguished name.
`DomainType`	Type: text (max 4 characters). Key. Nullable The type of directory service running, for example AD, NT 4.
`FlatName`	Type: text (max 32 characters). Nullable The NT 4 domain name.
`PreferredDomainController`	Type: text (max 32 characters). Nullable Preferred domain controller to query.
`PreferredDomain ControllerOnly`	Type: boolean Whether (0) or not to fail over to alternate server if the preferred domain controller is not contactable.
`ADReconcile`	Type: boolean Whether (1) or not (0) to reconcile the IT Asset Management database with Active Directory.
`ADLoadLatency`	Type: integer If reconciling Active Directory with the IT Asset Management database, the length of time in minutes before the Active Directory data is refreshed in the IT Asset Management database. The default value is 60 minutes. A value of 0 means load the Active Directory data into the IT Asset Management database at each reconciliation. Set this to a high value to minimize network traffic for domains for delayed reconciliation is acceptable.
`MergePolicies`	Type: boolean Whether (1) or not (0) to generate merged policies.
`LastADReconcile`	Type: datetime. Nullable The date and time of the last reconciliation of the IT Asset Management database with Active Directory.
`LastADReconcileStatus`	Type: boolean This field is currently unused.
`LastADLoad`	Type: datetime. Nullable The date and time of the last Active Directory load. A value of NULL indicates that Active Directory data should be loaded at the next reconcile operation.
`LastPolicyMerge`	Type: datetime. Nullable The date and time of the last generation of merged policy.
`LastPolicyMergeStatus`	Type: boolean This field is currently unused.
`DNReverse`	Type: text (max 100 characters). Key. Nullable Fully qualified distinguished name, in reverse order (to improve sub-domain search performance).