ImportedPVUVirtualMachineLayer Table

The ImportedPVUVirtualMachineLayer table holds all of the computers which have been retrieved from the IM database.

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

Database Column

Details

ExternalID

Type: integer. Key

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

HostExternalID

Type: integer. Key. Nullable

The host item on which the layer resides, or the computer itself. Foreign key to the ImportedPVUVirtualMachineLayer table.

ParentExternalID

Type: integer. Key. Nullable

The parent layer. Foreign key to the ImportedPVUVirtualMachineLayer table

ComplianceConnectionID

Type: integer. Key. Nullable

The identifier for a data source connection in the ComplianceConnection table.

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.

VMPoolTypeID

Type: integer. Nullable

The type of this VM pool. Foreign key to the VMPoolType table.

VMTypeID

Type: integer. Nullable

The type of this virtual machine. Foreign key to the VMType table.

Name

Type: text (max 256 characters). Nullable

The name of the layer (host/pool/VM).

Manufacturer

Type: text (max 128 characters). Nullable

The manufacturer of this layer.

ModelNo

Type: text (max 128 characters). Nullable

The model number of this layer.

SerialNo

Type: text (max 100 characters). Nullable

The serial number of this layer.

IsFabricatedHost

Type: boolean

Is the host generated from the virtual machine inventory.

PartialNumberOfProcessors

Type: decimal. Nullable

The fractional processor count available to this layer.

ProcessorType

Type: text (max 256 characters). Nullable

The type of processor in this layer.

MaxClockSpeed

Type: integer. Nullable

The maximum clock speed (in megahertz) of the fastest processor in this layer.

NumberOfProcessors

Type: decimal. Nullable

The processor count for this layer.

NumberOfCores

Type: decimal. Nullable

The core count for this layer.

MaxNumberOfLogical Processors

Type: decimal. Nullable

The maximum number of logical processors count for this layer.

NumberOfLogicalProcessors

Type: decimal. Nullable

The thread count for this layer.

LicenseSimulationRow TypeID

Type: integer

The type of hardware for this item. Foreign key to the LicenseSimulationRowType table.