ImportedVirtualMachine Table

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.