Product SiteDocumentation Site

9.2.7. v3_0_vm_configuration_view\v3_0_latest_vm_configuration_view

A list of all virtual machines in the system.
Table 9.14. v3_0_vm_configuration_view\v3_0_latest_vm_configuration_view
Name Type Description
history_id integer The ID of the configuration version in the history database.
vm_id uuid The unique ID of this VM in the system.
vm_name varchar(255) The name of the VM.
vm_description varchar(4000) As displayed in the edit dialog.
vm_type smallint
  • 0 - Desktop
  • 1 - Server
cluster_id uuid The unique ID of the cluster this VM belongs to.
template_id uuid The unique ID of the template this VM is derived from. The field is for future use, as the templates are not synchronized to the history database in this version.
template_name varchar(40) Name of the template from which this VM is derived.
cpu_per_socket smallint Virtual CPUs per socket.
number_of_sockets smallint Total number of virtual CPU sockets.
memory_size_mb integer Total memory allocated to the VM, expressed in megabytes (MB).
operating_system smallint
  • 0 - Unknown
  • 1 - Windows XP
  • 3 - Windows 2003
  • 4 - Windows 2008
  • 5 - Other Linux
  • 6 - Other
  • 7 - RHEL 5
  • 8 - RHEL 4
  • 9 - RHEL 3
  • 10 - Windows2003 x64
  • 11 - Windows 7
  • 12 - Windows 7 x64
  • 13 - RHEL 5 x64
  • 14 - RHEL 4 x64
  • 15 - RHEL 3 x64
  • 16 - Windows 2008 x64
  • 17 - Windows 2008R2 x64
  • 18 - RHEL 6
  • 19 - RHEL 6 x64
ad_domain varchar(40) As displayed in the edit dialog.
default_host uuid As displayed in the edit dialog, the ID of the default host in the system.
high_availability Boolean As displayed in the edit dialog.
initialized Boolean A flag to indicate if this VM was started at least once for Sysprep initialization purposes.
stateless Boolean As displayed in the edit dialog.
fail_back Boolean As displayed in the edit dialog.
auto_suspend Boolean As displayed in the edit dialog.
usb_policy smallint As displayed in the edit dialog.
time_zone varchar(40) As displayed in the edit dialog.
cluster_configuration_version integer The cluster configuration version at the time of creation or update.
default_host_configuration_version integer The host configuration version at the time of creation or update.
create_date timestamp with time zone The date this entity was added to the system.
update_date timestamp with time zone The date this entity was changed in the system.
delete_date timestamp with time zone The date this entity was deleted from the system.