Yaniv Dary has uploaded a new change for review. Change subject: history: added storage domain status to dwh views (#846272) ......................................................................
history: added storage domain status to dwh views (#846272) Bug-Url: https://bugzilla.redhat.com/846272 Change-Id: I4e729c99bb16ad0e6e16e392719a0670c771166b Signed-off-by: Yaniv Dary <[email protected]> --- M backend/manager/dbscripts/create_dwh_views.sql 1 file changed, 4 insertions(+), 3 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/11/10511/1 diff --git a/backend/manager/dbscripts/create_dwh_views.sql b/backend/manager/dbscripts/create_dwh_views.sql index 8ee9f35..d63e73c 100644 --- a/backend/manager/dbscripts/create_dwh_views.sql +++ b/backend/manager/dbscripts/create_dwh_views.sql @@ -53,9 +53,10 @@ CREATE OR REPLACE VIEW dwh_datacenter_storage_map_history_view AS -SELECT storage_pool_id AS datacenter_id, - storage_id AS storage_domain_id -FROM storage_pool_iso_map; +SELECT storage_pool_id AS datacenter_id, + storage_id AS storage_domain_id, + status as storage_domain_status +FROM storage_pool_iso_map; CREATE OR REPLACE VIEW dwh_storage_domain_history_view AS -- To view, visit http://gerrit.ovirt.org/10511 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I4e729c99bb16ad0e6e16e392719a0670c771166b Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
