Splunk Search

sequential transactions

marquiselee
Path Finder

Any way to limit transactions to sequential records rather than by time? I have tens of thousands of IDs that can appear many times in a source. Each event of the source has the same _time (the index time of the source).

I'd like to sort the IDs and then transact on ID sequentially so that if the next event matched the ID it would transact on that. However if it did not match the next ID that transaction would be closed.

does this make sense? is this possible?

thanks

Tags (1)
0 Karma

cschmidt0121
Path Finder

You could probably do something crazy like eval _time=ID. Since time is internally just an integer anyway, this probably will work. Of course after you do that the timestamps will be horribly off, but they should at least be ordered as the IDs were.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

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