Shirly Radco has uploaded a new change for review. Change subject: reports:Fixed bug in br18-chart vms with known OS vs. unknown ......................................................................
reports:Fixed bug in br18-chart vms with known OS vs. unknown Fixed bug in br18, ovirt 3.3, where chart vms with known OS vs. unknown OS. All OS were defined as Known. Change-Id: Icce38b6deff21b3b2684d283f8c46bc098eb5f79 Signed-off-by: Shirly Radco <sra...@redhat.com> Related-To: https://bugzilla.redhat.com/1059268 --- M reports/repository_files/resources/Reports/Executive/active_vms_by_os_br18_files/active_vms_by_os_br18_jrxml.data 1 file changed, 1 insertion(+), 1 deletion(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-reports refs/changes/54/25454/1 diff --git a/reports/repository_files/resources/Reports/Executive/active_vms_by_os_br18_files/active_vms_by_os_br18_jrxml.data b/reports/repository_files/resources/Reports/Executive/active_vms_by_os_br18_files/active_vms_by_os_br18_jrxml.data index 3c24ff4..d56940b 100644 --- a/reports/repository_files/resources/Reports/Executive/active_vms_by_os_br18_files/active_vms_by_os_br18_jrxml.data +++ b/reports/repository_files/resources/Reports/Executive/active_vms_by_os_br18_files/active_vms_by_os_br18_jrxml.data @@ -142,7 +142,7 @@ -- VMs Count by OS (Windows vs Windows) SELECT DISTINCT $P!{calendar_column} as the_date, coalesce(os_type, max(os_type) over (partition by 1),'') as os_type, vm_count FROM (SELECT distinct CASE - WHEN UPPER(coalesce(enum_os_type.value,'Other OS')) = 'OTHER OS' THEN 'Unknown OS' + WHEN COALESCE( enum_os_type.enum_key, 0 ) IN ( 0 ) THEN 'Unknown OS' ELSE 'Known OS' END AS os_type, history_datetime AS time, -- To view, visit http://gerrit.ovirt.org/25454 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Icce38b6deff21b3b2684d283f8c46bc098eb5f79 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-reports Gerrit-Branch: ovirt-3.3 Gerrit-Owner: Shirly Radco <sra...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
