So our main index is our actual index and index_archive is the virtual index that is querying hadoop. When I query only the main index, we get results, but none from our virtual index.
index=main OR index=main_archive
user=exampleuser
| search (NOT "exampleExlude" NOT oauth_client_name=example-productionname )
| where isnotnull(ip_forwarded_for)
| eval source= mvindex(fwd_list, 0)
| eval fwd_list = split(ip_forwarded_for, ",")
| table _time, user, source, authorization_description, authorization_success, user_agent, method, path
| sort _time asc
... View more