Query Help

gozdeyildiz — Thu, 14 Nov 2019 13:29:09 GMT

Hi,

I am trying to search logs from specific source and with specific name and to search IP found in previous search in all indexes.

Ex: index=firewall and name="malicious IP' (this will give a log with IP address and I want to search that IP address in all indexes.

Thanks in advance.
Bests,
Gozde

Re: Query Help

gcusello — Thu, 14 Nov 2019 13:53:31 GMT

Hi @gozdeyildiz,
please try something like this (if the field is called IP in every index:

index=* [ search index=firewall name="malicious IP" | fields IP ]
| ...

If you cannot be sure that IP field has the same name in every index, you could try something like this:

index=* [ search index=firewall name="malicious IP" | rename IP AS query | fields query ]
| ...

In both the searches check if the number of results of subsearch is more or less than 50,000, because there's this limit in subsearches.

Ciao.
Giuseppe