Getting Data In

assign cron time to timestamp

yaaseensalie
Explorer

Hi, 

I have a rest call that runs every 24hours, and the number of events that are returned are in the region of +500 000 this obviously takes a few minutes to get everything into Splunk.

The problem is that the timestamps are completely out, I want all events to have the cron timestamp instead of the indexed time. I've tried 

DATETIME_CONFIG = NONE

and I've tried

DATETIME_CONFIG = CURRENT

 is there anything else I can try?

Thanks

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try overriding _time in your query

 

| eval _time=now()

Or perhaps 

| eval start=now()

toward the beginning of your query, and

| eval _time=start

towards the end

 

0 Karma

yaaseensalie
Explorer

Thanks @ITWhisperer for the reply

But The GET request takes a while to get the results into Splunk, I'm using these results to create a lookup. I would like to use the CRON time as my timestamp for my events, I don't want to override anything in SPL. I'm trying to find a solution which is during Index time and not Search Time.

0 Karma
Get Updates on the Splunk Community!

Finding Based Detections General Availability

Overview  We’ve come a long way, folks, but here in Enterprise Security 8.4 I’m happy to announce Finding ...

Get Your Hands Dirty (and Your Shoes Comfy): The Splunk Experience

Hands-On Learning and Technical Seminars  Sometimes, you just need to see the code. For those looking for a ...

What’s New in Splunk Observability Cloud: January Feature Highlights & Deep Dives

Splunk Observability Cloud continues to evolve, empowering engineering and operations teams with advanced ...