LicenseSimulationHWDetails Table

FlexNet Manager Suite (Cloud)

LicenseSimulationHWDetails stores a complete snapshot of hardware data for simulations. The LicenseSimulationScenario associated with each record could be an original snapshot of data, or a user modifiable scenario.

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

Database Column

Details

LicenseSimulationHW DetailsID

Type: integer. Key. Generated ID

A unique identifier for a hardware item that is part of a simulation scenario.

LicenseSimulation ScenarioID

Type: integer. Key

The simulation scenario this hardware item is part of. Foreign key to the LicenseSimulationScenario table.

Name

Type: text (max 256 characters). Nullable

The friendly name for this hardware item.

LicenseSimulationRow TypeID

Type: integer

The type of hardware for this item.

Manufacturer

Type: text (max 128 characters). Nullable

The manufacturer of this hardware item. Typically applies to a virtualisation server.

ModelNo

Type: text (max 128 characters). Nullable

The model number of this hardware item. Typically applies to a virtualisation server.

ChassisNumber

Type: text (max 128 characters). Nullable

The chassis number of this hardware item. Typically applies to a virtualisation server.

SerialNo

Type: text (max 100 characters). Nullable

The serial number of this hardware item. Typically applies to a virtualisation server or physical machine.

ProcessorType

Type: text (max 256 characters). Nullable

The processor type of this hardware item.

MaxClockSpeed

Type: integer. Nullable

The maximum clock speed of this hardware item.

PurchaseDate

Type: datetime. Nullable

The date this hardware item was purchased on, if it has an associated Asset.

NumSockets

Type: integer. Nullable

The number of physical CPU sockets of this hardware item.

PoolTypeID

Type: integer. Nullable

The type of pool technology of this hardware item. Typically applies to resource pools. Foreign key to the VMPoolType table.

VMTypeID

Type: integer. Nullable

The type of virtual machine technology of this hardware item. Typically applies to virtual machines. Foreign key to the VMType table.

OperatingSystem

Type: text (max 128 characters). Nullable

The operating system running on this hardware item.

NumProcessors

Type: decimal. Nullable

The number of processors available to this hardware item.

NumCores

Type: decimal. Nullable

The number of cores available to this hardware item.

NumThreads

Type: integer. Nullable

The number of threads available to this hardware item.

MaxNumberOfLogical Processors

Type: decimal. Nullable

The configured maximum number of logical processors(ie, threads) for this hardware item, if applicable.

ParentLicense SimulationHWDetailsID

Type: integer. Key. Nullable

The parent hardware item of this item.

HostLicenseSimulationH WDetailsID

Type: integer. Nullable

The host hardware item of this item.

ComplianceComputerID

Type: integer. Key. Nullable

The actual computer record for this hardware item. Foreign key to the ComplianceComputer table.

VMLayerID

Type: integer. Key. Nullable

Internal unique identifier used when populating hardware items to create a new simulation.

LicenseSimulation ChangeTypeID

Type: integer

Tracks the state of the hardware item, as it gets modified by the simulation user. Foreign key to the LicenseSimulationChangeType table.

ClusterID

Type: integer. Nullable

The hardware cluster to which this computer belongs, if any. Foreign key to the Cluster table.

AffinityEnabled

Type: boolean

Whether this VM is locked to its current host computer.

CoreAffinity

Type: text (max 256 characters). Nullable

Contains the Core Affinity value for virtual machine

CloudServiceProviderID

Type: integer. Key. Nullable

The cloud service provider for the virtual machine

FlexNet Manager Suite (Cloud)

Current