Shirly Radco has uploaded a new change for review. Change subject: reports: updated br45 report query ......................................................................
reports: updated br45 report query updated br45 report query according to the new users_details_history table. Change-Id: I9d41f744936e7056a13a580ad0139c2a32827abc Bug-Url: https://bugzilla.redhat.com/1112612 Signed-off-by: Shirly Radco <[email protected]> --- M packaging/ovirt-reports/resources/Reports/users_usage/users_spice_sessions_activity_br45_files/users_spice_sessions_activity_br45_jrxml.data 1 file changed, 7 insertions(+), 2 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-reports refs/changes/70/29370/1 diff --git a/packaging/ovirt-reports/resources/Reports/users_usage/users_spice_sessions_activity_br45_files/users_spice_sessions_activity_br45_jrxml.data b/packaging/ovirt-reports/resources/Reports/users_usage/users_spice_sessions_activity_br45_files/users_spice_sessions_activity_br45_jrxml.data index abac422..dcdee23 100644 --- a/packaging/ovirt-reports/resources/Reports/users_usage/users_spice_sessions_activity_br45_files/users_spice_sessions_activity_br45_jrxml.data +++ b/packaging/ovirt-reports/resources/Reports/users_usage/users_spice_sessions_activity_br45_files/users_spice_sessions_activity_br45_jrxml.data @@ -69,7 +69,7 @@ v3_5_configuration_history_clusters.cluster_name, v3_5_configuration_history_clusters.delete_date AS cluster_delete, history_datetime, - user_name, + username AS user_name, v3_5_statistics_vms_users_usage_$P!{table_name}.vm_id, v3_5_configuration_history_vms.vm_name, v3_5_configuration_history_vms.delete_date, @@ -98,6 +98,11 @@ FROM v3_5_configuration_history_clusters a GROUP BY a.cluster_id ) + ) + LEFT OUTER JOIN v3_5_users_details_history + ON ( + v3_5_statistics_vms_users_usage_hourly.user_id = + v3_5_users_details_history.user_id ) WHERE -- Here we filter by the datacenter chosen by the user @@ -153,7 +158,7 @@ ORDER BY v3_5_configuration_history_clusters.cluster_id, history_datetime, - user_name, + username, session_time_in_hours DESC]]> </queryString> <field name="cluster_id" class="java.lang.Object"/> -- To view, visit http://gerrit.ovirt.org/29370 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I9d41f744936e7056a13a580ad0139c2a32827abc Gerrit-PatchSet: 1 Gerrit-Project: ovirt-reports Gerrit-Branch: master Gerrit-Owner: Shirly Radco <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
