Product SiteDocumentation Site

Chapter 9. Reporting database views

9.1. Statistics History Views
9.1.1. v3_0_datacenter_samples_history_view\v3_0_datacenter_hourly_history_view\v3_0_datacenter_daily_history_view
9.1.2. v3_0_storage_domain_samples_history_view-v3_0_storage_domain_hourly_history_view\v3_0_storage_domain_daily_history_view
9.1.3. v3_0_host_samples_history_view\v3_0_host_hourly_history_view\v3_0_host_daily_history_view
9.1.4. v3_0_host_interface_samples_history_view\v3_0_host_interface_hourly_history_view\v3_0_host_interface_daily_history_view
9.1.5. v3_0_vm_samples_history_view\v3_0_vm_hourly_history_view\v3_0_vm_daily_history_view
9.1.6. v3_0_vm_interface_samples_history_view\v3_0_vm_interface_hourly_history_view\v3_0_vm_interface_daily_history_view
9.1.7. v3_0_vm_disk_daily_history_view\v3_0_vm_disk_hourly_history_view\v3_0_vm_disk_samples_history_view
9.2. Configuration History Views
9.2.1. v3_0_datacenter_configuration_view\v3_0_latest_datacenter_configuration_view
9.2.2. v3_0_datacenter_storage_domain_map_view\v3_0_latest_datacenter_configuration_view
9.2.3. v3_0_storage_domain_configuration_view\v3_0_latest_storage_domain_configuration_view
9.2.4. v3_0_cluster_configuration_view\v3_0_latest_cluster_configuration_view
9.2.5. v3_0_host_configuration_view\v3_0_latest_host_configuration_view
9.2.6. v3_0_host_configuration_view\v3_0_latest_host_interface_configuration_view
9.2.7. v3_0_vm_configuration_view\v3_0_latest_vm_configuration_view
9.2.8. v3_0_vm_configuration_view\latest_vm_interface_configuration_view
9.2.9. v3_0_disks_vm_map_view\v3_0_latest_disks_vm_map_view
9.2.10. v3_0_vm_disk_configuration_view\v3_0_latest_vm_disk_configuration_view
Red Hat Enterprise Virtualization Manager collects historical data and statistics for use in constructing reports. This chapter details the reporting views available in the system, and their columns and data types. Creating reports is explained in the Red Hat Enterprise Virtualization Administration Guide.

9.1. Statistics History Views

This section describes the statistics history views available to the user for querying and generating reports.

9.1.1. v3_0_datacenter_samples_history_view\v3_0_datacenter_hourly_history_view\v3_0_datacenter_daily_history_view

Historical statistics for each data center in the system.
Table 9.1. v3_0_datacenter_samples_history_view\v3_0_datacenter_hourly_history_view\v3_0_datacenter_daily_history_view
Name Type Description
history_id integer The unique ID of this row in the table.
history_datetime timestamp with time zone The timestamp of this history row (rounded to minute, hour, day as per the aggregation level).
datacenter_id uuid The unique ID of the data center.
datacenter_status smallint
  • -1 - Unknown Status (used only to indicate a problem with the ETL -- PLEASE NOTIFY SUPPORT)
  • 1 - Up
  • 2 - Maintenance
  • 3 - Problematic
minutes_in_status decimal The total number of minutes that the data center was in the status shown in the datacenter_status column for the aggregation period. For example, if a data center was up for 55 minutes and in maintenance mode for 5 minutes during an hour, two rows will show for this hour. One will have a datacenter_status of Up and minutes_in_status of 55, the other will have a datacenter_status of Maintenance and a minutes_in_status of 5.
datacenter_configuration_version integer The data center configuration version at the time of sample.

9.1.2. v3_0_storage_domain_samples_history_view-v3_0_storage_domain_hourly_history_view\v3_0_storage_domain_daily_history_view

Historical statistics for each storage domain in the system.
Table 9.2. v3_0_storage_domain_samples_history_view\v3_0_storage_domain_hourly_history_view-v3_0_storage_domain_daily_history_view
Name Type Description
history_id integer The unique ID of this row in the table.
history_datetime timestamp with time zone The timestamp of this history row (rounded to minute, hour, day as per the aggregation level).
storage_domain_id uuid Unique ID of the storage domain in the system.
available_disk_size_gb integer The total available (unused) capacity on the disk, expressed in gigabytes (GB).
used_disk_size_gb integer The total used capacity on the disk, expressed in gigabytes (GB).
storage_configuration_version integer The storage domain configuration version at the time of sample.

