Liron Ar has uploaded a new change for review. Change subject: core: GetActiveVmsByStorageDomainId - consider disk snapshots ......................................................................
core: GetActiveVmsByStorageDomainId - consider disk snapshots GetActiveVmsByStorageDomainId should also returns vms that has plugged disk snapshots on the domain. Change-Id: I910d61ae2cf33782eac2ca53d92deb03a29f8531 Signed-off-by: Liron Aravot <[email protected]> --- M packaging/dbscripts/vms_sp.sql 1 file changed, 1 insertion(+), 1 deletion(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/20/24720/1 diff --git a/packaging/dbscripts/vms_sp.sql b/packaging/dbscripts/vms_sp.sql index 2257595..84648cc 100644 --- a/packaging/dbscripts/vms_sp.sql +++ b/packaging/dbscripts/vms_sp.sql @@ -1010,7 +1010,7 @@ RETURN QUERY SELECT DISTINCT vms.* FROM vms INNER JOIN vm_device vd ON vd.vm_id = vms.vm_guid - INNER JOIN images i ON i.image_group_id = vd.device_id AND i.active = TRUE + INNER JOIN images i ON i.image_group_id = vd.device_id inner join image_storage_domain_map on i.image_guid = image_storage_domain_map.image_id WHERE status <> 0 AND is_plugged = TRUE AND -- To view, visit http://gerrit.ovirt.org/24720 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I910d61ae2cf33782eac2ca53d92deb03a29f8531 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Liron Ar <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
