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.
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.
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 |