9.1.3. v3_0_host_samples_history_view\v3_0_host_hourly_history_view\v3_0_host_daily_history_view

Historical statistics for each host in the system.
Table 9.3. v3_0_host_samples_history_view\v3_0_host_hourly_history_view\v3_0_host_daily_history_view
Name Type Description
history_id integer The unique ID of this row in the table.
history_datetime timestamp with time zone The timestamp of this history row (rounded to minute, hour, day as per the aggregation level).
host_id uuid Unique ID of the host in the system.
host_status smallint
  • -1 - Unknown Status (used only to indicate a problem with the ETL -- PLEASE NOTIFY SUPPORT)
  • 1 - Up
  • 2 - Maintenance
  • 3 - Problematic
minutes_in_status decimal The total number of minutes that the host was in the status shown in the status column for the aggregation period. For example, if a host was up for 55 minutes and down for 5 minutes during an hour, two rows will show for this hour. One will have a status of Up and minutes_in_status of 55, the other will have a status of down and a minutes_in_status of 5.
memory_usage_percent smallint Percentage of used memory on the host.
max_memory_usage smallint Percentage of used memory on the host.
cpu_usage_percent smallint Used CPU percentage on the host.
max_cpu_usage smallint The maximum CPU usage for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
ksm_cpu_percent smallint CPU percentage ksm on the host is using.
max_ksm_cpu_percent smallint The maximum KSM usage for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
active_vms smallint The average number of active virtual machines for this aggregation.
max_active_vms smallint The maximum active number of virtual machines for the aggregation period. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
total_vms smallint The average number of all virtual machines on the host for this aggregation.
max_total_vms smallint The maximum total number of virtual machines for the aggregation period. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
total_vms_vcpus smallint Total number of VCPUs allocated to the host.
max_total_vms_vcpus smallint The maximum total virtual machine VCPU number for the aggregation period. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
cpu_load smallint The CPU load of the host.
max_cpu_load smallint The maximum CPU load for the aggregation period. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
system_cpu_usage_percent smallint Used CPU percentage on the host.
max_cpu_usage_percent smallint The maximum system CPU usage for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
user_cpu_usage_percent smallint Used user CPU percentage on the host.
max_user_cpu_usage_percent smallint The maximum user CPU usage for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
swap_used_mb integer Used swap size usage of the host in megabytes (MB).
max_swap_used_mb integer The maximum user swap size usage of the host for the aggregation period in megabytes (MB), expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
host_configuration_version integer The host configuration version at the time of sample.

9.1.4. v3_0_host_interface_samples_history_view\v3_0_host_interface_hourly_history_view\v3_0_host_interface_daily_history_view

Historical statistics for each host network interface in the system.
Table 9.4. v3_0_host_interface_samples_history_view\v3_0_host_interface_hourly_history_view\v3_0_host_interface_daily_history_view
Name Type Description
history_id integer The unique ID of this row in the table.
history_datetime timestamp with time zone The timestamp of this history view (rounded to minute, hour, day as per the aggregation level).
host_interface_id uuid Unique identifier of the interface in the system.
receive_rate_percent smallint Used receive rate percentage on the host.
max_receive_rate_percent smallint The maximum receive rate for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
transmit_rate_percent smallint Used transmit rate percentage on the host.
max_transmit_rate_percent smallint The maximum transmit rate for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
host_interface_configuration_version integer The host interface configuration version at the time of sample.

9.1.5. v3_0_vm_samples_history_view\v3_0_vm_hourly_history_view\v3_0_vm_daily_history_view

Historical statistics for the virtual machines in the system.
Table 9.5. v3_0_vm_samples_history_view\v3_0_vm_hourly_history_view\v3_0_vm_daily_history_view
Name Type Description
history_id integer The unique ID of this row in the table.
history_datetime timestamp with time zone The timestamp of this history row (rounded to minute, hour, day as per the aggregation level).
vm_id uuid Unique ID of the virtual machine in the system.
vm_status smallint
  • -1 - Unknown Status (used only to indicate problems with the ETL -- PLEASE NOTIFY SUPPORT)
  • 0 - Down
  • 1 - Up
  • 2 - Paused
  • 3 - Problematic
