Computer Table

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



Type: integer. Key. Generated ID

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


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

The unique ID for the agent on the computer.


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.


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.


Type: unique identifier. Key

A unique external identifier for the computer.


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.


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

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