Splunk Search

user name missing or exist in search

pr_blr
Explorer

I am reading user from lookup file and then searching a search and find the user list from lookup file and giving table as user and status missing or exist in search.
please suggest me what should be the efficient way of doing this.

Tags (1)
0 Karma
1 Solution

kml_uvce
Builder

there are 2 ways of doing this.
1) Use left join : <first search of lookuptable> left join <second search>
2) use transaction and append on user: <first search of lookuptable> |append <second search> |transaction user|use if condition to see any field of second search exist then make value as exist otherwise missing.

second way of doing is faster than first...

kamal singh bisht

View solution in original post

0 Karma

kml_uvce
Builder

there are 2 ways of doing this.
1) Use left join : <first search of lookuptable> left join <second search>
2) use transaction and append on user: <first search of lookuptable> |append <second search> |transaction user|use if condition to see any field of second search exist then make value as exist otherwise missing.

second way of doing is faster than first...

kamal singh bisht
0 Karma

pr_blr
Explorer

thanks second option works for me

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