Yaniv Dary has uploaded a new change for review. Change subject: history: fixed vm configuration dwh view ......................................................................
history: fixed vm configuration dwh view Change-Id: Ia55a029aa776639b69a911a4ee826be77c8f0e89 Bug-Url: https://bugzilla.redhat.com/987517 Signed-off-by: Yaniv Dary <[email protected]> --- M packaging/dbscripts/create_dwh_views.sql 1 file changed, 1 insertion(+), 1 deletion(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/77/17277/1 diff --git a/packaging/dbscripts/create_dwh_views.sql b/packaging/dbscripts/create_dwh_views.sql index 9fb2072..64146f1 100644 --- a/packaging/dbscripts/create_dwh_views.sql +++ b/packaging/dbscripts/create_dwh_views.sql @@ -243,7 +243,7 @@ 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 + LEFT OUTER 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/17277 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ia55a029aa776639b69a911a4ee826be77c8f0e89 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
