Red Hat Training

A Red Hat training course is available for Red Hat Virtualization

2.8. Configuration History Views

To query a configuration view, run SELECT * FROM view_name;. For example:

# SELECT * FROM v4_2_configuration_history_datacenters;

To list all available views, run:

# \dv

Note

delete_date does not appear in latest views because these views provide the latest configuration of living entities, which, by definition, have not been deleted.

2.8.1. Data Center Configuration

The following table shows the configuration history parameters of the data centers in the system.

Table 2.8. v4_2_configuration_history_datacenters

Name	Type	Description	Indexed
history_id	integer	The ID of the configuration version in the history database. This is identical to the value of `datacenter_configuration_version` in the `v4_2_configuration_history_clusters` view and it can be used to join them.	No
datacenter_id	uuid	The unique ID of the data center in the system.	Yes
datacenter_name	character varying(40)	Name of the data center, as displayed in the edit dialog.	No
datacenter_description	character varying(4000)	Description of the data center, as displayed in the edit dialog.	No
is_local_storage	boolean	A flag to indicate whether the data center uses local storage.	No
create_date	timestamp with time zone	The date this entity was added to the system.	No
update_date	timestamp with time zone	The date this entity was changed in the system.	No
delete_date	timestamp with time zone	The date this entity was deleted from the system.	No

2.8.2. Data Center Storage Domain Map

The following table shows the relationships between storage domains and data centers in the system.

Table 2.9. v4_2_map_history_datacenters_storage_domains

Name	Type	Description	Indexed
history_id	integer	The ID of the configuration version in the history database. This is identical to the value of `datacenter_configuration_version` in the `v4_2_configuration_history_clusters` view and it can be used to join them.	No
storage_domain_id	uuid	The unique ID of this storage domain in the system.	Yes
datacenter_id	uuid	The unique ID of the data center in the system.	No
attach_date	timestamp with time zone	The date the storage domain was attached to the data center.	No
detach_date	timestamp with time zone	The date the storage domain was detached from the data center.	No

2.8.3. Storage Domain Configuration

The following table shows the configuration history parameters of the storage domains in the system.

Table 2.10. v4_2_configuration_history_storage_domains

Name	Type	Description	Indexed
history_id	integer	The ID of the configuration version in the history database. This is identical to the value of `storage_configuration_version` in the storage domain statistics views and it can be used to join them.	No
storage_domain_id	uuid	The unique ID of this storage domain in the system.	Yes
storage_domain_name	character varying(250)	Storage domain name.	No
storage_domain_type	smallint	* 0 - Data (Master) * 1 - Data * 2 - ISO * 3 - Export	No
storage_type	smallint	* 0 - Unknown * 1 - NFS * 2 - FCP * 3 - iSCSI * 4 - Local * 6 - All	No
create_date	timestamp with time zone	The date this entity was added to the system.	No
update_date	timestamp with time zone	The date this entity was changed in the system.	No
delete_date	timestamp with time zone	The date this entity was deleted from the system.	No

2.8.4. Cluster Configuration

The following table shows the configuration history parameters of the clusters in the system.

Table 2.11. v4_2_configuration_history_clusters

Name	Type	Description	Indexed
history_id	integer	The ID of the configuration version in the history database. This is identical to the value of `cluster_configuration_version` in the `v4_2_configuration_history_hosts` and `v4_2_configuration_history_vms` views and it can be used to join them.	No
cluster_id	uuid	The unique identifier of the datacenter this cluster resides in.	Yes
cluster_name	character varying(40)	Name of the cluster, as displayed in the edit dialog.	No
cluster_description	character varying(4000)	As defined in the edit dialog.	No
datacenter_id	uuid	The unique identifier of the datacenter this cluster resides in.	Yes
cpu_name	character varying(255)	As displayed in the edit dialog.	No
compatibility_version	character varying(40)	As displayed in the edit dialog.	No
datacenter_configuration_version	integer	The data center configuration version at the time of creation or update. The data center configuration version at the time of creation or update. This is identical to the value of `history_id` in the `v4_2_configuration_history_datacenters` view and it can be used to join them.	No
create_date	timestamp with time zone	The date this entity was added to the system.	No
update_date	timestamp with time zone	The date this entity was changed in the system.	No
delete_date	timestamp with time zone	The date this entity was deleted from the system.	No

2.8.5. Host Configuration

The following table shows the configuration history parameters of the hosts in the system.

Table 2.12. v4_2_configuration_history_hosts

