Splunk Search

Unable to Put Together Join Search

IRHM73
Motivator

Hi, I wonder whether someone may be able to help me please.

After reading the Splunk documentation I'm trying to put together a Join query with the following:

index="main" auditSource=*auth* auditType=LoginEntitlements detail.EmpRef=* 
  | rename detail.EmpRef AS REF
  |Join REF [Chris EI-GG]
  | stats count by REF

Where [Chris EI-GG] is the name of the saved search which I want to join to the above.

I've clearly done something wrong because I receive the error 'Unknown search command 'chris'.

Could someone perhaps explain to me please where I've gone wrong.

Many thanks and kind regards

Chris

Tags (1)
0 Karma
1 Solution

chanmi2
Path Finder

Hi, you may want to take a look at this answer
http://answers.splunk.com/answers/55715/joining-results-from-saved-searches.html
and try

join REF [| savedsearch "Chris EI-GG" ]

Hope this help

View solution in original post

chanmi2
Path Finder

Hi, you may want to take a look at this answer
http://answers.splunk.com/answers/55715/joining-results-from-saved-searches.html
and try

join REF [| savedsearch "Chris EI-GG" ]

Hope this help

IRHM73
Motivator

Hi @chanmi2, thank you once more for helping me out with this. It is greatly appreciated and works fine.

Kind regards

Chris

0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...