chgeuer/fetch-RI-usage.md

Created April 8, 2019 15:35

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/chgeuer/9f0b471e4f2beebcd065cc9112f1be8b.js"></script>
Save chgeuer/9f0b471e4f2beebcd065cc9112f1be8b to your computer and use it in GitHub Desktop.

Raw

generate CSV

query="[?contains(instanceId,'providers/Microsoft.Compute/virtualMachines/') && (contains(product,'Virtual Machines') || contains(product,'VM RI - Compute'))].{start:usageStart,end:usageEnd,id:instanceId}"

echo -e "from\tto\tID" > usage.csv
for sub in $(az account list | jq -r ".[].id")
do
    az consumption usage list \
        --include-additional-properties \
        --include-meter-details \
        --subscription "{$sub}" \
        --query "${query}" \
        -o tsv >> usage.csv
done