BashScript for getting vm summary of OpenStack.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # | |
| # VMの利用状況を集計するスクリプトです。 | |
| # | |
| # - jq コマンド必須です | |
| # http://stedolan.github.io/jq/ | |
| # # How to install | |
| # wget -O /usr/bin/jq http://stedolan.github.io/jq/download/linux64/jq | |
| # chmod +x /usr/bin/jq | |
| # | |
| # - 指定したプロジェクト(TENANT_NAME)の総合的な利用状況を表示 | |
| # * 各機能のユニークユーザ数 | |
| # * VM数 / vCPU数 / メモリ容量 | |
| # * イメージとスナップショットの数と容量 | |
| # * ボリュームとスナップショットの数と容量 | |
| # | |
| # - イメージの利用状況ランキング | |
| # * インスタンスの元となったイメージから集計 | |
| # * そのため通常イメージとスナップショットが混合 | |
| # * イメージ名を OSName-Version-UpdateDate-Number として運用しており | |
| # 例）Debian-7.0.0-20130801-01 | |
| # 最初の OSName と Versionのメジャーバージョン部分のみ を切り取って | |
| # ランキングの名前としています | |
| # * スナップショットの場合は規則に従っていないため | |
| # 最初の単語とハイフン、そして次の単語までを切り取る形で使われます | |
| # | |
| # - ユーザID順で消費リソース情報を表示 | |
| # * VM数, vCPU, メモリ | |
| # * イメージスナップショット数, 容量 | |
| # * ボリューム数, 容量 | |
| # * ボリュームスナップショット数, 容量 | |
| # | |
| # - VMイメージの利用状況ランキングを表示 | |
| # * VM数 | |
| # * vCPU数 | |
| # * RAM容量 | |
| # * ボリューム容量 | |
| # | |
| # - 表示の注意事項 | |
| # * 分母の - はクォータによる限界設定がない項目です | |
| # * 分子の - は情報不足で集計できない項目です | |
| # | |
| # - GlanceイメージのAPI取得は、削除済みイメージとスナップショットを | |
| # 取得できないためMySQLから全レコードを直接取得しています | |
| # ※APIの status=DELETED はまさに削除している時が対象なので | |
| # 削除完了してしまうとリストには出てこない | |
| # | |
| # - Volume,VolumeSnapshotのAPIから、作成したuser_idが取得できないので | |
| # MySQLから別途取得しています | |
| # | |
| PATH=/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin | |
| ####################################### | |
| # | |
| # 設定 | |
| # | |
| TENANT_NAME=test | |
| GLANCE_API_CONF=/etc/glance/glance-api.conf | |
| CINDER_CONF=/etc/cinder/cinder.conf | |
| ####################################### | |
| # | |
| # 開始の出力 | |
| # | |
| echo "=======================================" | |
| echo " VM Summary Report" | |
| echo "=======================================" | |
| echo | |
| ####################################### | |
| # | |
| # 設定取得 | |
| # | |
| MYSQL_PATTERN='^.*mysql:\/\/\([^:]\+\):\([^@]\+\)@\([^:]\+\):\([^\/]\+\)\/\(.\+\)$' | |
| MYSQL_REPLACE='-h \3 -u \1 -P \4 -p\2 \5' | |
| MYSQL_ADD_OPTIONS=" --batch --skip-column-names" | |
| IMAGE_MYSQL_OPTIONS=`grep "^sql_connection.*mysql://" $GLANCE_API_CONF \ | |
| | sed -e "s/$MYSQL_PATTERN/$MYSQL_REPLACE/g"` | |
| IMAGE_MYSQL_OPTIONS+="$MYSQL_ADD_OPTIONS" | |
| VOLUME_MYSQL_OPTIONS=`grep "^sql_connection.*mysql://" $CINDER_CONF \ | |
| | sed -e "s/$MYSQL_PATTERN/$MYSQL_REPLACE/g"` | |
| VOLUME_MYSQL_OPTIONS+="$MYSQL_ADD_OPTIONS" | |
| ####################################### | |
| # | |
| # コマンド確認 | |
| # | |
| # | |
| # jq is json processor | |
| # | |
| type jq > /dev/null 2>&1 | |
| [ $? -ne 0 ] && echo "not found jq." && exit 1 | |
| ####################################### | |
| # | |
| # Keystone認証 | |
| # | |
| # | |
| # 環境変数読み込み | |
| # | |
| . ~/.bashrc | |
| export OS_TENANT_NAME=$TENANT_NAME | |
| # | |
| # 認証データ取得 | |
| # | |
| TOKENS=`eval " | |
| curl -s -d '{ | |
| \"auth\":{ | |
| \"passwordCredentials\":{ | |
| \"username\": \"$OS_USERNAME\", \"password\":\"$OS_PASSWORD\" | |
| }, | |
| \"tenantName\":\"$OS_TENANT_NAME\" | |
| } | |
| }' -H 'Content-type: application/json' ${OS_AUTH_URL}tokens | |
| "` | |
| # | |
| # トークンID, テナントID, API URL 取得 | |
| # | |
| TOKEN_ID=` echo "$TOKENS" | jq '.access.token.id' -r` | |
| PROJECT_ID=` echo "$TOKENS" | jq '.access.token.tenant.id' -r` | |
| PROJECT_NAME=`echo "$TOKENS" | jq '.access.token.tenant.name' -r` | |
| COMPUTE_URL=` echo "$TOKENS" \ | |
| | jq '.access.serviceCatalog[] | select(.type == "compute").endpoints[].adminURL' -r` | |
| IMAGE_URL=` echo "$TOKENS" \ | |
| | jq '.access.serviceCatalog[] | select(.type == "image").endpoints[].adminURL' -r` | |
| VOLUME_URL=` echo "$TOKENS" \ | |
| | jq '.access.serviceCatalog[] | select(.type == "volume").endpoints[].adminURL' -r` | |
| [ "$TOKEN_ID" = "null" ] && echo "can not get token id. check TENANT_NAME." && exit 1 | |
| ####################################### | |
| # | |
| # データ収集 | |
| # | |
| # デフォルトリミットが小さい場合があるので全件取得対応 | |
| LIMIT=10000 | |
| # | |
| # VMのリスト | |
| # | |
| SERVER_DETAIL=`curl -s $COMPUTE_URL/servers/detail?limit=$LIMIT -H "X-Auth-Token: $TOKEN_ID"` | |
| echo "$SERVER_DETAIL" | head -1 | grep "^{" > /dev/null 2>&1 | |
| [ $? -ne 0 ] && echo "can not get server list." && exit 1 | |
| # | |
| # Quotaのリスト | |
| # | |
| QUOTA_COMPUTE=`curl -s "$COMPUTE_URL/os-quota-sets/$PROJECT_ID" -H "X-Auth-Token: $TOKEN_ID"` | |
| echo "$QUOTA_COMPUTE" | head -1 | grep "^{" > /dev/null 2>&1 | |
| [ $? -ne 0 ] && echo "could not get compute quota list." && exit 1 | |
| QUOTA_VOLUME=`curl -s "$VOLUME_URL/os-quota-sets/$PROJECT_ID" -H "X-Auth-Token: $TOKEN_ID"` | |
| echo "$QUOTA_VOLUME" | head -1 | grep "^{" > /dev/null 2>&1 | |
| [ $? -ne 0 ] && echo "could not get nova quota list." && exit 1 | |
| # | |
| # flavorのリスト | |
| # | |
| FLAVOR_DETAIL=`curl -s "$COMPUTE_URL/flavors/detail?limit=$LIMIT" -H "X-Auth-Token: $TOKEN_ID"` | |
| echo "$FLAVOR_DETAIL" | head -1 | grep "^{" > /dev/null 2>&1 | |
| [ $? -ne 0 ] && echo "could not get flavor list." && exit 1 | |
| # | |
| # イメージ＆スナップショットのリスト | |
| # | |
| IMAGE_DETAIL=`curl -s "$IMAGE_URL/v2/images?limit=$LIMIT" -H "X-Auth-Token: $TOKEN_ID"` | |
| echo "$IMAGE_DETAIL" | head -1 | grep "^{" > /dev/null 2>&1 | |
| [ $? -ne 0 ] && echo "could not get image list." && exit 1 | |
| # | |
| # 過去に存在したものを含むイメージのリスト | |
| # - 既存インスタンスかつ削除済みイメージの名前取得のため | |
| # - MySQLから取得 | |
| # - 結果リストはあえてAPIのJSONと同じ形式にしておきます | |
| ALL_IMAGE_DATA=`mysql $IMAGE_MYSQL_OPTIONS -e "SELECT id, name FROM images"` | |
| ALL_IMAGE_JSON_LIST=`echo "$ALL_IMAGE_DATA" | awk -F"\t" '{ print "{\"id\":\"" $1 "\",\"name\":\"" $2 "\"}" }'` | |
| ALL_IMAGE_JSON="[]" | |
| for JSON in ${ALL_IMAGE_JSON_LIST[@]} | |
| do | |
| ALL_IMAGE_JSON=`echo "$ALL_IMAGE_JSON" | jq ". + [ $JSON ]"` | |
| done | |
| ALL_IMAGE_DETAIL="{ \"images\" : $ALL_IMAGE_JSON }" | |
| # | |
| # ボリュームのリスト | |
| # | |
| # - 現在はuser_idが取得できないので、MySQLから別に取得する | |
| VOLUME_DETAIL=`curl -s "$VOLUME_URL/volumes/detail" -H "X-Auth-Token: $TOKEN_ID"` | |
| echo "$VOLUME_DETAIL" | head -1 | grep "^{" > /dev/null 2>&1 | |
| [ $? -ne 0 ] && echo "could not get volume list." && exit 1 | |
| QUERY="SELECT id, user_id FROM volumes where status != 'deleted' and project_id = '$PROJECT_ID'" | |
| VOLUME_DATA=`mysql $VOLUME_MYSQL_OPTIONS -e "$QUERY"` | |
| VOLUME_JSON_LIST=`echo "$VOLUME_DATA" | \ | |
| awk -F"\t" '{ print "{\"id\":\"" $1 "\",\"user_id\":\"" $2 "\"}" }'` | |
| VOLUME_USERS_JSON="[]" | |
| for JSON in ${VOLUME_JSON_LIST[@]} | |
| do | |
| VOLUME_USERS_JSON=`echo "$VOLUME_USERS_JSON" | jq ". + [ $JSON ]"` | |
| done | |
| VOLUME_USERS="{ \"volumes\" : $VOLUME_USERS_JSON }" | |
| # | |
| # ボリュームスナップショットのリスト | |
| # | |
| # - 現在はuser_idが取得できないので、MySQLから別に取得する | |
| VOLUME_SNAPSHOT_DETAIL=`curl -s "$VOLUME_URL/snapshots/detail" -H "X-Auth-Token: $TOKEN_ID"` | |
| echo "$VOLUME_SNAPSHOT_DETAIL" | head -1 | grep "^{" > /dev/null 2>&1 | |
| [ $? -ne 0 ] && echo "could not get volume snapshot list." && exit 1 | |
| QUERY="SELECT id, user_id FROM snapshots where status != 'deleted' and project_id = '$PROJECT_ID'" | |
| VOLUME_SNAPSHOT_DATA=`mysql $VOLUME_MYSQL_OPTIONS -e "$QUERY"` | |
| VOLUME_SNAPSHOT_JSON_LIST=`echo "$VOLUME_SNAPSHOT_DATA" | \ | |
| awk -F"\t" '{ print "{\"id\":\"" $1 "\",\"user_id\":\"" $2 "\"}" }'` | |
| VOLUME_SNAPSHOT_USERS_JSON="[]" | |
| for JSON in ${VOLUME_SNAPSHOT_JSON_LIST[@]} | |
| do | |
| VOLUME_SNAPSHOT_USERS_JSON=`echo "$VOLUME_SNAPSHOT_USERS_JSON" | jq ". + [ $JSON ]"` | |
| done | |
| VOLUME_SNAPSHOT_USERS="{ \"snapshots\" : $VOLUME_SNAPSHOT_USERS_JSON }" | |
| ####################################### | |
| # | |
| # データ編集 | |
| # | |
| ######### | |
| # | |
| # JSON初期化 | |
| # | |
| # - （スナップショットではない）通常イメージはユーザIDが記録されていない | |
| # ので集計できない ... images, image_gb は現在は未使用だが書いておく | |
| SUMMARY_TOTAL='{ | |
| "vm_users" : 0, | |
| "image_users" : 0, "image_snapshot_users" : 0, | |
| "volume_users" : 0, "volume_snapshot_users" : 0, | |
| "vm" : 0, "vcpus" : 0, "ram" : 0, | |
| "images" : 0, "image_bytes" : 0, | |
| "image_snapshots" : 0, "image_snapshot_bytes" : 0, | |
| "volumes" : 0, "volume_gb" : 0, | |
| "volume_snapshots" : 0, "volume_snapshot_gb" : 0 | |
| }' | |
| SUMMARY_OS='{ "dummy" : { "name" : "", "count" : 0 } }' | |
| SUMMARY_USERS='{ "dummy" : | |
| { | |
| "user_id" : "", | |
| "vm" : 0, "vcpus" : 0, "ram" : 0, | |
| "images" : 0, "image_bytes" : 0, | |
| "image_snapshots" : 0, "image_snapshot_bytes" : 0, | |
| "volumes" : 0, "volume_gb" : 0, | |
| "volume_snapshots" : 0, "volume_snapshot_gb" : 0 | |
| } | |
| }' | |
| SUMMARY_USER_KEYS=`echo "$SUMMARY_USERS" | jq ".dummy | keys | .[]" -r` | |
| ######### | |
| # | |
| # VMリストの配列 | |
| # - 必要なカラムのみ抽出 | |
| SERVERS=(`echo "$SERVER_DETAIL" | \ | |
| jq '.servers[] | { user_id, image, flavor }' \ | |
| --compact-output`) | |
| # | |
| # VM情報を１つずつループ | |
| # | |
| for SERVER in "${SERVERS[@]}" | |
| do | |
| # | |
| # データ整理 | |
| # | |
| USER_ID=` echo "$SERVER" | jq .user_id -r` | |
| FLAVOR_ID=`echo "$SERVER" | jq .flavor.id` | |
| IMAGE_ID=` echo "$SERVER" | jq .image.id` | |
| FLAVOR=`echo "$FLAVOR_DETAIL" | jq ".flavors[] | select(.id == $FLAVOR_ID)"` | |
| vCPUs=` echo "$FLAVOR" | jq .vcpus` | |
| RAM=` echo "$FLAVOR" | jq .ram` | |
| IMAGE=`echo "$ALL_IMAGE_DETAIL" | jq ".images[] | select(.id == $IMAGE_ID)"` | |
| IMAGE_NAME=`echo "$IMAGE" | jq .name -r` | |
| OS_NAME=`echo "$IMAGE_NAME" | sed -e 's/^\([^-]\+\)-\([^-\.]\+\).*$/\1-\2/'` | |
| OS_KEY_NAME=`echo "$OS_NAME" | sed -e 's/-//g'` | |
| # | |
| # トータル情報集計 | |
| # | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".vm += 1"` | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".vcpus += $vCPUs"` | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".ram += $RAM"` | |
| HAS_USER=`echo "$SUMMARY_USERS" | jq "has(\"$USER_ID\")"` | |
| [ "$HAS_USER" = "false" ] && SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".vm_users += 1"` | |
| SUMMARY_OS=`echo "$SUMMARY_OS" | jq ".$OS_KEY_NAME.name = \"$OS_NAME\""` | |
| SUMMARY_OS=`echo "$SUMMARY_OS" | jq ".$OS_KEY_NAME.count += 1"` | |
| # | |
| # ユーザ別情報集計 | |
| # | |
| for KEY in ${SUMMARY_USER_KEYS[@]} | |
| do | |
| [ "$KEY" = "user_id" ] && continue | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.$KEY += 0"` | |
| done | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.user_id = \"$USER_ID\""` | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.vm += 1"` | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.vcpus += $vCPUs"` | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.ram += $RAM"` | |
| done | |
| ######### | |
| # | |
| # イメージ＆スナップショットリストの配列 | |
| # - 必要なカラムのみ抽出 | |
| IMAGES=(`echo "$IMAGE_DETAIL" | \ | |
| jq '.images[] | { id, size, user_id, image_type }' \ | |
| --compact-output`) | |
| # | |
| # イメージ＆スナップショット情報を１つずつループ | |
| # | |
| for IMAGE in "${IMAGES[@]}" | |
| do | |
| # | |
| # データ整理 | |
| # | |
| IMAGE_ID=` echo "$IMAGE" | jq .id` | |
| SIZE=` echo "$IMAGE" | jq .size` | |
| USER_ID=` echo "$IMAGE" | jq .user_id -r` | |
| IMAGE_TYPE=`echo "$IMAGE" | jq .image_type -r` | |
| # | |
| # スナップショット集計 | |
| # | |
| if [ "$IMAGE_TYPE" = "snapshot" ]; | |
| then | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".image_snapshots += 1"` | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".image_snapshot_bytes += $SIZE"` | |
| USER_IMAGE_SNAPSHOTS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.image_snapshots"` | |
| if [ "$USER_IMAGE_SNAPSHOTS" = 0 -o "$USER_IMAGE_SNAPSHOTS" = "null" ]; then | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".image_snapshot_users += 1"` | |
| fi | |
| # | |
| # ユーザ別情報集計 | |
| # | |
| for KEY in ${SUMMARY_USER_KEYS[@]} | |
| do | |
| [ "$KEY" = "user_id" ] && continue | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.$KEY += 0"` | |
| done | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.user_id = \"$USER_ID\""` | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.image_snapshots += 1"` | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.image_snapshot_bytes += $SIZE"` | |
| # | |
| # 通常イメージ集計 | |
| # | |
| else | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".images += 1"` | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".image_bytes += $SIZE"` | |
| fi | |
| done | |
| ######### | |
| # | |
| # ボリュームリストの配列 | |
| # - 必要なカラムのみ抽出 | |
| VOLUMES=(`echo "$VOLUME_DETAIL" | \ | |
| jq '.volumes[] | { id, size }' \ | |
| --compact-output`) | |
| # | |
| # ボリューム情報を１つずつループ | |
| # | |
| for VOLUME in "${VOLUMES[@]}" | |
| do | |
| # | |
| # データ整理 | |
| # | |
| VOLUME_ID=`echo "$VOLUME" | jq .id` | |
| SIZE=` echo "$VOLUME" | jq .size` | |
| USER_ID=` echo "$VOLUME_USERS" | \ | |
| jq ".volumes[] | select(.id == $VOLUME_ID) | .user_id" -r` | |
| # | |
| # トータル情報集計 | |
| # | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".volumes += 1"` | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".volume_gb += $SIZE"` | |
| USER_VOLUMES=`echo "$SUMMARY_USERS" | jq ".$USER_ID.volumes"` | |
| if [ "$USER_VOLUMES" = 0 -o "$USER_VOLUMES" = "null" ]; then | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".volume_users += 1"` | |
| fi | |
| # | |
| # ユーザ別情報集計 | |
| # | |
| for KEY in ${SUMMARY_USER_KEYS[@]} | |
| do | |
| [ "$KEY" = "user_id" ] && continue | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.$KEY += 0"` | |
| done | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.user_id = \"$USER_ID\""` | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.volumes += 1"` | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.volume_gb += $SIZE"` | |
| done | |
| ######### | |
| # | |
| # ボリュームスナップショットリストの配列 | |
| # - 必要なカラムのみ抽出 | |
| VOLUME_SNAPSHOTS=(`echo "$VOLUME_SNAPSHOT_DETAIL" | \ | |
| jq '.snapshots[] | { id, size }' \ | |
| --compact-output`) | |
| # | |
| # ボリュームスナップショット情報を１つずつループ | |
| # | |
| for VOLUME_SNAPSHOT in "${VOLUME_SNAPSHOTS[@]}" | |
| do | |
| # | |
| # データ整理 | |
| # | |
| VOLUME_SNAPSHOT_ID=`echo "$VOLUME_SNAPSHOT" | jq .id` | |
| SIZE=` echo "$VOLUME_SNAPSHOT" | jq .size` | |
| USER_ID=` echo "$VOLUME_SNAPSHOT_USERS" | \ | |
| jq ".snapshots[] | select(.id == $VOLUME_SNAPSHOT_ID) | .user_id" -r` | |
| # | |
| # トータル情報集計 | |
| # | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".volume_snapshots += 1"` | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".volume_snapshot_gb += $SIZE"` | |
| USER_VOLUME_SNAPSHOTS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.volume_snapshots"` | |
| if [ "$USER_VOLUME_SNAPSHOTS" = 0 -o "$USER_VOLUME_SNAPSHOTS" = "null" ]; then | |
| SUMMARY_TOTAL=`echo "$SUMMARY_TOTAL" | jq ".volume_snapshot_users += 1"` | |
| fi | |
| # | |
| # ユーザ別情報集計 | |
| # | |
| for KEY in ${SUMMARY_USER_KEYS[@]} | |
| do | |
| [ "$KEY" = "user_id" ] && continue | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.$KEY += 0"` | |
| done | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.user_id = \"$USER_ID\""` | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.volume_snapshots += 1"` | |
| SUMMARY_USERS=`echo "$SUMMARY_USERS" | jq ".$USER_ID.volume_snapshot_gb += $SIZE"` | |
| done | |
| ####################################### | |
| # | |
| # データ整理 | |
| # | |
| # | |
| # 色んなソートを用意 | |
| # - それぞれのソートで値が 0 のVMは表示から除外する | |
| SORT_OS=( `echo "$SUMMARY_OS" | jq "[.[]] | sort_by(.count) | .[]" --compact-output`) | |
| SORT_USER_ID_USERS=( `echo "$SUMMARY_USERS" | jq "[.[]] | sort_by(.user_id) | .[]" --compact-output`) | |
| SORT_VM_USERS=( `echo "$SUMMARY_USERS" | jq "[.[]] | sort_by(.vm) | .[] | select(.vm > 0)" --compact-output`) | |
| SORT_vCPUs_USERS=( `echo "$SUMMARY_USERS" | jq "[.[]] | sort_by(.vcpus) | .[] | select(.vcpus > 0)" --compact-output`) | |
| SORT_RAM_USERS=( `echo "$SUMMARY_USERS" | jq "[.[]] | sort_by(.ram) | .[] | select(.ram > 0)" --compact-output`) | |
| SORT_VOLUME_GB_USERS=(`echo "$SUMMARY_USERS" | jq "[.[]] | sort_by(.volume_gb) | .[] | select(.volumes > 0)" --compact-output`) | |
| # | |
| # トータル値 | |
| # | |
| TOTAL_VM=` echo "$SUMMARY_TOTAL" | jq ".vm"` | |
| TOTAL_vCPUs=` echo "$SUMMARY_TOTAL" | jq ".vcpus"` | |
| TOTAL_RAM=` echo "$SUMMARY_TOTAL" | jq ".ram"` | |
| TOTAL_IMAGES=` echo "$SUMMARY_TOTAL" | jq ".images"` | |
| TOTAL_IMAGE_BYTES=` echo "$SUMMARY_TOTAL" | jq ".image_bytes"` | |
| TOTAL_IMAGE_GB=$(($TOTAL_IMAGE_BYTES / 1024 / 1024 / 1024)) | |
| TOTAL_IMAGE_SNAPSHOTS=` echo "$SUMMARY_TOTAL" | jq ".image_snapshots"` | |
| TOTAL_IMAGE_SNAPSHOT_BYTES=` echo "$SUMMARY_TOTAL" | jq ".image_snapshot_bytes"` | |
| TOTAL_IMAGE_SNAPSHOT_GB=$(($TOTAL_IMAGE_SNAPSHOT_BYTES / 1024 / 1024 / 1024)) | |
| TOTAL_VOLUMES=` echo "$SUMMARY_TOTAL" | jq ".volumes"` | |
| TOTAL_VOLUME_GB=` echo "$SUMMARY_TOTAL" | jq ".volume_gb"` | |
| TOTAL_VOLUME_SNAPSHOTS=` echo "$SUMMARY_TOTAL" | jq ".volume_snapshots"` | |
| TOTAL_VOLUME_SNAPSHOT_GB=` echo "$SUMMARY_TOTAL" | jq ".volume_snapshot_gb"` | |
| # ユニークユーザ数 | |
| TOTAL_VM_USERS=` echo "$SUMMARY_TOTAL" | jq ".vm_users"` | |
| TOTAL_IMAGE_SNAPSHOT_USERS=` echo "$SUMMARY_TOTAL" | jq ".image_snapshot_users"` | |
| TOTAL_VOLUME_USERS=` echo "$SUMMARY_TOTAL" | jq ".volume_users"` | |
| TOTAL_VOLUME_SNAPSHOT_USERS=`echo "$SUMMARY_TOTAL" | jq ".volume_snapshot_users"` | |
| # クォータ | |
| QUOTA_INSTANCES=`echo "$QUOTA_COMPUTE" | jq ".quota_set.instances"` | |
| QUOTA_CORES=` echo "$QUOTA_COMPUTE" | jq ".quota_set.cores"` | |
| QUOTA_RAM=` echo "$QUOTA_COMPUTE" | jq ".quota_set.ram"` | |
| QUOTA_VOLUMES=` echo "$QUOTA_VOLUME" | jq ".quota_set.volumes"` | |
| QUOTA_VOLUME_GB=`echo "$QUOTA_VOLUME" | jq ".quota_set.gigabytes"` | |
| QUOTA_SNAPSHOTS=`echo "$QUOTA_VOLUME" | jq ".quota_set.snapshots"` | |
| ####################################### | |
| # | |
| # データ出力 | |
| # | |
| # | |
| # プロジェクト情報 | |
| # | |
| cat <<EOT | |
| ==================== | |
| Project Info | |
| -------------------- | |
| Project Name : $PROJECT_NAME | |
| Project ID : $PROJECT_ID | |
| EOT | |
| # | |
| # トータル情報 | |
| # | |
| cat <<EOT | |
| ==================== | |
| TOTAL | |
| -------------------- | |
| VM Users : $TOTAL_VM_USERS | |
| Image Users : - | |
| Image SS Users : $TOTAL_IMAGE_SNAPSHOT_USERS | |
| Volume Users : $TOTAL_VOLUME_USERS | |
| Volume SS Users : $TOTAL_VOLUME_SNAPSHOT_USERS | |
| VM : $TOTAL_VM / $QUOTA_INSTANCES | |
| vCPUs : $TOTAL_vCPUs / $QUOTA_CORES | |
| RAM : $TOTAL_RAM / $QUOTA_RAM (MB) | |
| Images (All) : $TOTAL_IMAGES / - | |
| ImageGB (All) : $TOTAL_IMAGE_GB / - (GB) | |
| Snapshots : $TOTAL_IMAGE_SNAPSHOTS / - | |
| SnapshotGB : $TOTAL_IMAGE_SNAPSHOT_GB / - (GB) | |
| Volumes : $TOTAL_VOLUMES / $QUOTA_VOLUMES | |
| VolumeGB : $TOTAL_VOLUME_GB / $QUOTA_VOLUME_GB (GB) | |
| Snapshots : $TOTAL_VOLUME_SNAPSHOTS / $QUOTA_SNAPSHOTS | |
| SnapshotGB : $TOTAL_VOLUME_SNAPSHOT_GB / - (GB) | |
| EOT | |
| # | |
| # OS数 | |
| # | |
| cat <<EOT | |
| ==================== | |
| OS Image | |
| -------------------- | |
| EOT | |
| for JSON in "${SORT_OS[@]}" | |
| do | |
| OS_NAME=` echo "$JSON" | jq ".name" -r` | |
| OS_COUNT=`echo "$JSON" | jq ".count"` | |
| [ -z "$OS_NAME" ] && continue | |
| SPACE_NUM=$((24 - ${#OS_NAME})) | |
| SPACES=`eval "printf ' %.0s' {1..$SPACE_NUM}"` | |
| echo "$OS_NAME$SPACES: $OS_COUNT" | |
| done | |
| echo | |
| # | |
| # ユーザIDソート | |
| # - 全データ表示 | |
| cat <<EOT | |
| ==================== | |
| User's All Data | |
| -------------------- | |
| EOT | |
| for JSON in "${SORT_USER_ID_USERS[@]}" | |
| do | |
| USER_ID=` echo "$JSON" | jq ".user_id" -r` | |
| VM_COUNT=` echo "$JSON" | jq ".vm"` | |
| vCPUs=` echo "$JSON" | jq ".vcpus"` | |
| RAM=` echo "$JSON" | jq ".ram"` | |
| IMAGE_SNAPSHOTS=` echo "$JSON" | jq ".image_snapshots"` | |
| IMAGE_SNAPSHOT_BYTES=`echo "$JSON" | jq ".image_snapshot_bytes"` | |
| IMAGE_SNAPSHOT_GB=$(($IMAGE_SNAPSHOT_BYTES / 1024 / 1024 / 1024)) | |
| VOLUMES=` echo "$JSON" | jq ".volumes"` | |
| VOLUME_GB=` echo "$JSON" | jq ".volume_gb"` | |
| VOLUME_SNAPSHOTS=` echo "$JSON" | jq ".volume_snapshots"` | |
| VOLUME_SNAPSHOT_GB=` echo "$JSON" | jq ".volume_snapshot_gb"` | |
| [ -z "$USER_ID" ] && continue | |
| SPACE_NUM=$((24 - ${#USER_ID})) | |
| SPACES=`eval "printf ' %.0s' {1..$SPACE_NUM}"` | |
| echo -n "$USER_ID$SPACES: VM=$VM_COUNT, vCPUs=$vCPUs, RAM=$RAM, " | |
| echo -n "ImageSnapshots=$IMAGE_SNAPSHOTS, ImageSnapshotGB=$IMAGE_SNAPSHOT_GB, " | |
| echo -n "Volumes=$VOLUMES, VolumeGB=$VOLUME_GB, " | |
| echo "VolumeSnapshots=$VOLUME_SNAPSHOTS, VolumeSnapshotGB=$VOLUME_SNAPSHOT_GB" | |
| done | |
| echo | |
| # | |
| # ユーザ別VM数ソート | |
| # | |
| cat <<EOT | |
| ==================== | |
| User's VM Rank | |
| -------------------- | |
| EOT | |
| for JSON in "${SORT_VM_USERS[@]}" | |
| do | |
| USER_ID=` echo "$JSON" | jq ".user_id" -r` | |
| VM_COUNT=` echo "$JSON" | jq ".vm"` | |
| vCPUs=` echo "$JSON" | jq ".vcpus"` | |
| RAM=` echo "$JSON" | jq ".ram"` | |
| [ -z "$USER_ID" ] && continue | |
| SPACE_NUM=$((24 - ${#USER_ID})) | |
| SPACES=`eval "printf ' %.0s' {1..$SPACE_NUM}"` | |
| echo "$USER_ID$SPACES: VM=$VM_COUNT, vCPUs=$vCPUs, RAM=$RAM" | |
| done | |
| echo | |
| # | |
| # ユーザ別vCPU数ソート | |
| # | |
| cat <<EOT | |
| ==================== | |
| User's vCPUs Rank | |
| -------------------- | |
| EOT | |
| for JSON in "${SORT_vCPUs_USERS[@]}" | |
| do | |
| USER_ID=` echo "$JSON" | jq ".user_id" -r` | |
| VM_COUNT=` echo "$JSON" | jq ".vm"` | |
| vCPUs=` echo "$JSON" | jq ".vcpus"` | |
| [ -z "$USER_ID" ] && continue | |
| SPACE_NUM=$((24 - ${#USER_ID})) | |
| SPACES=`eval "printf ' %.0s' {1..$SPACE_NUM}"` | |
| echo "$USER_ID$SPACES: vCPUs=$vCPUs, VM=$VM_COUNT" | |
| done | |
| echo | |
| # | |
| # ユーザ別メモリ数ソート | |
| # | |
| cat <<EOT | |
| ==================== | |
| User's RAM Rank | |
| -------------------- | |
| EOT | |
| for JSON in "${SORT_RAM_USERS[@]}" | |
| do | |
| USER_ID=` echo "$JSON" | jq ".user_id" -r` | |
| VM_COUNT=` echo "$JSON" | jq ".vm"` | |
| vCPUs=` echo "$JSON" | jq ".vcpus"` | |
| RAM=` echo "$JSON" | jq ".ram"` | |
| [ -z "$USER_ID" ] && continue | |
| SPACE_NUM=$((24 - ${#USER_ID})) | |
| SPACES=`eval "printf ' %.0s' {1..$SPACE_NUM}"` | |
| echo "$USER_ID$SPACES: RAM=$RAM, VM=$VM_COUNT, vCPUs=$vCPUs" | |
| done | |
| echo | |
| # | |
| # ユーザ別ボリューム容量ソート | |
| # | |
| cat <<EOT | |
| ==================== | |
| User's Volume Rank | |
| -------------------- | |
| EOT | |
| for JSON in "${SORT_VOLUME_GB_USERS[@]}" | |
| do | |
| USER_ID=` echo "$JSON" | jq ".user_id" -r` | |
| VM_COUNT=` echo "$JSON" | jq ".vm"` | |
| VOLUMES=` echo "$JSON" | jq ".volumes"` | |
| VOLUME_GB=`echo "$JSON" | jq ".volume_gb"` | |
| [ -z "$USER_ID" ] && continue | |
| SPACE_NUM=$((24 - ${#USER_ID})) | |
| SPACES=`eval "printf ' %.0s' {1..$SPACE_NUM}"` | |
| echo "$USER_ID$SPACES: VolumeGB=$VOLUME_GB, Volumes=$VOLUMES, VM=$VM_COUNT" | |
| done | |
| echo |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment