I have googled and searched my little heart out, but I am unsure if I am querying using best practice or if this would even work. But here is what I am trying to do:
Use case example:
AV alert logs to one index, with identifiable field "Computer_Name" then ensure "src_host" field matches "Computer_Name" in another index and then stats various fields within each index.
index=index2 sourcetype=irrelevant2 category!=Other
| fields Computer_Name, field, field
[search index=index1 ind_primary_user_business_unit=irrelevant | fields src_host, field, field, field, field, field, field]
| eval host=coalesce(src_host,Computer_Name)
|stats count by host, field from index 1, field from index 1,field from index 2, field from index 2, field from index 2, field from index 2, field from index 2, field from index 2
Thanks as always
... View more