So I need to run search on a firewall index where I need to look for field values matching from two lookup files, one is src.csv and dst_withsubnets.csv and output corresponding fields Test SPL from my lab | makeresults |eval src_ip="1.1.1.1", src_translated_ip="3.3.3.3", dest_ip="192.168.1.1", dest_port=443, action="drop"
| join src_ip
[| inputlookup src.csv
| rename src AS src_ip]
| join dest_ip
[| inputlookup dst_withsubnets.csv
| rename dst AS dest_ip ]
| table _time, src_ip, src_translated_ip, dest_ip, dest_port, action src.csv 1.1.1.1 dst_withsubnets.csv dst
192.168.1.0/24 As you can notice, the SPL is searching for dest_ip in a lookup that only has destination subnets. To make it work, I have also added following transforms.conf [dst_withsubnets]
filename = dst_withsubnets.csv
match_type = CIDR(dst)
max_matches = 1 However, its still not working
... View more