Shirly Radco has uploaded a new change for review. Change subject: history: Added cumulative rx tx total to dwh views ......................................................................
history: Added cumulative rx tx total to dwh views Added cumulative rx tx total to dwh views. dwh_host_interface_history_view and dwh_vm_interface_history_view. Change-Id: If69bfbe453643d681e4b251ebe245315efd9aebd Bug-Url:https://bugzilla.redhat.com/1215587 Signed-off-by: Shirly Radco <[email protected]> --- M packaging/dbscripts/create_dwh_views.sql 1 file changed, 6 insertions(+), 2 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/01/41501/1 diff --git a/packaging/dbscripts/create_dwh_views.sql b/packaging/dbscripts/create_dwh_views.sql index 62251a1..8fe52c4 100644 --- a/packaging/dbscripts/create_dwh_views.sql +++ b/packaging/dbscripts/create_dwh_views.sql @@ -260,7 +260,9 @@ SELECT vds_interface_statistics.id AS host_interface_id, CAST ( vds_interface_statistics.rx_rate AS SMALLINT ) AS receive_rate_percent, - CAST ( vds_interface_statistics.tx_rate AS SMALLINT ) AS transmit_rate_percent + CAST ( vds_interface_statistics.tx_rate AS SMALLINT ) AS transmit_rate_percent, + vds_interface_statistics.rx_total AS receive_rate_total, + vds_interface_statistics.tx_total AS transmit_rate_total FROM vds_interface_statistics; CREATE @@ -379,7 +381,9 @@ SELECT vm_interface_statistics.id AS vm_interface_id, CAST ( vm_interface_statistics.rx_rate AS SMALLINT ) AS receive_rate_percent, - CAST ( vm_interface_statistics.tx_rate AS SMALLINT ) AS transmit_rate_percent + CAST ( vm_interface_statistics.tx_rate AS SMALLINT ) AS transmit_rate_percent, + vm_interface_statistics.rx_total AS receive_rate_total, + vm_interface_statistics.tx_total AS transmit_rate_total FROM vm_interface_statistics; CREATE -- To view, visit https://gerrit.ovirt.org/41501 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: If69bfbe453643d681e4b251ebe245315efd9aebd Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Shirly Radco <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
