Reporting

How to find difference between 2 search?

yatanveersingh
Engager

Hi All,

 

I am trying to search difference between 2 search:

 

search 1: 

 

index="xxx_prd" "/XX900/LT_TEST"

 

this is returning like 20 records.

 

search 2:

index="xxx_prd" "http://xxx.yyy.com/XX900/LT_TEST"

this is returning 15 records.

 

I want to get the 5 results which are different between search 1 and search 2.

 

pl advice.

 

Thanks

Yatan

Labels (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Check out the set diff command.

| set diff [ search index="xxx_prd" "/XX900/LT_TEST"]
  [ search index="xxx_prd" "http://xxx.yyy.com/XX900/LT_TEST" ]
---
If this reply helps you, Karma would be appreciated.

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
index="xxx_prd" "/XX900/LT_TEST" NOT "http://xxx.yyy.com/XX900/LT_TEST"

richgalloway
SplunkTrust
SplunkTrust

Check out the set diff command.

| set diff [ search index="xxx_prd" "/XX900/LT_TEST"]
  [ search index="xxx_prd" "http://xxx.yyy.com/XX900/LT_TEST" ]
---
If this reply helps you, Karma would be appreciated.
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

How to find the worst searches in your Splunk environment and how to fix them

Everyone knows Splunk is a powerful platform for running searches and doing data analytics. Your ...

Share Your Feedback: On Admin Config Service (ACS)!

Help Us Build a Better Admin Config Service Experience (ACS)   We Want Your Feedback on Admin Config Service ...