Name	Type	Description	Indexed
history_id	integer	The ID of the configuration version in the history database. This is identical to the value of `host_configuration_version` in the host statistics views and it can be used to join them.	No
host_id	uuid	The unique ID of the host in the system.	Yes
host_unique_id	character varying(128)	This field is a combination of the host’s physical UUID and one of its MAC addresses, and is used to detect hosts already registered in the system.	No
host_name	character varying(255)	Name of the host (same as in the edit dialog).	No
cluster_id	uuid	The unique ID of the cluster that this host belongs to.	Yes
host_type	smallint	* 0 - RHEL Host * 2 - RHEV Hypervisor Node	No
fqdn_or_ip	character varying(255)	The host’s DNS name or its IP address for Red Hat Virtualization Manager to communicate with (as displayed in the edit dialog).	No
memory_size_mb	integer	The host’s physical memory capacity, expressed in megabytes (MB).	No
swap_size_mb	integer	The host swap partition size.	No
cpu_model	character varying(255)	The host’s CPU model.	No
number_of_cores	smallint	Total number of CPU cores in the host.	No
number_of_sockets	smallint	Total number of CPU sockets.	No
cpu_speed_mh	numeric(18,0)	The host’s CPU speed, expressed in megahertz (MHz).	No
host_os	character varying(255)	The host’s operating system version.	No
kernel_version	character varying(255)	The host’s kernel version.	No
kvm_version	character varying(255)	The host’s KVM version.	No
vdsm_version	character varying	The host’s VDSM version.	No
vdsm_port	integer	As displayed in the edit dialog.	No
threads_per_core	smallint	Total number of threads per core.	No
hardware_manufacturer	character varying(255)	The host’s hardware manufacturer.	No
hardware_product_name	character varying(255)	The product name of the host’s hardware.	No
hardware_version	character varying(255)	The version of the host’s hardware.	No
hardware_serial_number	character varying(255)	The serial number of the host’s hardware.	No
cluster_configuration_version	integer	The cluster configuration version at the time of creation or update. This is identical to the value of `history_id` in the `v4_2_configuration_history_clusters` view and it can be used to join them.	No
create_date	timestamp with time zone	The date this entity was added to the system.	No
update_date	timestamp with time zone	The date this entity was changed in the system.	No
delete_date	timestamp with time zone	The date this entity was deleted from the system.	No

2.8.6. Host Interface Configuration

The following table shows the configuration history parameters of the host interfaces in the system.

Table 2.13. v4_2_configuration_history_hosts_interfaces

Name	Type	Description	Indexed
history_id	integer	The ID of the configuration version in the history database. This is identical to the value of `host_interface_configuration_version` in the host interface statistics views and it can be used to join them.	No
host_interface_id	uuid	The unique ID of this interface in the system.	Yes
host_interface_name	character varying(50)	The interface name as reported by the host.	No
host_id	uuid	Unique ID of the host this interface belongs to.	Yes
host_interface_type	smallint	* 0 - rt18139_pv * 1 - rt18139 * 2 - e1000 * 3 - pv	No
host_interface_speed_bps	integer	The interface speed in bits per second.	No
mac_address	character varying(59)	The interface MAC address.	No
logical_network_name	character varying(50)	The logical network associated with the interface.	No
ip_address	character varying(20)	As displayed in the edit dialog.	No
gateway	character varying(20)	As displayed in the edit dialog.	No
bond	boolean	A flag to indicate if this interface is a bonded interface.	No
bond_name	character varying(50)	The name of the bond this interface is part of (if it is part of a bond).	No
vlan_id	integer	As displayed in the edit dialog.	No
host_configuration_version	integer	The host configuration version at the time of creation or update. This is identical to the value of `history_id` in the `v4_2_configuration_history_hosts` view and it can be used to join them.	No
create_date	timestamp with time zone	The date this entity was added to the system.	No
update_date	timestamp with time zone	The date this entity was changed in the system.	No
delete_date	timestamp with time zone	The date this entity was deleted from the system.	No

2.8.7. Virtual Machine Configuration

The following table shows the configuration history parameters of the virtual machines in the system.

Table 2.14. v4_2_configuration_history_vms

