Alerts generator

The tool generate_alerts_file.py takes as input an alerts file with Prometheus alerts and generates another one with description filled.

The usage is the following:

# Usage
python3 generate_alerts_file.py -f inputfile.yaml 

Files extractor

The tool extract_files_in_configurations.py takes as input a dashboards or exporter-config file and extracts the content of the 'data' fields of the 'configurations' elements into different files under the ./include/ subdirectory.

The usage is the following:

# Output in console
python3 extract_files_in_configurations.py -f inputfile.yaml 

# Output to a file
python3 extract_files_in_configurations.py -f inputfile.yaml -o outputfile.yaml

Script toolbox

Extract names of panels in Grafana dashboards:

grep "\"title\": " file_name.json | sed 's/\"title\": \"'// | sed 's/\",//' | sed -e 's/^ *//g' |  code -

Extract names, format and expressions from grafana dashboards:

grep "\"title\": \|\"expr\": \|\"format\": \|\"legendFormat\": " file_name.json | sed 's/\"expr\"/\n\"expr\"/' | sed 's/\": \"/\": /' | sed 's/\",//' | sed -e 's/^ *//g' |  code -

Extract names of panels in Sysdig dashboards:

grep "\"name\": " filename.json | sed 's/\"name\": \"'// | sed 's/\",//' | sed -e 's/^ *//g' | code -

Change a string in all files of a directory:

find . -type f -exec sed -i -e 's/STRINGA/STRINGB/g' {} \;

Change a string in files starting with extension ".yaml" of a directory:

find . -name \*.yaml -type f -exec sed -i -e 's/STRINGA/STRINGB/g' {} \;

Get all the names of the metrics containing "nginx" from a Prometheus server:

curl http://localhost:9090/api/v1/label/__name__/values | jq '.' | grep "nginx" | sed -e "s/\"//" | sed -e "s/\",//" | sed -e 's/^ *//g' | code -

Extract HELP lines of exporter

curl -s http://localhost:9121/metrics | grep "HELP redis" | sed 's/# HELP //' | code -

Extract all lines of metrics from a exporter:

curl -s http://host:1234/metrics | grep -v "# HELP\|# TYPE" | grep 'prexix_of_the_metric_'

Execute a python script in all the alert files:

find . -name \*alerts*.yaml -type f -exec python3 tools/script.py -f '{}' -o '{}'_sysdig.yaml \;

Regex to get the metrics name

^[^# ].*\n

# TYPE .*\n

(# HELP )([\w]*)( .*)
$2
^[^mysql].*\n

Extract the dashboards in json format with promcat connect

python3 ~/sysdig/promcat-connect/src/main.py backup dashboards:consul --local_repository ~/sysdig/dashboards -t API_KEY --name "Consul" --local -u https://app-staging.sysdigcloud.com