Splunk Search

Find the missed id in the Query2 compared with Query1

arjun_krishna
Explorer

I have 2 queries producing some results

Query1: index=foo* sourcetype="abc_uvw" activity="POST*/test1" source="/logs/mylogs.log" | table mr_id

Query2: index=foo* sourcetype="abc_uvw" DOMAIN="rkps" src="pqr" source="/logs/mylogs.log"
|dedup mr_id src | table mr_id

Query1 producing 1000 results, and query2 producing 999 records. Want to know that missed mr_id among them

0 Karma
Get Updates on the Splunk Community!

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...