Roy Golan has submitted this change and it was merged. Change subject: core: VM pinning to multiple hosts (dwh fix) ...................................................................... core: VM pinning to multiple hosts (dwh fix) The initial feature breaks the DWH database view. Failing DWH install. Fix dwh_vm_configuration_history_view in create_dwh_views.sql To populate single pinned host uuid into default_host field. This is a temporary fix, till DWH team will be able to attend this feature. The DWH will reflect only one pinned host. Not nessearily the current or last run. In simple case when there is only single pinned host or none, it will be correct. Thanks to szacks(a)redhat.com who helped with 'SELECT DISTINCT ON' databae feature. Change-Id: I5ffa7eb9b214f288c96993cc553e4511b5bc1944 Bug-Url: https://bugzilla.redhat.com/1107512 Signed-off-by: Dudi Maroshi <dudi(a)redhat.com&gt; --- M packaging/dbscripts/create_dwh_views.sql 1 file changed, 4 insertions(+), 1 deletion(-) Approvals: Dudi Maroshi: Verified Eli Mesika: Looks good to me, but someone else must approve Jenkins CI: Passed CI tests Roy Golan: Looks good to me, approved -- To view, visit https://gerrit.ovirt.org/43864 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I5ffa7eb9b214f288c96993cc553e4511b5bc1944 Gerrit-PatchSet: 4 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Dudi Maroshi <dudi(a)redhat.com&gt; Gerrit-Reviewer: Dudi Maroshi <dudi(a)redhat.com&gt; Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com&gt; Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Roy Golan <rgolan(a)redhat.com&gt; Gerrit-Reviewer: Sim Zacks <szacks(a)redhat.com&gt; Gerrit-Reviewer: automation(a)ovirt.org