Splunk Search

join 3 queries

sarit_s
Communicator

Hello
I have 3 queries that i need to join between them but there is a catch 

query number 1 checks for users who sent sms
query number 2 checks if we tried to resend the sms

query number 3 check if we got verification that the sms sent

in the end - i want to see only the cases where we have sent, resend and verify - all of them by id
when im using simple join - i get all the results and not only those with the resend method 

Labels (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

It would help to know the specifics of each query.  Without them, the best I can do is

<<query number 1>>
| append [ <<query number 2>> ]
| append [ <<query number 3>> ]
| stats values(*) as * by id
---
If this reply helps you, Karma would be appreciated.
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 ...