I'm using | chart count over severity by technique to display events by level of severity
Currently I am not getting severity in order from Highest to Lowest on the x-axis where the order is off in the column chart visualization
I've also tried
| stats count by severity technique
What would be an effective way to have these order correctly?
Thanks in advance!
Like this:
index=_* sourcetype!=audittrail
| stats count BY log_level
| eval _log_level = case(
log_level=="INFO", 0,
log_level=="WARN", 1,
log_level=="ERROR", 2,
log_level=="MAJOR", 3,
log_level=="MINOR", 4,
log_level=="CRITICAL", 5)
| sort 0 _log_level
Like this:
index=_* sourcetype!=audittrail
| stats count BY log_level
| eval _log_level = case(
log_level=="INFO", 0,
log_level=="WARN", 1,
log_level=="ERROR", 2,
log_level=="MAJOR", 3,
log_level=="MINOR", 4,
log_level=="CRITICAL", 5)
| sort 0 _log_level
Thank you! this is great