Security

Displaying results of same search over period of time

mo86
New Member

I have the following search and am looking to display its results over the past 30 days. It currently shows the results but only the current day is accurate. Any advice would be much appreciated...

index=data NOT ID="" earliest=-30d@d latest=now|regex name!="[a-z]."|dedup id2|timechart span=1d count

0 Karma

richgalloway
SplunkTrust
SplunkTrust

You probably don't need dedup. Try this search:

index=data NOT ID="" earliest=-30d@d latest=now|regex name!="[a-z]."|timechart span=1d dc(id2) as count
---
If this reply helps you, Karma would be appreciated.
0 Karma

inventsekar
SplunkTrust
SplunkTrust

It currently shows the results but but only the current day is accurate///
more details required.. may we know how you say that only current day is accurate, the older day logs are loaded properly or any issues?!?!

thanks and best regards,
Sekar

PS - If this or any post helped you in any way, pls consider upvoting, thanks for reading !
0 Karma

mo86
New Member

I believe there is something wrong with the dedup. Today shows the correct value and the day before shows a number, in this case 3. When I remove dedup all the results are off by 3.

0 Karma

mo86
New Member

Is there any way I can break up the search to make it dedup by one day at a time not across the whole thing?

0 Karma
Get Updates on the Splunk Community!

Strengthen Your Future: A Look Back at Splunk 10 Innovations and .conf25 Highlights!

The Big One: Splunk 10 is Here!  The moment many of you have been waiting for has arrived! We are thrilled to ...

Now Offering the AI Assistant Usage Dashboard in Cloud Monitoring Console

Today, we’re excited to announce the release of a brand new AI assistant usage dashboard in Cloud Monitoring ...

Stay Connected: Your Guide to October Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...