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!

Building Reliable Asset and Identity Frameworks in Splunk ES

 Accurate asset and identity resolution is the backbone of security operations. Without it, alerts are ...

Cloud Monitoring Console - Unlocking Greater Visibility in SVC Usage Reporting

For Splunk Cloud customers, understanding and optimizing Splunk Virtual Compute (SVC) usage and resource ...

Automatic Discovery Part 3: Practical Use Cases

If you’ve enabled Automatic Discovery in your install of the Splunk Distribution of the OpenTelemetry ...