Thanks for sending this out! These can be really helpful.
On Wed, Aug 6, 2014 at 4:06 AM, Saksham Srivastava < saksham.srivast...@citrix.com> wrote: > I remember we used to follow the practice of informing others in case db > changes are committed, but we do not do it anymore. > In case you are on dev setup on master branch post the following commit : > commit b9d834e83854009483f6d061f9996e5ffaa9b883 > Author: Nitin Mehta <nitin.me...@citrix.com> > Date: Tue Aug 5 17:29:34 2014 -0700 > CLOUDSTACK-4200: listSystemVMs API and listRouters API should return > hypervisor property since dynamic scaling is not enabled for all the > hypervisors and that action can be showed only for the hypervisors t > > Update your database with : > > DROP VIEW IF EXISTS `cloud`.`domain_router_view`; > CREATE VIEW `cloud`.`domain_router_view` AS > select > vm_instance.id id, > vm_instance.name name, > account.id account_id, > account.uuid account_uuid, > account.account_name account_name, > account.type account_type, > domain.id domain_id, > domain.uuid domain_uuid, > domain.name domain_name, > domain.path domain_path, > projects.id project_id, > projects.uuid project_uuid, > projects.name project_name, > vm_instance.uuid uuid, > vm_instance.created created, > vm_instance.state state, > vm_instance.removed removed, > vm_instance.pod_id pod_id, > vm_instance.instance_name instance_name, > host_pod_ref.uuid pod_uuid, > data_center.id data_center_id, > data_center.uuid data_center_uuid, > data_center.name data_center_name, > data_center.networktype data_center_type, > data_center.dns1 dns1, > data_center.dns2 dns2, > data_center.ip6_dns1 ip6_dns1, > data_center.ip6_dns2 ip6_dns2, > host.id host_id, > host.uuid host_uuid, > host.name host_name, > host.hypervisor_type, > host.cluster_id cluster_id, > vm_template.id template_id, > vm_template.uuid template_uuid, > service_offering.id service_offering_id, > disk_offering.uuid service_offering_uuid, > disk_offering.name service_offering_name, > nics.id nic_id, > nics.uuid nic_uuid, > nics.network_id network_id, > nics.ip4_address ip_address, > nics.ip6_address ip6_address, > nics.ip6_gateway ip6_gateway, > nics.ip6_cidr ip6_cidr, > nics.default_nic is_default_nic, > nics.gateway gateway, > nics.netmask netmask, > nics.mac_address mac_address, > nics.broadcast_uri broadcast_uri, > nics.isolation_uri isolation_uri, > vpc.id vpc_id, > vpc.uuid vpc_uuid, > networks.uuid network_uuid, > networks.name network_name, > networks.network_domain network_domain, > networks.traffic_type traffic_type, > networks.guest_type guest_type, > async_job.id job_id, > async_job.uuid job_uuid, > async_job.job_status job_status, > async_job.account_id job_account_id, > domain_router.template_version template_version, > domain_router.scripts_version scripts_version, > domain_router.is_redundant_router is_redundant_router, > domain_router.redundant_state redundant_state, > domain_router.stop_pending stop_pending, > domain_router.role role > from > `cloud`.`domain_router` > inner join > `cloud`.`vm_instance` ON vm_instance.id = domain_router.id > inner join > `cloud`.`account` ON vm_instance.account_id = account.id > inner join > `cloud`.`domain` ON vm_instance.domain_id = domain.id > left join > `cloud`.`host_pod_ref` ON vm_instance.pod_id = host_pod_ref.id > left join > `cloud`.`projects` ON projects.project_account_id = account.id > left join > `cloud`.`data_center` ON vm_instance.data_center_id = > data_center.id > left join > `cloud`.`host` ON vm_instance.host_id = host.id > left join > `cloud`.`vm_template` ON vm_instance.vm_template_id = > vm_template.id > left join > `cloud`.`service_offering` ON vm_instance.service_offering_id = > service_offering.id > left join > `cloud`.`disk_offering` ON vm_instance.service_offering_id = > disk_offering.id > left join > `cloud`.`nics` ON vm_instance.id = nics.instance_id and > nics.removed is null > left join > `cloud`.`networks` ON nics.network_id = networks.id > left join > `cloud`.`vpc` ON domain_router.vpc_id = vpc.id and vpc.removed is > null > left join > `cloud`.`async_job` ON async_job.instance_id = vm_instance.id > and async_job.instance_type = 'DomainRouter' > and async_job.job_status = 0; > > > > Thanks, > Saksham > -- *Mike Tutkowski* *Senior CloudStack Developer, SolidFire Inc.* e: mike.tutkow...@solidfire.com o: 303.746.7302 Advancing the way the world uses the cloud <http://solidfire.com/solution/overview/?video=play>*™*