Getting Data In

How to use the last import for my source?

chadman
Path Finder

I have a file that gets imported every time it changes. Each line in the file shows up as an event and I want to use data only from the last import. So each import might have 200 events, but I only want to see those 200 and none from previous imports. I have tried this and it looks like it works, but had an issue with it once when the data was large and it did not all import at the excat same time stamp. Because of this some of the data was missing.

| eventstats latest(_time) AS Current | where _time=Current
0 Karma
1 Solution

Sukisen1981
Champion

what happens if you try this?

| eventstats max(_time) AS Current | where _time=Current

View solution in original post

Sukisen1981
Champion

what happens if you try this?

| eventstats max(_time) AS Current | where _time=Current

chadman
Path Finder

Thanks! that worked!

0 Karma

somesoni2
SplunkTrust
SplunkTrust

@chadman,

Glad you issue was resolved by @Sukisen's answer. Do remember to close the question by accepting the same.

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