selected the date from 1 jan 2024 to 2 jan 2024 ---------------------------------------------------------------- index="bsds_gans" earliest=1704096000 latest=+1d pfor IN (*) test IN (*) name IN (*)...
See more...
selected the date from 1 jan 2024 to 2 jan 2024 ---------------------------------------------------------------- index="bsds_gans" earliest=1704096000 latest=+1d pfor IN (*) test IN (*) name IN (*) ckb IN (*) vrsion IN (*) id IN (*) location IN (*) group IN (*) | eval pfor=upper(pfor) | eval _time = start_time | eval WW=strftime(_time, "%V.%w") | eval name=mvindex(split(context,"."),1) | search name !="*Case Setup*" | eval name=mvindex(split(name,".PSPV"),0) | eval id=mvindex(split(name," - "),0) | search id IN (*) | eval main=mvindex(split(name," - "),1) | search main IN (*) | stats count(eval(sta="FIL")) as fail_count, count(eval(sta="PASS")) as pass_count, count(eval(like(sta,"LOCKED%"))) as not_run_count by name,id -------------------------------------------------------------------- selected date is from 1jan 2024 to 13 jan 2024 index="bsds_gans" earliest=1704096000 latest=+1d pfor IN (*) test IN (*) name IN (*) ckb IN (*) vrsion IN (*) id IN (*) location IN (*) group IN (*) | eval pfor=upper(pfor) | eval _time = start_time | eval WW=strftime(_time, "%V.%w") | eval name=mvindex(split(context,"."),1) | search name !="*Case Setup*" | eval name=mvindex(split(name,".PSPV"),0) | eval id=mvindex(split(name," - "),0) | search id IN (*) | eval main=mvindex(split(name," - "),1) | search main IN (*) | stats count(eval(sta="FIL")) as fail_count, count(eval(sta="PASS")) as pass_count, count(eval(like(sta,"LOCKED%"))) as not_run_count by name,id ----------------------------------------------------------------------- selected for last 7 days index="bsds_gans" earliest=-7d@h latest=+1d pfor IN (*) test IN (*) name IN (*) ckb IN (*) version IN (*) id IN (*) location IN (*) group IN (*) | eval pfor=upper(pfor) | eval _time = start_time | eval WW=strftime(_time, "%V.%w") | eval name=mvindex(split(context,"."),1) | search name !="*Case Setup*" | eval name=mvindex(split(name,".PSPV"),0) | eval id=mvindex(split(name," - "),0) | search id IN (*) | eval main=mvindex(split(name," - "),1) | search main IN (*) | stats count(eval(sta="FIL")) as fail_count, count(eval(sta="PASS")) as pass_count, count(eval(like(sta,"LOCKED%"))) as not_run_count by name,id