LicenseSimulationHWDetails Table

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