2.8. Configuration History Views
To query a configuration view, run SELECT * FROM view_name;
. For example:
# SELECT * FROM v4_3_configuration_history_datacenters;
To list all available views, run:
# \dv
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.
Name | Type | Description | Indexed |
---|---|---|---|
history_id | integer |
The ID of the configuration version in the history database. This is identical to the value of | 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.
Name | Type | Description | Indexed |
---|---|---|---|
history_id | integer |
The ID of the configuration version in the history database. This is identical to the value of | 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.
Name | Type | Description | Indexed |
---|---|---|---|
history_id | integer |
The ID of the configuration version in the history database. This is identical to the value of | 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.
Name | Type | Description | Indexed |
---|---|---|---|
history_id | integer |
The ID of the configuration version in the history database. This is identical to the value of | 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 | 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.
Name | Type | Description | Indexed |
---|---|---|---|
history_id | integer |
The ID of the configuration version in the history database. This is identical to the value of | 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 | 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.
Name | Type | Description | Indexed |
---|---|---|---|
history_id | integer |
The ID of the configuration version in the history database. This is identical to the value of | 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 | 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.
Name | Type | Description | Indexed |
---|---|---|---|
history_id | integer |
The ID of the configuration version in the history database. This is identical to the value of | 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 | No |
default_host_configuration_version | integer |
The host configuration version at the time of creation or update. This is identical to the value of | 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.
Name | Type | Description | Indexed |
---|---|---|---|
history_id | integer |
The ID of the configuration version in the history database. This is identical to the value of | 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 | 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.
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. | 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.
Name | Type | Description | Indexed |
---|---|---|---|
history_id | integer |
The ID of the configuration version in the history database. This is identical to the value of | 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.
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. |
| 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. |