Name	Type	Description	Indexed
history_id	integer	The ID of the configuration version in the history database. This is identical to the value of `vm_configuration_version` in the virtual machine statistics views and it can be used to join them.	No
vm_id	uuid	The unique ID of this virtual machine in the system.	Yes
vm_name	character varying(255)	The name of the virtual machine.	No
vm_description	character varying(4000)	As displayed in the edit dialog.	No
vm_type	smallint	* 0 - Desktop * 1 - Server	No
cluster_id	uuid	The unique ID of the cluster this virtual machine belongs to.	Yes
template_id	uuid	The unique ID of the template this virtual machine is derived from. Templates are not synchronized to the history database in this version of Red Hat Virtualization.	No
template_name	character varying(40)	Name of the template from which this virtual machine is derived.	No
cpu_per_socket	smallint	Virtual CPUs per socket.	No
number_of_sockets	smallint	Total number of virtual CPU sockets.	No
memory_size_mb	integer	Total memory allocated to the virtual machine, expressed in megabytes (MB).	No
operating_system	smallint	* 0 - Other OS * 1 - Windows XP * 3 - Windows 2003 * 4 - Windows 2008 * 5 - Linux * 7 - Red Hat Enterprise Linux 5.x * 8 - Red Hat Enterprise Linux 4.x * 9 - Red Hat Enterprise Linux 3.x * 10 - Windows 2003 x64 * 11 - Windows 7 * 12 - Windows 7 x64 * 13 - Red Hat Enterprise Linux 5.x x64 * 14 - Red Hat Enterprise Linux 4.x x64 * 15 - Red Hat Enterprise Linux 3.x x64 * 16 - Windows 2008 x64 * 17 - Windows 2008 R2 x64 * 18 - Red Hat Enterprise Linux 6.x * 19 - Red Hat Enterprise Linux 6.x x64 * 20 - Windows 8 * 21 - Windows 8 x64 * 23 - Windows 2012 x64 * 1001 - Other * 1002 - Linux * 1003 - Red Hat Enterprise Linux 6.x * 1004 - SUSE Linux Enterprise Server 11 * 1193 - SUSE Linux Enterprise Server 11 * 1252 - Ubuntu Precise Pangolin LTS * 1253 - Ubuntu Quantal Quetzal * 1254 - Ubuntu Raring Ringtails * 1255 - Ubuntu Saucy Salamander	No
default_host	uuid	As displayed in the edit dialog, the ID of the default host in the system.	No
high_availability	boolean	As displayed in the edit dialog.	No
initialized	boolean	A flag to indicate if this virtual machine was started at least once for Sysprep initialization purposes.	No
stateless	boolean	As displayed in the edit dialog.	No
fail_back	boolean	As displayed in the edit dialog.	No
usb_policy	smallint	As displayed in the edit dialog.	No
time_zone	character varying(40)	As displayed in the edit dialog.	No
vm_pool_id	uuid	The ID of the pool to which this virtual machine belongs.	No
vm_pool_name	character varying(255)	The name of the virtual machine’s pool.	No
created_by_user_id	uuid	The ID of the user that created this virtual machine.	No
cluster_configuration_version	integer	The cluster configuration version at the time of creation or update. This is identical to the value of `history_id` in the `v4_2_configuration_history_clusters` view and it can be used to join them.	No
default_host_configuration_version	integer	The host configuration version at the time of creation or update. This is identical to the value of `history_id` in the `v4_2_configuration_history_hosts` view and it can be used to join them.	No
create_date	timestamp with time zone	The date this entity was added to the system.	No
update_date	timestamp with time zone	The date this entity was changed in the system.	No
delete_date	timestamp with time zone	The date this entity was deleted from the system.	No

2.8.8. Virtual Machine Interface Configuration

The following table shows the configuration history parameters of the virtual interfaces in the system.

Table 2.15. v4_2_configuration_history_vms_interfaces

Name	Type	Description	Indexed
history_id	integer	The ID of the configuration version in the history database. This is identical to the value of `vm_interface_configuration_version` in the virtual machine interface statistics view and it can be used to join them.	No
vm_id	uuid	Unique ID of the virtual machine in the system.	Yes
vm_interface_id	uuid	The unique ID of this interface in the system.	Yes
vm_interface_name	character varying(50)	As displayed in the edit dialog.	No
vm_interface_type	smallint	The type of the virtual interface. * 0 - rt18139_pv * 1 - rt18139 * 2 - e1000 * 3 - pv	No
vm_interface_speed_bps	integer	The average speed of the interface during the aggregation in bits per second.	No
mac_address	character varying(20)	As displayed in the edit dialog.	No
logical_network_name	character varying(50)	As displayed in the edit dialog.	No
vm_configuration_version	integer	The virtual machine configuration version at the time of creation or update. This is identical to the value of `history_id` in the `v4_2_configuration_history_vms` view and it can be used to join them.	No
create_date	timestamp with time zone	The date this entity was added to the system.	No
update_date	timestamp with time zone	The date this entity was changed in the system.	No
delete_date	timestamp with time zone	The date this entity was deleted from the system.	No

2.8.9. Virtual Machine Device Configuration

The following table shows the relationships between virtual machines and their associated devices, including disks and virtual interfaces.

Table 2.16. v4_2_configuration_history_vms_devices

