So I specify an outer query, it usually starts like this:
earliest=06/14/2019:13:00:00 latest=06/14/2019:14:00:00 index=os sourcetype=ps
So far, so good. Now I want to find all PIDs using the same Java command line, e.g.
|search [search CMD=java* |table CMD ]
Then summarise the results:
|stats values(PID) as PIDs by CMD
The issue is that my subsearch doesn't seem to default itself to the
latest fields I specified at the very beginning of the query. In fact I have to pad my subsearch like this:
|search [search earliest=06/14/2019:13:00:00 latest=06/14/2019:14:00:00 index=os sourcetype=ps CMD=java* |table CMD ]
This is unnecessarily bulky. And I don't want to have to specify the time range multiple times.
How can I make my inner search (the "subsearch") adhere to the
latest keywords specified to the outer search?
Then how about the inverse? Does the outer search obey the limits set by the inner search? Will
latest be honoured by the outer search if they are not explicitly overridden?
It can be done. The way it is done is kind of convoluted. I've never used it myself, but here is a very similar example where it was successfully done:
You could use this example and build your query off of it to pass the time range from the subsearch to the outer search. I tested the example and it does sucessfully substitute the Outer and Sub search time ranges.