I have the following main search: index=utm sys=SecureNet action=drop
| eval protocol=case(proto==1, "ICMP", proto==6, "TCP", proto==17, "UDP", proto==132, "SCTP", 1=1,proto)
| table _time sev...
See more...
I have the following main search: index=utm sys=SecureNet action=drop
| eval protocol=case(proto==1, "ICMP", proto==6, "TCP", proto==17, "UDP", proto==132, "SCTP", 1=1,proto)
| table _time severity srcip srcport srcmac dstip dstport dstmac protocol eval action fwrule tcpflags ttl initf outitf
| sort -_time On the existing eval, I need to modify the end that acts as the else. Right now, the else specifies a name for numbers 1, 6, 17, and 132 in field "proto". I need the else to use any other occurring number to lookup an associated name from a csv containing 2 fields: "number" and "name". I cannot for the life of me figure out what kind of subsearch to use or the syntax... I imagine it is something like: | inputlookup protocol_number_list.csv
| search number=proto
| return name but I can't figure out how to combine the two. Any help would be greatly appreciated, thanks!