1349421 – memory metric not being rolled up to OSP Availability zones

Bug 1349421 - memory metric not being rolled up to OSP Availability zones

Summary: memory metric not being rolled up to OSP Availability zones

Keywords:
Status:	CLOSED ERRATA
Alias:	None
Product:	Red Hat CloudForms Management Engine
Classification:	Red Hat
Component:	Providers
Sub Component:
Version:	5.6.0
Hardware:	Unspecified
OS:	Unspecified
Priority:	high
Severity:	high
Target Milestone:	GA
Target Release:	5.6.1
Assignee:	Scott Seago
QA Contact:	Ola Pavlenko
Docs Contact:
URL:
Whiteboard:	openstack:c&u
Depends On:	1345832
Blocks:
TreeView+	depends on / blocked

Reported:	2016-06-23 12:39 UTC by John Prause
Modified:	2022-07-09 07:45 UTC (History)
CC List:	7 users (show)
Fixed In Version:	5.6.1.2
Doc Type:	If docs needed, set a value
Doc Text:
Clone Of:	1345832
Environment:
Last Closed:	2016-08-18 17:49:50 UTC
Category:	---
Cloudforms Team:	---
Target Upstream Version:
Embargoed:

Attachments	(Terms of Use)

Links
System	ID	Private	Priority	Status	Summary	Last Updated
Red Hat Product Errata	RHSA-2016:1634	0	normal	SHIPPED_LIVE	Important: CFME 5.6.1 security, bug fix, and enhancement update	2016-08-18 21:43:52 UTC

Comment 4 Ronnie Rasouli 2016-08-15 14:31:38 UTC

Run on RHOS9 with 5.6.1.2

ActiveRecord::Base.connection.execute("select * from metric_rollups where resource_type = 'AvailabilityZone'").each{|it| p it}

