salt states trends jq yq

salt-trends.sh

# install:
# wget https://gist.githubusercontent.com/epcim/e488af8be69b616eab3088a14a937e14/raw/salt-trends.sh -O salt-trends.sh; chmod +x *.sh

# salt state execution results: (use with/without test=true, -b2, etc..)
# apt install -y jq colordiff
salt \* state.apply --out=json --static test=true -b15 |  jq -r 'to_entries | map({ key:.key, value: { total: [.value[]]|length ,   
 succeed: [select(.value>={})|.value[]|select(.result? == true )]|length,                                                          
 failed: [select(.value>={})|.value[]|select(.result? == false)]|length,                                                           
 null:   [select(.value>={})|.value[]|select(.result? == null)]|length,                                                            
 changes: [select(.value>={})|.value[]|select(.changes?|length > 0)]|length } }) | from_entries ' |\                               
 tee trend_$(date "+%Y-%m-%d-%s").json                                                                                             

  tee trend_$(date "+%Y-%m-%d-%s")_${1}.json
  ls trend*.json| sort |tail -n2 |xargs -n2 diff -y | colordiff

To display failing state use:

jq -r 'to_entries|map(select(.value.failed >0))|from_entries' trend_2018-08-01-1533128841.json