select t1.name resource_pool_name, t2.name unit_config_name, t2.max_cpu, t2.min_cpu, t2.memory_size/1024/1024/1024 max_mem_gb, t3.unit_id, t3.zone, concat(t3.svr_ip,':',t3.svr_port
) observer,t4.tenant_id, t4.tenant_name
  from __all_resource_pool t1 join __all_unit_config t2 on (t1.unit_config_id=t2.unit_config_id)
    join __all_unit t3 on (t1.
resource_pool_id = t3.resource_pool_id
) left join __all_tenant t4 on (t1.tenant_id=t4.tenant_id)
   order by t1.resource_pool_id, t2.unit_config_id, t3.unit_id;