Computer Table

The Computer table contains all computers that have ever reported information or have been targeted by policy 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 Computer table

Database Column

Details

ComputerID

Type: integer. Key. Generated ID

The ID for the computer. This is automatically generated by SQL Server.

AgentID

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

The unique ID for the agent on the computer.

ComputerOUID

Type: integer. Key

The organizational unit of the computer in Active Directory. In an SMS organization, this is set to the OUID of the unknown OU.

ComputerCN

Type: text (max 256 characters). Key

The computer’s common name. In an Active Directory environment this is the common name attribute of the computer’s distinguished name. This is the same as the SAM account name.

ComputerUID

Type: unique identifier. Key

A unique external identifier for the computer.

OperatingSystemID

Type: integer. Nullable

The operating system of the computer, if known. This allows efficient determination of the operating system breakdown of computers in an organization.

GUID

Type: binary (max 16 bytes). Key. Nullable

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