Openstack查看基于某个镜像创建的虚拟机规格中VCPU数量大于4的虚拟机名称:
mysql -u root -p --default-character-set=utf8
use dbxxx;
select cv.vm_name from cloud_vm cv left join cloud_image ci on cv.from_imageid = ci.image_id left join cloud_flavor cf on cf.flavor_id = cv.flavor_id and cf.dc_id = cv.dc_id where ci.image_name = 'Windows Sever 2008 R2 标准版' and cf.flavor_vcpus>=4 and cv.is_deleted <>'1' and cv.is_visable = '1';