Splunk Search

From epoch to _time for make a timechart based search.

cpm003
Path Finder

Hello! i hope you can help me with this.

I´m trying to set as _time an epoch field located at "rt" field.

alt text

But if i try to make an timechart after eval _time=getTime, i receive following error.
alt text

0 Karma
1 Solution

arjunpkishore5
Motivator

strftime converts your epoch time to string and that's why it does not work. All you need is this.

index=business AND combo
| eval _time=rt/pow(10,3)
| timechart count

Please up vote and mark as answer if this works for you.

View solution in original post

arjunpkishore5
Motivator

strftime converts your epoch time to string and that's why it does not work. All you need is this.

index=business AND combo
| eval _time=rt/pow(10,3)
| timechart count

Please up vote and mark as answer if this works for you.

Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...