I'm trying to create a search where I take a small list of IPs from sourcetype A and compare them against a larger set of IPs in sourcetype B. I will then make a table using fields from sourcetype B that do not exist in sourcetype A to create a more detailed look of the events involving the IP.
Is there a way to do this without using a lookup table?
index=paloalto (sourcetype=sourcetype_B OR sourcetype=sourcetype_A)
| eval small_tmp=case(log_type="CORRELATION", src_ip)
| eval large_tmp=case(log_type!="CORRELATION", src_ip)
| where match(small_tmp, large_tmp)
| table field A, field B, field C
... View more