admin
不忘初心,方得始终
级别: 管理员
只看楼主 | | | 0楼 发表于:2017-09-20 11:30

Openstack查看基于某个镜像创建的虚拟机规格中VCPU数量大于4的虚拟机名称

  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';