Hi @avi123 Its getting late here so might not be optimal, but I think this should work! | makeresults
| eval json_data="{\"BCD_AB_UY_01\":1,\"BCD_AB_UY_02\":0,\"BCD_BC_01\":1,\"BCD_BC_02\":0,\"BC...
See more...
Hi @avi123 Its getting late here so might not be optimal, but I think this should work! | makeresults
| eval json_data="{\"BCD_AB_UY_01\":1,\"BCD_AB_UY_02\":0,\"BCD_BC_01\":1,\"BCD_BC_02\":0,\"BCD_CD_01\":1,\"BCD_CD_02\":1,\"BCD_CD_03\":0,\"BCD_KPI_01\":1,\"BCD_KPI_02\":1,\"BCD_KPI_03\":0,\"BCD_MY_01\":1,\"BCD_MY_02\":1,\"BCD_RMO_PZ_01\":1,\"BCD_RMO_PZ_02\":1,\"BCD_RMO_PZ_03\":0,\"BCD_RMO_PZ_04\":0,\"BCD_RSTA_01\":1,\"BCD_RSTA_02\":1,\"BCD_RSTA_03\":0,\"BCD_SHY_01\":1,\"BCD_SHY_02\":1,\"BCD_UK_01\":1,\"BCD_UK_02\":1,\"BCD_UK_03\":1,\"BCD_UK_04\":1,\"BCD_UK_05\":1,\"BCD_UK_06\":1,\"BCD_UK_07\":1,\"BCD_UK_08\":0,\"BCD_UK_09\":0,\"BCD_UK_10\":0,\"BCD_UK_11\":0,\"BCD_UK_12\":0}"
| eval _raw=json_extract(json_data,"")
| eval host="Testing", service="MySerivceName"
| spath
| foreach *
[| eval fields=mvappend(fields, IF(<<FIELD>> >= 0, json_object("<<FIELD>>",<<FIELD>>),null()))]
| table _time host service fields
| mvexpand fields
| eval fieldObj=json_array_to_mv((json_entries(fields)))
| eval fieldName=json_extract(fieldObj, "key")
| eval value=json_extract(fieldObj, "value")
| eval friendlyTime=strftime(_time,"%d/%m/%Y %H:%M:%S")
| search value=0
| eval metricLabel="URGENT !! Labware - ".service." has been stopped in Server"
| eval metricValue="Hello Application Support team,
The below service has been stopped in the server,
Service name : ".service." Timestamp : ".friendlyTime."
Server : ".host."
Please take the required action to resume the service. Thank you.
Regards,
Background Service Check Automation Bot"
| eval querypattern="default"
| eval assignmentgroup="PTO ABC Lab - Operatives"
| eval business_service="LIME Business Service"
| eval serviceoffering="LIME"
| eval Interface="CLMTS"
| eval urgency=2
| eval impact=1 Please let me know how you get on and consider adding karma to this or any other answer if it has helped. Regards Will