Yaniv Dary has uploaded a new change for review. Change subject: history: added vm creator user name and id to collection ......................................................................
history: added vm creator user name and id to collection Change-Id: Ie14fe5cb6aca11085f67302877b127739313b272 Bug-Url: https://bugzilla.redhat.com/896139 Signed-off-by: Yaniv Dary <yd...@redhat.com> --- M packaging/dbscripts/create_dwh_views.sql 1 file changed, 3 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/65/23065/1 diff --git a/packaging/dbscripts/create_dwh_views.sql b/packaging/dbscripts/create_dwh_views.sql index f9fe886..9be256b 100644 --- a/packaging/dbscripts/create_dwh_views.sql +++ b/packaging/dbscripts/create_dwh_views.sql @@ -239,12 +239,15 @@ a.time_zone, c.vm_pool_id, d.vm_pool_name, + a.created_by_user_id, + e.username as created_by_user_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 LEFT OUTER JOIN vm_pool_map as c ON a.vm_guid = c. vm_guid LEFT OUTER JOIN vm_pools as d ON c.vm_pool_id = d.vm_pool_id + LEFT OUTER JOIN users as e ON a.created_by_user_id = e.user_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/23065 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ie14fe5cb6aca11085f67302877b127739313b272 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
