I have two source. First is IPS, second is ASA.
I want to find unique IP address ("destip") with signature 2245 OR 2700.
My query is:
sourcetype="snort" 2245 OR 2700 | dedup destip | table dest_ip
And now, i want to find events with this unique IP addess in ASA log. In ASA log IP called "srcip".
sourcetype="asa" | append [search sourcetype="snort" 2245 OR 2700 | dedup destip | table destip] | where srcip=destip
I think it is very simple, but I cannot find any answers and solutions to my question. 😞
Thank in advance!
sourcetype="asa" [search sourcetype="snort" 2245 OR 2700 | stats count by dest_ip | rename dest_ip as srcip | table srcip | format]
sourcetype="snort" 2245 OR 2700 | stats count by dest_ip | map maxsearches=1000 search="sourcetype=asa src_ip=$dest_ip$"
I do agree. There best method will be to use lookup table (if no of destips are low, which I believe will not be) OR use of summary indexing. You can schedule a saved search to write into a custom summary index hourly or daily, per your requirement, list of all destip with signature 2245 OR 2700. Once that is setup, in the first query subsearch,instead of searching the main index, you'll just search from summary index data which is already summarize and will be much much faster (personal experience)