ComputerResourceData Table

FlexNet Manager Suite (Cloud)

ComputerResourceData stores information about computer resources used in the enterprise.

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

Database Column

Details

ComputerResourceID

Type: integer. Key. Generated ID

A unique identifier for a ComputerResourceData.

ComputerResourceTypeID

Type: integer. Key

The type of resource. Foreign key to the ComputerResourceType table.

ComputerUID

Type: unique identifier. Key. Nullable

The computer resource’s UUID, in the byte order reported in inventory. Foreign key to the Computer table.

ComputerResourceVMPool TypeID

Type: integer. Nullable

If this resource is a resource pool, this specifies the type of pool. Foreign key to the ComputerResourceVMPoolType table.

ComputerResourceVMTypeID

Type: integer. Key. Nullable

If this resource is a virtual machine, this specifies the type of virtual machine or partition. Foreign key to the ComputerResourceVMType table.

NormalizedSerialNo

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

The serial number of the resource in a normalized format.

Name

Type: text (max 256 characters). Nullable

The name of the resource.

Manufacturer

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

The manufacturer of the resource.

ModelNo

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

The model number of the resource.

SerialNo

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

The serial number of the resource.

IsFabricatedHost

Type: boolean

Is the host generated from the virtual machine inventory.

LastUpdated

Type: datetime. Nullable

The last time this computer resource was updated.

FlexNet Manager Suite (Cloud)

Current