{"id"=>123000000000409, "timestamp"=>"2016-08-14 12:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.93083563128285, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:21.1769", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>2, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>2, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000411, "timestamp"=>"2016-08-14 14:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.94319823377834, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:21.264016", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000413, "timestamp"=>"2016-08-14 16:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.9311845119885, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:21.326746", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000415, "timestamp"=>"2016-08-14 18:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.93090751995136, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:21.386263", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000410, "timestamp"=>"2016-08-14 13:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.93570145035263, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:21.217687", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000412, "timestamp"=>"2016-08-14 15:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.93353163197007, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:21.281559", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000414, "timestamp"=>"2016-08-14 17:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.93379608291409, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.000509175439218797, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:21.34279", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000417, "timestamp"=>"2016-08-14 19:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.93402731919084, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:21.485916", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000419, "timestamp"=>"2016-08-14 22:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.93519740612765, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:21.659933", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000422, "timestamp"=>"2016-08-15 01:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.9433805825685, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:21.799312", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000424, "timestamp"=>"2016-08-15 03:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.93670465361227, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:22.07872", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000426, "timestamp"=>"2016-08-15 04:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.92936006142422, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:22.211342", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000428, "timestamp"=>"2016-08-15 07:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.93378877741235, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:22.377284", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000010\n  - 123000000000011\n  - 123000000000012\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000459, "timestamp"=>"2016-08-15 08:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>0.0, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 09:00:16.3508", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000008\n  - 123000000000009\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000508, "timestamp"=>"2016-08-15 11:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>3.21444577828719, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 12:00:17.962141", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>1, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>1, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000425, "timestamp"=>"2016-08-15 05:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>2.93601417009092, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0124358244334048, "net_usage_rate_average"=>0.000517757495553209, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 08:55:22.144252", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000010\n  - 123000000000011\n  - 123000000000012\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000482, "timestamp"=>"2016-08-15 09:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>3.0889386685434, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0756663252586321, "net_usage_rate_average"=>0.000145513042170812, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 10:00:12.360567", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>3, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000010\n  - 123000000000011\n  - 123000000000012\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>3, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000495, "timestamp"=>"2016-08-15 10:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>3.21866741142758, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 11:00:12.892196", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>1, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>1, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000521, "timestamp"=>"2016-08-15 12:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>1.87644535451253, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 13:00:08.488258", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>1, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>1, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
{"id"=>123000000000534, "timestamp"=>"2016-08-15 13:00:00", "capture_interval"=>nil, "resource_type"=>"AvailabilityZone", "resource_id"=>123000000000002, "cpu_usage_rate_average"=>3.28138100374331, "cpu_usagemhz_rate_average"=>nil, "mem_usage_absolute_average"=>nil, "disk_usage_rate_average"=>0.0, "net_usage_rate_average"=>0.0, "sys_uptime_absolute_latest"=>nil, "created_on"=>"2016-08-15 14:00:15.384133", "derived_cpu_available"=>nil, "derived_memory_available"=>nil, "derived_memory_used"=>0.0, "derived_cpu_reserved"=>nil, "derived_memory_reserved"=>nil, "derived_vm_count_on"=>1, "derived_host_count_on"=>0, "derived_vm_count_off"=>0, "derived_host_count_off"=>0, "derived_storage_total"=>nil, "derived_storage_free"=>nil, "capture_interval_name"=>"hourly", "assoc_ids"=>"---\n:vms:\n  :on:\n  - 123000000000010\n  :off: []\n", "cpu_ready_delta_summation"=>nil, "cpu_system_delta_summation"=>nil, "cpu_wait_delta_summation"=>nil, "resource_name"=>"nova", "cpu_used_delta_summation"=>nil, "tag_names"=>"", "parent_host_id"=>nil, "parent_ems_cluster_id"=>nil, "parent_storage_id"=>nil, "parent_ems_id"=>123000000000003, "derived_storage_vm_count_registered"=>nil, "derived_storage_vm_count_unregistered"=>nil, "derived_storage_vm_count_unmanaged"=>nil, "derived_storage_used_registered"=>nil, "derived_storage_used_unregistered"=>nil, "derived_storage_used_unmanaged"=>nil, "derived_storage_snapshot_registered"=>nil, "derived_storage_snapshot_unregistered"=>nil, "derived_storage_snapshot_unmanaged"=>nil, "derived_storage_mem_registered"=>nil, "derived_storage_mem_unregistered"=>nil, "derived_storage_mem_unmanaged"=>nil, "derived_storage_disk_registered"=>nil, "derived_storage_disk_unregistered"=>nil, "derived_storage_disk_unmanaged"=>nil, "derived_storage_vm_count_managed"=>nil, "derived_storage_used_managed"=>nil, "derived_storage_snapshot_managed"=>nil, "derived_storage_mem_managed"=>nil, "derived_storage_disk_managed"=>nil, "min_max"=>nil, "intervals_in_rollup"=>nil, "mem_vmmemctl_absolute_average"=>nil, "mem_vmmemctltarget_absolute_average"=>nil, "mem_swapin_absolute_average"=>nil, "mem_swapout_absolute_average"=>nil, "mem_swapped_absolute_average"=>nil, "mem_swaptarget_absolute_average"=>nil, "disk_devicelatency_absolute_average"=>nil, "disk_kernellatency_absolute_average"=>nil, "disk_queuelatency_absolute_average"=>nil, "derived_vm_used_disk_storage"=>nil, "derived_vm_allocated_disk_storage"=>nil, "derived_vm_numvcpus"=>nil, "time_profile_id"=>nil, "derived_host_sockets"=>nil, "derived_host_count_total"=>0, "derived_vm_count_total"=>1, "stat_container_group_create_rate"=>nil, "stat_container_group_delete_rate"=>nil, "stat_container_image_registration_rate"=>nil}
=> #<PG::Result:0x00000001593750 status=PGRES_TUPLES_OK ntuples=38 nfields=76 cmd_tuples=38>
irb(main):008:0>

Comment 6 errata-xmlrpc 2016-08-18 17:49:50 UTC

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHSA-2016-1634.html

Note You need to log in before you can comment on or make changes to this bug.