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
... View more