Shirly Radco has uploaded a new change for review. Change subject: history: added dwh_users_history_view ......................................................................
history: added dwh_users_history_view Added dwh_users_history_view and added console_user_id to dwh_vm_history_view. Change-Id: I1995308951b445bbaa5ab6d944d51f64368c44fc Signed-off-by: Shirly Radco <[email protected]> --- M packaging/dbscripts/create_dwh_views.sql 1 file changed, 16 insertions(+), 2 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/39/27339/1 diff --git a/packaging/dbscripts/create_dwh_views.sql b/packaging/dbscripts/create_dwh_views.sql index de43633..977e070 100644 --- a/packaging/dbscripts/create_dwh_views.sql +++ b/packaging/dbscripts/create_dwh_views.sql @@ -275,6 +275,7 @@ b.vm_ip, b.vm_fqdn, b.client_ip as vm_client_ip, + b.console_user_id as current_user_id, b.console_cur_user_name as current_user_name, CASE WHEN b.guest_cur_user_name IS NULL THEN FALSE @@ -512,5 +513,18 @@ (_update_date >(SELECT var_datetime as var_datetime FROM dwh_history_timekeeping AS history_timekeeping_1 WHERE (var_name = 'lastSync'))); - - + +CREATE OR REPLACE VIEW dwh_users_history_view +AS +SELECT + user_id, + name AS first_name, + surname AS last_name, + domain, + username, + department, + role AS user_role_title, + email, + external_id, + active AS +FROM users; -- To view, visit http://gerrit.ovirt.org/27339 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I1995308951b445bbaa5ab6d944d51f64368c44fc 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
