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!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...