ComplianceComputer Table

FlexNet Manager Suite 2020 R1 (On-Premises)

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. It is less unique than the true hardware serial number, for example.
`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.

FlexNet Manager Suite (On-Premises)

2020 R1