Douglas Schilling Landgraf has submitted this change and it was merged. ( https://gerrit.ovirt.org/81138 ) Change subject: inventory: Improve SQL query for vms pinned ...................................................................... inventory: Improve SQL query for vms pinned The column dedicated_vm_for_vd from vm_static can contain a single hypervisor entry or multiple hypervisors (using delimiter comma). Based on that, we are extacting the hypervisors in the WITH statement and using it in the INNER JOIN. Change-Id: Ic6c00c794962687e886f0ab3aef11557965da21b Signed-off-by: Douglas Schilling Landgraf <dougsland(a)redhat.com&gt; --- M src/inventory_report/produceReport/sqls/vms_query_pinned_virtual_machines.sql 1 file changed, 20 insertions(+), 3 deletions(-) Approvals: Douglas Schilling Landgraf: Verified; Looks good to me, approved Jenkins CI: Passed CI tests -- To view, visit https://gerrit.ovirt.org/81138 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: Ic6c00c794962687e886f0ab3aef11557965da21b Gerrit-PatchSet: 1 Gerrit-Project: ovirt-log-collector Gerrit-Branch: master Gerrit-Owner: Douglas Schilling Landgraf <dougsland(a)redhat.com&gt; Gerrit-Reviewer: Dan Kenigsberg <danken(a)redhat.com&gt; Gerrit-Reviewer: Douglas Schilling Landgraf <dougsland(a)redhat.com&gt; Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Martin Mucha <mmucha(a)redhat.com&gt; Gerrit-Reviewer: Sandro Bonazzola <sbonazzo(a)redhat.com&gt; Gerrit-Reviewer: gerrit-hooks <automation(a)ovirt.org&gt;