Yaniv Dary has uploaded a new change for review. Change subject: history: added boolean on guest logged in user ......................................................................
history: added boolean on guest logged in user Change-Id: Ifcf84fe6ce81b5772acc53a6f999f242dd68c2e3 Bug-Url: https://bugzilla.redhat.com/893810 Signed-off-by: Yaniv Dary <yd...@redhat.com> --- M packaging/dbscripts/create_dwh_views.sql 1 file changed, 4 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/35/17935/1 diff --git a/packaging/dbscripts/create_dwh_views.sql b/packaging/dbscripts/create_dwh_views.sql index 66073dc..0a44c12 100644 --- a/packaging/dbscripts/create_dwh_views.sql +++ b/packaging/dbscripts/create_dwh_views.sql @@ -271,6 +271,10 @@ b.vm_ip, b.client_ip as vm_client_ip, b.console_cur_user_name as current_user_name, + CASE + WHEN b.guest_cur_user_name IS NULL THEN FALSE + ELSE TRUE + END as user_logged_in_to_guest, b.run_on_vds as currently_running_on_host FROM vm_dynamic b, vm_statistics c where -- To view, visit http://gerrit.ovirt.org/17935 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ifcf84fe6ce81b5772acc53a6f999f242dd68c2e3 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
