ComplianceComputer Table

ComplianceComputer stores information about computers used in the enterprise, including hardware details, inventory source information and computer types.

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

Database Column

Details

ComplianceComputerID

Type: integer. Key. Generated ID

A unique identifier for a ComplianceComputer.

ComplianceComputerTypeID

Type: integer. Key

A unique identifier for the type of computer. Foreign key to the ComplianceComputerType table.

IsComplianceComputer TypeIDFromInventory

Type: boolean

This is true for records sourced from inventory, where the inventory source has specified the value of the ComplianceComputerTypeID. A true value will exclude this record from some processes that infer the type of a record. This value is set by the import process.

ComputerName

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

The name of the computer.

ComplianceDomainID

Type: integer. Key. Nullable

The domain to which the computer belongs. Foreign key to the ComplianceDomain table.

ComplianceComputer StatusID

Type: integer. Key

The last recorded status for this computer. Foreign key to the ComplianceComputerStatus table.

ComplianceComputerRoleID

Type: integer. Key

The functional role of this computer. Foreign key to the ComplianceComputerRole table.

ComplianceComputer InventorySourceTypeID

Type: integer. Key

Whether this computer has ever been reported in inventory, or has been manually created and maintained. Foreign key to the ComplianceComputerInventorySourceType table.

AssetID

Type: integer. Key. Nullable

When the computer is being managed as an asset, this is a foreign key to the Asset table; and is otherwise null.

OperatingSystem

Type: text (max 128 characters). Nullable

The operating system of the computer.

ServicePack

Type: text (max 128 characters). Nullable

The latest service pack reported as installed on the operating system.

NumberOfProcessors

Type: integer. Nullable

The number of processors in the computer.

NumberOfProcessorsDefault

Type: integer. Nullable

The inventoried number of processors in the computer.

ProcessorType

Type: text (max 256 characters). Nullable

The type of processor in the computer.

ProcessorTypeDefault

Type: text (max 256 characters). Nullable

The inventoried type of processor in the computer.

MaxClockSpeed

Type: integer. Nullable

The maximum clock speed of the fastest processor in the computer in megahertz.

MaxClockSpeedDefault

Type: integer. Nullable

The inventoried maximum clock speed of the fastest processor in the computer in megahertz.

TotalMemory

Type: big integer. Nullable

The total RAM in the computer.

ChassisTypeID

Type: integer. Key

The type of case for the computer, as reported in hardware inventory, defaulting to Unknown if no chassis type is reported. Foreign key to the ComputerChassisType table.

AssignedChassisTypeID

Type: integer. Nullable

The type of case for the computer, as set by an operator. Foreign key to the ComputerChassisType table.

NumberOfHardDrives

Type: integer. Nullable

The number of hard drives in the computer.

TotalDiskSpace

Type: big integer. Nullable

The total size of all hard drives in the computer.

NumberOfNetworkCards

Type: integer. Nullable

The number of network cards in the computer.

NumberOfDisplayAdapters

Type: integer. Nullable

The number of graphics cards in the computer.

IPAddress

Type: text (max 256 characters). Nullable

The IP address of the computer.

MACAddress

Type: text (max 256 characters). Nullable

The MAC Addresses of the computer.

Manufacturer

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

The manufacturer of the computer.

ModelNo

Type: text (max 128 characters). Nullable

The model number of the computer.

ModelNoDefault

Type: text (max 128 characters). Nullable

The inventoried model number of the computer.

SerialNo

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

The serial number of the computer.

ComplianceUserID

Type: integer. Key. Nullable

The end-user who last logged onto the computer. Foreign key to the ComplianceUser table.

AssignedUserID

Type: integer. Key. Nullable

The end-user assigned to this computer by an operator. Foreign key to the ComplianceUser table.

CalculatedUserID

Type: integer. Key. Nullable

An end-user of this computer, calculated by looking at usage. Foreign key to the ComplianceUser table.

LocationID

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

