ImportedVirtualMachine Table

FlexNet Manager Suite (Cloud)

The ImportedVirtualMachine table holds all of the virtual machines which have been retrieved from the source connections.

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

Database Column

Details

HostComputerID

Type: big integer. Key. Nullable

The identifier used in the source connection for the virtual machine’s host computer.

VirtualMachineType

Type: text (max 100 characters). Nullable

The type of virtual machine.

VMName

Type: text (max 256 characters). Nullable

The name of the virtual machine.

VCObjectID

Type: text (max 256 characters). Nullable

The identifier of the virtual machine in Virtual Center.

FriendlyName

Type: text (max 256 characters). Nullable

The friendly name of the virtual machine.

ComputerName

Type: text (max 256 characters). Nullable

The computer name of the virtual machine.

UUID

Type: text (max 256 characters). Key. Nullable

The UUID of the virtual machine.

TotalMemory

Type: big integer. Nullable

The total RAM in the computer, in bytes.

PoolName

Type: text (max 100 characters). Nullable

The name of the pool that the virtual machine belongs to.

CPUUsage

Type: integer. Nullable

The maximum CPU usage of the virtual machine (MHz).

MemoryUsage

Type: big integer. Nullable

The maximum memory usage of the virtual machine (bytes).

MaxNumberOfLogical Processors

Type: decimal. Nullable

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

VMEnabledStateID

Type: integer. Nullable

The state of the machine (powered on, off, etc).

ModelNo

Type: text (max 128 characters). Nullable

The model number of the virtual machine.

Manufacturer

Type: text (max 128 characters). Nullable

The manufacturer of the computer hardware. Some examples include:

  • On Windows, the SMBios manufacturer (the WMI Manufacturer property of the ‘Win32_ComputerSystem’ class).
  • On Linux, ‘Manufacturer’ in the ‘System Information’ section resulting from the ‘dmidecode’ command. Sample command: ‘dmidecode -s system-manufacturer’
  • On Solaris x86, as for Linux, with failovers first to ‘sysinfo SI_HW_PROVIDER’ and then to ‘ModelNo’.
  • On Solaris SPARC, the ‘sysinfo SI_HW_PROVIDER’. Typically this value is ‘Sun_Microsystems’ or, more recently, ‘Oracle Corporation’. Failover to the ‘ModelNo’.
  • On HP-UX, the string literal ‘HP’.
  • On AIX, the ‘modelname’ system attribute preceding the comma character. For example, if the ‘modelname’ system attribute is ‘IBM,8202-E4B’, then use ‘IBM’. This value is typically ‘IBM’.
NumberOfProcessors

Type: integer. Nullable

The number of processors in the virtual machine.

ProcessorType

Type: text (max 256 characters). Nullable

The type of processor in the virtual machine.

NumberOfHardDrives

Type: integer. Nullable

The number of hard drives in the virtual machine.

NumberOfNetworkCards

Type: integer. Nullable

The number of network cards in the virtual machine.

InventoryAgent

Type: text (max 64 characters). Nullable

The name of the person or tool that performed the last inventory.

ComplianceConnectionID

Type: integer. Key. Nullable

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

VMLocation

Type: text (max 256 characters). Nullable

Location of the virtual machine on the file system.

GuestFullName

Type: text (max 256 characters). Nullable

Configured operating system for the guest.

VMComputerID

Type: big integer. Key. Nullable

The identifier used in the source connection for the virtual machine’s computer.

PoolType

Type: text (max 100 characters). Nullable

The type of the pool that the virtual machine belongs to.

ZoneResourceManagement MethodType

Type: text (max 100 characters). Nullable

Resource management method used for this virtual machine in Solaris Zone.

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 machine(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

FullComputerName

Type: text (max 256 characters). Nullable

The virtual machine full computer name as determined by the VM guest managing tool.

IPAddress

Type: text (max 256 characters). Nullable

IP Address of the virtual machine as determined by the VM guest managing tool.

FlexNet Manager Suite (Cloud)

Current