Splunk Search

Find inconsistencies in the IDs of results

ilomax
New Member

Hello,

I'm new to Splunk in general, and I was wondering is there was a way to highlight inconsistencies in the IDs of the returned events.

I've got a simple query : index="<field>" | sort -_time | dedup id which returns 6056 results, ranging from ID 31 to 14.236.
Obviously, there are gaps. I'd like to be able to get a clear vision of all the gaps, which could give me an answer to why there are so many.

Any help is greatly appreciated,
Thanks in advance !

0 Karma

woodcock
Esteemed Legend

Your sort -_time is redundant and not only that it is trimming your result set to 1000 because the default is sort 1000 so get rid of it and then you should see WAAAAAAAAAAAAAAAAY more events and fewer "gaps". If you think that you need the sort to double-check the sorting, then use sort 0 - _time, but it will be the same.

0 Karma
Get Updates on the Splunk Community!

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

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 ...