IFS=$(echo -en "\n\b") PROJECTS_JSON=$(openstack project list --long -f json) for PROJECT_JSON in $(echo "${PROJECTS_JSON}" | jq -c '.[]'); do PROJECT_ID=$(echo ${PROJECT_JSON} | jq -r .ID) PROJECT_NAME=$(echo ${PROJECT_JSON} | jq -r .Name) DOMAIN_ID=$(echo ${PROJECT_JSON} | jq -r '."Domain ID"') DOMAIN_JSON=$(openstack domain show ${DOMAIN_ID} -f json) DOMAIN_NAME=$(echo ${DOMAIN_JSON} | jq -r .name) openstack server list --all-projects --long --project ${PROJECT_ID} --sort-column Name -f json | jq .[] | \ jq --arg project_name ${PROJECT_NAME} --arg domain_name ${DOMAIN_NAME} '. + {"Project": $project_name, "Domain": $domain_name}' done | jq --slurp .