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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Design, Compete, Win: Submit Your Best Splunk Dashboards for a .conf26 Pass

Hello Splunkers,  We’re excited to kick off a Splunk Dashboard contest! We know that dashboards are a primary ...

May 2026 Splunk Expert Sessions: Security & Observability

Level Up Your Operations: May 2026 Splunk Expert Sessions Whether you are refining your security posture or ...

Network to App: Observability Unlocked [May & June Series]

In today’s digital landscape, your environment is no longer confined to the data center. It spans complex ...