PVUVirtualMachineLayer Table

FlexNet Manager Suite (Cloud)

This serves as an intermediate table during PVU reconciliation process to store virtual machines, pools and hosts in a generalized tree structure.

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

Database Column

Details

PVUVirtualMachineLayerID

Type: integer. Key

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

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.

ParentPVUVirtual MachineLayerID

Type: integer. Key. Nullable

The parent hardware item of this item. Foreign key to the PVUVirtualMachineLayer table.

HostPVUVirtualMachine LayerID

Type: integer. Key. Nullable

The host hardware item of this item. Foreign key to the PVUVirtualMachineLayer table.

ComplianceComputerID

Type: integer. Key. Nullable

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

HostComplianceComputerID

Type: integer. Key. Nullable

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

ExternalID

Type: integer. Key. Nullable

The identifier used in the source connection for the end-user.

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.

VMPoolID

Type: integer. Nullable

The resource pool that the virtual machine belongs to. Foreign key to the VMPool table.

VirtualMachineID

Type: integer. Nullable

The identifier of this virtual machine. Foreign key to the VirtualMachine table.

ParentVMPoolID

Type: integer. Nullable

The identifier of the parent VM pool of this pool. Foreign key to the VMPool table.

ClusterID

Type: integer. Nullable

The hardware cluster to which this computer belongs, if any. Foreign key to the Cluster 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.

PartialNumberOfProcessors

Type: decimal. Nullable

The fractional processor count available to this layer.

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.

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.

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

IsFlexNetInventory

Type: boolean. Nullable

Whether this VM inventory was obtained from the FlexNet Manager agent.

FlexNet Manager Suite (Cloud)

Current