VirtualMachine Table

FlexNet Manager Suite (Cloud)

VirtualMachine stores extra information for computers identified as virtual machines or hardware partitions.

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

Database Column

Details

VirtualMachineID

Type: integer. Key. Generated ID

A unique identifier for virtual machine or partition properties associated with a computer.

HostComplianceComputerID

Type: integer. Key. Nullable

The virtual machines or partition’s host computer. Foreign key to the ComplianceComputer table.

ComplianceComputerID

Type: integer. Key

The computer associated with these virtual machine or partition properties. Computer in the ComplianceComputer table.

VMTypeID

Type: integer

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

UUID

Type: text (max 256 characters). Nullable

The UUID (Universally Unique Identifier) of the virtual machine. Used to match virtual machine properties to their associated ComplianceComputer.

VMName

Type: text (max 256 characters). Nullable

The name of the virtual machine or partition.

VMLocation

Type: text (max 256 characters). Nullable

The location of the virtual machine on the file system.

GuestFullName

Type: text (max 256 characters). Nullable

The configured operating system for the guest.

FriendlyName

Type: text (max 256 characters). Nullable

The friendly name of the virtual machine or partition.

VCObjectID

Type: text (max 256 characters). Nullable

The ID of the virtual machine in Virtual Center.

TotalMemory

Type: big integer. Nullable

The total memory of the virtual machine (in bytes).

VMStateID

Type: integer

The state of the virtual machine, related to whether it is linked to a computer or not. Foreign key to the VMState table.

VMPoolID

Type: integer. Nullable

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

ZoneResourceManagement MethodTypeID

Type: integer. Nullable

The resource management method used for this Solaris Zone VM. Foreign key to the ZoneResourceManagementMethodType table.

CPUUsage

Type: integer. Nullable

The maximum CPU usage of the Virtual Machine (measured in MHz).

MemoryUsage

Type: big integer. Nullable

The maximum memory usage of the Virrtual Machine (in bytes).

MaxNumberOfLogical Processors

Type: decimal. Nullable

The maximum number of threads this VM is allowed to access.

VMEnabledStateID

Type: integer

The operational state of the virtual machine (powered on, off, and so on). Foreign key to the VMEnabledState table.

VMSourceTypeID

Type: integer

Whether the virtual machine properties are manually entered or created from inventory. Foreign key to the VMSourceType table.

CreationUser

Type: text (max 256 characters)

The operator who created this record.

CreationDate

Type: datetime

The date/time when this record was created.

UpdatedUser

Type: text (max 256 characters). Nullable

The operator who last updated this record.

UpdatedDate

Type: datetime

The date/time when this record was last updated.

AffinityEnabled

Type: boolean

Set this to True if this VM is unable to move to different host computers.

CPUAffinity

Type: text (max 256 characters). Nullable

Contains the CPU Affinity value for virtual machines (Host Logical processors)

CoreAffinity

Type: text (max 256 characters). Nullable

Contains the Core Affinity value for virtual machine

PartitionID

Type: text (max 100 characters). Nullable

Partition ID generated and used by the managing virtualization platform

PartitionNumber

Type: integer. Nullable

Number of this partition

IsHostAssignedManually

Type: boolean

Was the virtual machine assigned to its host manually? This prevents unlinking of the virtual machine.

FlexNet Manager Suite (Cloud)

Current