extract_alerts_csv.sh

#!/bin/bash

# Check if yq is installed
if ! command -v yq &> /dev/null; then
    echo "yq is not installed. Please install it first."
    exit 1
fi

# Initialize the CSV header
echo "alert,team,severity,filename"

# Find all the matching files and process them
find . -type f -iname "telemetry*.yaml" | while read -r file; do
    # Check if the file has any alerts
    has_alerts=$(yq e '.charts[] | select(.values.prometheusrule.spec.groups[].rules[].alert != null) | true' "$file" 2>/dev/null)

    # Only process the file if it has alerts
    if [ "$has_alerts" = "true" ]; then
        num_groups=$(yq e '.charts[].values.prometheusrule.spec.groups | length' "$file")
        for ((i = 0; i < num_groups; i++)); do
            num_rules=$(yq e '.charts[].values.prometheusrule.spec.groups['$i'].rules | length' "$file")
            for ((j = 0; j < num_rules; j++)); do
                rule=$(yq e '.charts[].values.prometheusrule.spec.groups['$i'].rules['$j']' "$file")
                if [ "$(echo "$rule" | yq e '.alert' -)" != "null" ]; then
                    alert=$(echo "$rule" | yq e '.alert' -)
                    team=$(echo "$rule" | yq e '.labels.team' -)
                    severity=$(echo "$rule" | yq e '.labels.severity' -)
                    echo "\"$alert\",\"$team\",\"$severity\",\"$file\""
                fi
            done
        done
    fi
done