topic How does subsearch work? in Splunk Search

How does subsearch work?

AHEARNJ — Thu, 31 Aug 2017 14:23:59 GMT

Is it possible to create a new search based off of results of previous search. My example below I use regex to extract a new column with all my users names that are extracted from User.

index="source1" source="event-source"  rex field=_raw "(:?string1=\")(?<User>.*)(:?user account\")"

My goal would be to then create a new search of each user in another source

[Pesudo EXample] index-source1 source-user-source | search User | Select Id, name, phone, etc.

Re: How does subsearch work?

woodcock — Thu, 31 Aug 2017 14:43:03 GMT

Yes, this is very common. You do it with a subsearch:
http://docs.splunk.com/Documentation/SplunkCloud/latest/Search/Aboutsubsearches

Re: How does subsearch work?

DalJeanis — Thu, 31 Aug 2017 23:17:40 GMT

It looks something like this ...

  index-source1 source="user-source" 
       [ search index="source1" source="event-source" 
        | rex field=_raw "(:?string1=\")(?<User>.*)(:?user account\")" 
        | table User
       ]
 | table Id, name, phone, etc.

To see why this works, you should look at the format command. It takes all the events from the search and puts them into a field called search in this format

  ( ( User="firstUserValue" ) OR ( User="secondUserValue" ) OR ... )

To see what that looks like, run this...

   index="source1" source="event-source" 
   | rex field=_raw "(:?string1=\")(?<User>.*)(:?user account\")" 
   | table User
   | format

...and then just remember that anything in square brackets is run first and returned that way. If at the end of the square brackets there is only a field named search, then it is returned as-is. If not, then the format command is implicitly run to convert the records to a single return field named search.

(There are also a couple of other possibilities, like using the return verb, but those are what matter for your question here.)

Re: How does subsearch work?

woodcock — Fri, 01 Sep 2017 00:17:08 GMT

What he said.

Re: How does subsearch work?

AHEARNJ — Fri, 01 Sep 2017 02:33:16 GMT

Thanks for such a detailed response. I really appreciate the explanation.