D.2.5. Virtual machine hourly and daily history views

Historical statistics for the virtual machines in the system.

Table D.15. 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.