Deployment Architecture

How to setup summary index using existing date field in data

manjuase
Explorer

Hi -

I have saved search returning events from past one year as below

ReadDate Count
20161101 500
20161102 550
.
.
.
.
20161228 800
20161229 900
.

and i have populated this data in to summary index however all this data is indexed with current data instead i want all this data to be indexed based on the ReadDate field. Hence tried setting up _time to ReadDate but results are not successful. Any suggestions how to achieve this please?

Thanks in Advance.

Tags (1)
0 Karma

somesoni2
Revered Legend

Try like this

your current saved search giving field ReadDate, Count
| eval _time=strptime(ReadDate,"%Y%m%d")

manjuase
Explorer

Hi,

Thanks for your reply....

It is working....

0 Karma
Get Updates on the Splunk Community!

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 2)

Welcome to the "Splunk Classroom Chronicles" series, created to help curious, career-minded learners get ...

Index This | I am a number but I am countless. What am I?

January 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  Happy New Year! We’re ...

What’s New in Splunk Enterprise 9.4: Tools for Digital Resilience

PLATFORM TECH TALKS What’s New in Splunk Enterprise 9.4: Tools for Digital Resilience Thursday, February 27, ...