print number of instances running per project

show_instances_per_project.sh

#!/bin/bash
TOTAL_INSTANCES=0
TMPFILE=`mktemp`
nova list --fields tenant_id --all-tenants  | tail -n +4 | head -n -2 | cut -d'|' -f3 | tr -d ' ' | sort | uniq -c | sort -n | while read -r LINE; do
    TENANT_ID=$(echo $LINE | awk -F' ' '{print $2}')
    TENANT_NAME=$(openstack project show -c name -f value $TENANT_ID)
    NUM_INSTANCES=$(echo $LINE | awk -F' ' '{print $1}')

    echo "$NUM_INSTANCES	$TENANT_NAME"
    TOTAL_INSTANCES=$(($TOTAL_INSTANCES+$NUM_INSTANCES))
    echo $TOTAL_INSTANCES > $TMPFILE
done

echo "Total: $(cat $TMPFILE)"
rm $TMPFILE