index="jenkins_console" source="*-deploy/*" NOT (source="*/gremlin-fault-injection-deploy/*" OR source="*pipe-test*" OR source="*java-validation-*") ("Approved by" OR "*Finished:*")
| fields source
| stats count(eval(match(_raw, "Approved by"))) as count_approved,
count(eval(match(_raw, ".*Finished:*."))) as count_finish by source
| where count_approved > 0 AND count_finish > 0
| stats dc(source) as Total
| appendcols
[ search(index="jenkins_console" source="*-deploy/*" NOT (source="*/gremlin-fault-injection-deploy/*" OR source="*pipe-test*" OR source="*java-validation-*") ("Finished: UNSTABLE" OR "Finished: SUCCESS" OR "Approved by" OR "Automatic merge*" OR "pushed branch tip is behind its remote" OR "WARNING: E2E tests did not pass"))
| fields source host
| stats count(eval(match(_raw, "Approved by"))) as count_approved,
count(eval(match(_raw, "Finished: SUCCESS"))) as count_success,
count(eval(match(_raw, "Finished: UNSTABLE"))) as count_unstable,
count(eval(match(_raw, "Automatic merge.*failed*."))) as count_merge_fail,
count(eval(match(_raw, "WARNING: E2E tests did not pass"))) as count_e2e_failure,
count(eval(match(_raw, "pushed branch tip"))) as count_branch_fail by source, host
| where count_approved > 0 AND (count_success > 0 OR (count_unstable > 0 AND (count_merge_fail > 0 OR count_branch_fail > 0 OR count_e2e_failure > 0)))
| stats dc(source) as success
]
| stats avg(success) as S, avg(Total) as T | eval percentage=( S / T * 100)
| fields percentage,success, Total
