topic Re: Is it possible to list the filters of the initial search with the results of a subsearch? in Splunk Search

Is it possible to list the filters of the initial search with the results of a subsearch?

Log_wrangler — Tue, 29 Sep 2020 21:45:23 GMT

Here is the scenario.

I have two indexes (index=AV and index=Packet_Analysis)

I use index=AV to find attack signatures and the attacker IP, then I pipe the IP results from this search into index=Packet_Analysis to see if, and when, the attacker IP did a GET from a certain domain.

For example

index=Packet_Analysis method=GET domain="bad.com" [search index=AV attack_sig="Bad stuff" attacker_IP=10.* |stats values(attacker_IP) as src_ip | table src_ip]  |stats values(src_ip) by _time

fyi - in index=AV the attacker_IP correlates to the src_ip in index=Packet_Analysis

The results I need are Attacker_IP, Attack_time, Src_IP, Get_time.

So,I need to display the results from the initial search with the results of the second search (with the respective times as they are different)...

I believe this can be done with fields and eval, however I need an example to get started.

Thank you

Re: Is it possible to list the filters of the initial search with the results of a subsearch?

kmaron — Thu, 25 Oct 2018 14:20:01 GMT

Try this. Your times will come out as the unix time so you'll need to strftime to make them readable but I think this will get you what you want and then you don't need the subsearch.

   (index=Packet_Analysis method=GET domain="bad.com") OR (index=AV attack_sig="Bad stuff" attacker_IP=10.*)
    | eval Get_Time = case(index="Packet_Analysis", _time)
    | eval Attack_Time = case(index="AV", _time)
    | eval src_ip = if(index="AV",attacker_IP,src_ip)
    | stats values(Get_Time) as GetTime values(Attack_Time) as AttackTime by src_ip

Re: Is it possible to list the filters of the initial search with the results of a subsearch?

Log_wrangler — Fri, 26 Oct 2018 00:50:25 GMT

Thank you for the reply. It got me going. I could not get it to work without coalesce, like this...

(index=Packet_Analysis method=GET domain="bad.com") OR (index=AV attack_sig="Bad stuff" attacker_IP=10.*)
     | eval Get_Time = case(index="Packet_Analysis", _time) | eval GetTime=strftime(Get_Time,"%Y-%m-%dT%H:%M:%S.%Q")
     | eval Attack_Time = case(index="AV", _time) | eval AttackTime=strftime(Attack_Time,"%Y-%m-%dT%H:%M:%S.%Q")
     | eval HostIP=coalesce(Remote_IP, src_ip)
     | stats values(GetTime) as GetTime values(AttackTime) as AttackTime by HostIP

Before I accept your answer, I was hoping you could look at my query and advise if there is a better way to write the strfttime conversion...

Thank you

Re: Is it possible to list the filters of the initial search with the results of a subsearch?

kmaron — Fri, 26 Oct 2018 12:39:51 GMT

if you want your GetTime/AttachTime to look like a timestamp ex: 2018-10-26T08:34:00.000 then your strftime is good.

If you want it to be more person readable you could do this

 eval GetTime=strftime(Get_Time,"%m/%d/%Y %I:%M:%S %p)

Which would make it show like this: 10/16/2018 8:34:00 am

There are a lot of options for formatting.

Re: Is it possible to list the filters of the initial search with the results of a subsearch?

Log_wrangler — Fri, 26 Oct 2018 12:58:07 GMT

Thank you, I really appreciate your help... I wonder if you can advise on another question I have "How do I correlate email events when the key-id is not defined in all events?"

Re: Is it possible to list the filters of the initial search with the results of a subsearch?

kmaron — Fri, 26 Oct 2018 14:12:39 GMT

Without really knowing your data I don't think I can help much but you can always post that as a new question and I'm sure someone would have a good answer (or two).