minutes_in_status decimal The total number of minutes that the virtual machine was in the status shown in the status column for the aggregation period. For example, if a virtual machine was up for 55 minutes and down for 5 minutes during an hour, two rows will show for this hour. One will have a status of Up and minutes_in_status, the other will have a status of Down and a minutes_in_status of 5.
cpu_usage_percent smallint The percentage of the CPU in use by the virtual machine.
max_cpu_usage smallint The maximum CPU usage for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
memory_usage_percent smallint Percentage of used memory in the virtual machine. The guest tools must be installed on the virtual machine for memory usage to be recorded.
max_memory_usage smallint The maximum memory usage for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value. The guest tools must be installed on the virtual machine for memory usage to be recorded.
user_cpu_usage_percent smallint Used user CPU percentage on the host.
max_user_cpu_usage_percent smallint The maximum user CPU usage for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregation, it is the maximum hourly average value.
system_cpu_usage_percent smallint Used system CPU percentage on the host.
max_system_cpu_usage_percent smallint The maximum system CPU usage for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
vm_ip varchar(255) The IP address of the first NIC. Only shown if the guest agent is installed.
current_user_name varchar(255) Name of user logged into the virtual machine console, if a guest agent is installed.
currently_running_on_host uuid The unique ID of the host the virtual machine is running on.
vm_configuration_version integer The virtual machine configuration version at the time of sample.
current_host_configuration_version integer The current host the virtual machine is running on.

9.1.6. v3_0_vm_interface_samples_history_view\v3_0_vm_interface_hourly_history_view\v3_0_vm_interface_daily_history_view

Historical statistics for the virtual machine network interfaces in the system.
Table 9.6. v3_0_vm_interface_samples_history_view\v3_0_vm_interface_hourly_history_view\v3_0_vm_interface_daily_history_view
Name Type Description
history_id integer The unique ID of this row in the table.
history_datetime timestamp with time zone The timestamp of this history row (rounded to minute, hour, day as per the aggregation level).
vm_interface_id uuid Unique identifier of the interface in the system.
receive_rate_percent smallint Used receive rate percentage on the host.
max_receive_rate_percent smallint The maximum receive rate for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
transmit_rate_percent smallint Used transmit rate percentage on the host.
max_transmit_rate_percent smallint The maximum transmit rate for the aggregation period, expressed as a percentage. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average rate.
vm_interface_configuration_version integer The virtual machine interface configuration version at the time of sample.

9.1.7. v3_0_vm_disk_daily_history_view\v3_0_vm_disk_hourly_history_view\v3_0_vm_disk_samples_history_view

Historical statistics for the virtual disks in the system.
Table 9.7. v3_0_vm_disk_daily_history_view\v3_0_vm_disk_hourly_history_view\v3_0_vm_disk_samples_history_view
Name Type Description
history_id integer The unique ID of this row in the table.
history_datetime timestamp with time zone The timestamp of this history row (rounded to minute, hour, day as per the aggregation level).
vm_disk_id uuid Unique ID of the disk in the system.
vm_disk_status integer
  • 0 - Unassigned
  • 1 - OK
  • 2 - Locked
  • 3 - Invalid
  • 4 - Illegal
minutes_in_status decimal The total number of minutes that the virtual machine disk was in the status shown in the status column for the aggregation period. For example, if a virtual machine disk was locked for 55 minutes and OK for 5 minutes during an hour, two rows will show for this hour. One will have a status of Locked and minutes_in_status of 55, the other will have a status of OK and a minutes_in_status of 5.
vm_actual_disk_size_mb integer The actual size allocated to the disk.
read_rate_bytes_per_second integer Read rate to disk in bytes per second.
max_read_rate_bytes_per_second integer The maximum read rate for the aggregation period. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
write_rate_bytes_per_second integer Write rate to disk in bytes per second.
max_write_rate_bytes_per_second integer The maximum write rate for the aggregation period. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
read_latency_seconds decimal The virtual machine disk read latency measured in seconds.
max_read_latency_seconds decimal The maximum write latency for the aggregation period, measured in seconds. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
write_latency_seconds decimal The virtual machine disk write latency measured in seconds.
max_write_latency_seconds decimal The maximum write latency for the aggregation period, measured in seconds. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
flush_latency_seconds decimal The virtual machine disk flush latency measured in seconds.
max_flush_latency_seconds decimal The maximum flush latency for the aggregation period, measured in seconds. For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value.
vm_disk_configuration_version integer The virtual machine disk configuration version at the time of sample.