Yaniv Dary has uploaded a new change for review. Change subject: history: added pool id and name to dwh vm configuration view ......................................................................
history: added pool id and name to dwh vm configuration view Change-Id: I4c95d0e8947b563767fd9b500ac7cbfcf70e1ec3 Bug-Url: https://bugzilla.redhat.com/883120 Signed-off-by: Yaniv Dary <yd...@redhat.com> --- 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/64/16564/1 diff --git a/packaging/dbscripts/create_dwh_views.sql b/packaging/dbscripts/create_dwh_views.sql index 67c397f..9fb2072 100644 --- a/packaging/dbscripts/create_dwh_views.sql +++ b/packaging/dbscripts/create_dwh_views.sql @@ -236,10 +236,14 @@ a.fail_back, cast(a.usb_policy as smallint) as usb_policy, a.time_zone, + c.vm_pool_id, + d.vm_pool_name, a._create_date AS create_date, a._update_date AS update_date -FROM vm_static as a INNER JOIN - vm_static as b ON a.vmt_guid = b.vm_guid +FROM vm_static as a + INNER JOIN vm_static as b ON a.vmt_guid = b.vm_guid + LEFT OUTER JOIN vm_pool_map as c ON a.vm_guid = c. vm_guid + INNER JOIN vm_pools as d ON c.vm_pool_id = d.vm_pool_id WHERE (a.entity_type = 'VM' AND b.entity_type = 'TEMPLATE') AND ((a._create_date > (SELECT var_datetime -- To view, visit http://gerrit.ovirt.org/16564 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I4c95d0e8947b563767fd9b500ac7cbfcf70e1ec3 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <yd...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
