PVUVirtualMachineLayer Table

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.