Name	Type	Description	Indexed
history_id	integer	The ID of the configuration version in the history database.	No
vm_id	uuid	The unique ID of the virtual machine in the system.	Yes
device_id	uuid	The unique ID of the device in the system.	No
type	character varying(30)	The type of virtual machine device. This can be "disk" or "interface".	Yes
address	character varying(255)	The device’s physical address.	No
is_managed	boolean	Flag that indicates if the device is managed by the Manager.	No
is_plugged	boolean	Flag that indicates if the device is plugged into the virtual machine.	No
is_readonly	boolean	Flag that indicates if the device is read only.	No
vm_configuration_version	integer	The virtual machine configuration version at the time the sample was taken.	No
device_configuration_version	integer	The device configuration version at the time the sample was taken. - If the value of the `type` field is set to `interface`, this field is joined with the `history_id` field in the `v4_2_configuration_history_vms_interfaces` view. - If the value of the `type` field is set to disk, this field is joined with the `history_id` field in the `v4_2_configuration_history_vms_disks` view.	No
create_date	timestamp with time zone	The date this entity was added to the system.	No
update_date	timestamp with time zone	The date this entity was added to the system.	No
delete_date	timestamp with time zone	The date this entity was added to the system.	No

2.8.10. Virtual Disk Configuration

The following table shows the configuration history parameters of the virtual disks in the system.

Table 2.17. v4_2_configuration_history_vms_disks

Name	Type	Description	Indexed
history_id	integer	The ID of the configuration version in the history database. This is identical to the value of `vm_disk_configuration_version` in the virtual disks statistics views and it can be used to join them.	No
vm_disk_id	uuid	The unique ID of this disk in the system.	Yes
vm_disk_name	text	The name of the virtual disk, as displayed in the edit dialog.	No
vm_disk_description	character varying(500)	As displayed in the edit dialog.	No
image_id	uuid	The unique ID of the image in the system.	No
storage_domain_id	uuid	The ID of the storage domain this disk image belongs to.	Yes
vm_disk_size_mb	integer	The defined size of the disk in megabytes (MB).	No
vm_disk_type	smallint	As displayed in the edit dialog. Only System and Data are currently used. * 0 - Unassigned * 1 - System * 2 - Data * 3 - Shared * 4 - Swap * 5 - Temp	No
vm_disk_format	smallint	As displayed in the edit dialog. * 3 - Unassigned * 4 - COW * 5 - Raw	No
is_shared	boolean	Flag that indicates if the virtual machine’s disk is shared.	No
create_date	timestamp with time zone	The date this entity was added to the system.	No
update_date	timestamp with time zone	The date this entity was changed in the system.	No
delete_date	timestamp with time zone	The date this entity was deleted from the system.	No

2.8.11. User Details History

The following table shows the configuration history parameters of the users in the system.

Table 2.18. v4_2_users_details_history

Name	Type	Description
user_id	uuid	The unique ID of the user in the system, as generated by the Manager.
first_name	character varying(255)	The user’s first name.
last_name	character varying(255)	The user’s last name.
domain	character varying(255)	The name of the authorization extension.
username	character varying(255)	The account name.
department	character varying(255)	The organizational department the user belongs to.
user_role_title	character varying(255)	The title or role of the user within the organization.
email	character varying(255)	The email of the user in the organization.
external_id	text	The unique identifier of the user from the external system.
active	boolean	A flag to indicate if the user is active or not. This is checked hourly. If the user can be found in the authorization extension then it will remain active. A user becomes active on successful login.
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.

Select Your Language

Language:

Language:

Red Hat Training

2.8. Configuration History Views

2.8.1. Data Center Configuration

2.8.2. Data Center Storage Domain Map

2.8.3. Storage Domain Configuration

2.8.4. Cluster Configuration

2.8.5. Host Configuration

2.8.6. Host Interface Configuration

2.8.7. Virtual Machine Configuration

2.8.8. Virtual Machine Interface Configuration

2.8.9. Virtual Machine Device Configuration

2.8.10. Virtual Disk Configuration

2.8.11. User Details History

Quick Links

Help

Site Info

Related Sites

About

Red Hat legal and privacy links

Red Hat legal and privacy links

Language:

Language and Page Formatting Options

Language:

Red Hat Training

2.8. Configuration History Views

2.8.1. Data Center Configuration

2.8.2. Data Center Storage Domain Map

2.8.3. Storage Domain Configuration

2.8.4. Cluster Configuration

2.8.5. Host Configuration

2.8.6. Host Interface Configuration

2.8.7. Virtual Machine Configuration

2.8.8. Virtual Machine Interface Configuration

2.8.9. Virtual Machine Device Configuration

2.8.10. Virtual Disk Configuration

2.8.11. User Details History

Quick Links

Help

Site Info

Related Sites

Systems Status

About

Red Hat legal and privacy links

Red Hat legal and privacy links