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.
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...