AWS: Get Costs by Customer (based on Tags) for the last month

get_costs_from_asw_by_customer.sh

#!/bin/bash

customer=$1

if [ -z "$customer" ]; then
    echo "Error: No customer name provided. Please provide a customer name as the first argument." >&2
    exit 1
fi

# Set your AWS credentials here
AWS_ACCESS_KEY_ID="xxxxxxxxxxx"
AWS_SECRET_ACCESS_KEY="xxxxxxxxxxxxxxxxxxx"
AWS_DEFAULT_REGION="us-east-1"  # Set this to any region, e.g. us-east-1

# Set the date for the last month
current_date=$(date +%Y-%m-%d)
start_date=$(date -d "$(date +%Y-%m-01) -1 month" +%Y-%m-%d)
end_date=$(date -d "$(date +%Y-%m-01)" +%Y-%m-%d)
echo "Query period: $start_date to $end_date"

# Docker command to run the AWS CLI command
docker run --rm -e AWS_ACCESS_KEY_ID=$AWS_ACCESS_KEY_ID \
                -e AWS_SECRET_ACCESS_KEY=$AWS_SECRET_ACCESS_KEY \
                -e AWS_DEFAULT_REGION=$AWS_DEFAULT_REGION \
                amazon/aws-cli ce get-cost-and-usage \
                --time-period Start=$start_date,End=$end_date \
                --granularity MONTHLY \
                --metrics "BlendedCost" "UsageQuantity" \
                --group-by Type=DIMENSION,Key=REGION \
                --filter "{\"Tags\": {\"Key\": \"customer\", \"Values\": [\"$customer\"]}}" \
                --output json > output.json

# Extract the amount with 'jq'
amount=$(cat output.json | jq -r '.ResultsByTime[0].Groups[0].Metrics.BlendedCost.Amount')

echo "Amount in USD: $amount"