how to remove values from fields highlighted in red
index=main | eval description=case(status == 200, "OK", status == 404, "Not found", status == 500, "Internal Server Error", status == 503, "Service Unavailable", status == 406, "Not Acceptable", status == 400, "Bad Request ", status == 408, "Request Timeout", status == 505, "HTTP Version Not Supported", status == 403, "Forbidden") | table _time status description | where isnotnull(status) | dedup status
Hi
Try with below
your query.... |where NOT status IN ("deferred","sent","expired","bounced")
index=main
| eval description=case(status == 200, "OK", status == 404, "Not found", status == 500, "Internal Server Error", status == 503, "Service Unavailable", status == 406, "Not Acceptable", status == 400, "Bad Request ", status == 408, "Request Timeout", status == 505, "HTTP Version Not Supported", status == 403, "Forbidden", true(), NULL)
| table _time status description
| where isnotnull(description)
| dedup status
Unfortunately, it does not work for me. But thank you for answering
Hi
Try with below
your query.... |where NOT status IN ("deferred","sent","expired","bounced")
Thanks. It's working