Hi, @ITWhisperer The events are like below. {
"MetaData": {
"JENKINS_URL": "https://abc.com",
"stagename": "ABC_CT",
"variantname": "NEW_ABC",
"jobname": "abc",
"buildnumber": 29,
"filename": "1729005933566.json"
},
"suite": {
"hostname": "localhost",
"failures": 0,
"package": "ABC",
"tests": 0,
"name": "ABC_test",
"id": 0,
"time": 0,
"errors": 0,
"case": [
{
"classname": "xyz",
"name": "foo1",
"time": 0,
"status": "Passed"
},
{
"classname": "pqr",
"name": "foo2",
"time": 0,
"status": "Passed"
},
........
]
}
} there will be so many events like this for a single project and the values will be repeated in those events. Like suite, case will be repeated. index=... sourcetype=...
|spath ...
| stats
count(eval(Status="Execution Failed" OR Status="case_Failed"))
AS Failed_cases,
count(eval(Status="Passed")) AS Passed_cases,
count(eval(Status="Failed" OR Status="case_Error")) AS Execution_Failed_cases,
dc(case) as Total_cases
dc(suite) as "Total suite"
by Job_Name Build_Variant Jenkins_Server I use spath to get every parameter, then i use them in the query.
... View more