Security

How to pass result set from one query to main query

madhan_dc
New Member

I am running a query like this

 

 

index=main source=transferstatus sourcetype=logs transaction.transferSet.FileName="*myfile*" | stats dc(transaction.Id) by transaction.Id

 

 

this gives me the unique transaction Ids that i am looking for 

Now i want to pass this unique transaction Ids to a query like below

 

 

index=main  source=transferstatus sourcetype=logs transaction.action="success" transaction.Id=[ pass each unique value i got from first query to here]

 

 

transaction.action="success" will not present on the first query results..

it will be part of success events that wont have "transaction.transferSet.FileName" field in it.

how do I join these two queries?

 

 

 

 

 

 

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@madhan_dc 

Have you tried something like this?

index=main source=transferstatus sourcetype=logs transaction.action="success" [search index=main source=transferstatus sourcetype=logs transaction.transferSet.FileName="*myfile*" 
| stats dc(transaction.Id) by transaction.Id | fields transaction.Id]

 

KV 

0 Karma

madhan_dc
New Member

not sure how this question landed in this section, can someone please move it to a Splunk query section if there is one. thanks. Sorry about this.

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...