Splunk Search

How do I find common values from the results of two searches?

avis1119
New Member

Hi all,

I have a use case. I have a list of the top viewed products for the last 3 months individually. Now, I want to take the common values from the 3 results and want to have the trend for those common values. Which command do I have to use in a search? Please provide suggestions as I am new to Splunk.

Thanks in advance.

Tags (4)
0 Karma

fdi01
Motivator

use appendcols command to do it

 Index=list1 source=your_source_name sourcetype=your_sourcetype_name| ...| appendcols [ search  Index=list2 source=your_source_name sourcetype=your_sourcetype_name | ...  ]| appendcols [ search  Index=list3 source=your_source_name sourcetype=your_sourcetype_name | ...  ]
0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...