Any enterprise location associated with this computer. Foreign key to the GroupEx table.

BusinessUnitID

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

Any corporate unit in the enterprise associated with this computer. Foreign key to the GroupEx table.

CostCenterID

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

Any cost center in the enterprise associated with this computer. Foreign key to the GroupEx table.

CategoryID

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

Any enterprise category associated with this computer. Foreign key to the GroupEx table.

InventoryDate

Type: datetime. Key. Nullable

The date the computer last had inventory reported.

HardwareInventoryDate

Type: datetime. Nullable

The date when the hardware was last reported.

ServicesInventoryDate

Type: datetime. Nullable

The date when a service was last reported.

UpdatedUser

Type: text (max 128 characters). Nullable

The name of the operator who last updated the computer details.

UpdatedDate

Type: datetime. Nullable

The date the record was last updated.

CreationUser

Type: text (max 128 characters). Nullable

The operator who created the record.

CreationDate

Type: datetime

The date the computer was created.

InventoryAgent

Type: text (max 64 characters). Nullable

The name of the person or tool that performed the last inventory.

NumberOfCores

Type: integer. Nullable

The number of cores in the computer.

NumberOfCoresDefault

Type: integer. Nullable

The inventoried number of cores in the computer.

NumberOfSockets

Type: integer. Nullable

The number of sockets in the computer.

NumberOfSocketsDefault

Type: integer. Nullable

The inventoried number of sockets in the computer.

AssetComplianceStatusID

Type: integer. Nullable

For computers managed as assets, the latest compliance status of the computer. Foreign key to the AssetComplianceStatus table.

PartialNumberOfProcessors

Type: decimal. Nullable

The fractional processor count available to this computer.

PartialNumberOf ProcessorsDefault

Type: decimal. Nullable

The inventoried fractional processor count available to this computer.

UntrustedSerialNo

Type: boolean

Is this computer known to have a serial number from a data source that should not be trusted.

ILMTAgentID

Type: big integer. Key. Nullable

Store the unique ID used by the ILMT agent on this device, if the inventory source is aware of this value.

FNMPComputerUID

Type: unique identifier. Key. Nullable

The unique identifier generated for the computer from the IM database. This property should only be populated by the ManageSoft inventory adapter.

UUID

Type: unique identifier. Nullable

The computer’s UUID, in the byte order reported in inventory.

HostIdentifyingNumber

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

Virtual hosts may have an identifier that is unique only across that hardware model. This identifier may be the hardware serial number; or may be less unique than the true hardware serial number, for example, the chassis number.

HostType

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

The type (similar to model number) of the host, used for matching.

NumberOfLogicalProcessors

Type: integer. Nullable

The number of logical processors in the computer.

NumberOfLogical ProcessorsDefault

Type: integer. Nullable

The inventoried number of logical processors in the computer.

PrimaryComplianceUserID

Type: integer. Key. Nullable

Primary user of the computer based off the assigned user and calculated user.

MDScheduleGeneratedDate

Type: datetime. Nullable

The last time the managed device schedule was regenerated.

MDScheduleContainsPVUScan

Type: boolean. Nullable

Does this managed device include an event in its current schedule for running extra IBM PVU hardware scans.

HostID

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

Numeric identifier of the current host

FirmwareSerialNumber

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

Serial number in the system firmware such as BIOS, EEPROM etc.

MachineID

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

For AIX, it is the System ID. For HP-UX, it is the Machine/Software ID. It is unset for other platforms.

CloudServiceProviderID

Type: integer. Key. Nullable

The cloud service provider for the virtual machine. Foreign key to the CloudServiceProvider table.

PrimaryInventoryDate

Type: datetime. Nullable

The most recent date the computer had inventory reported from a primary source.

PrimaryInventorySource

Type: text (max 64 characters). Nullable

The name of the person or tool that performed the latest inventory from a primary source.

ArchivedDate

Type: datetime. Nullable

The most recent date on which the computer was transitioned to an archived status.