Splunk Search

Converting Epoch Time

Communicator

I'm running the below query to find out when was the last time an index checked in. However, in using this query the output reflects a time format that is in EPOC format. I'd like to convert it to a standard month/day/year format. Any help is appreciated. Thank you.

| tstats latest(_time) WHERE index=* BY index

0 Karma
1 Solution

SplunkTrust
SplunkTrust

There are several ways to do that.

Start with | tstats latest(_time) as time WHERE index=* BY index then add your choice of

| eval time = strftime(time, "%c")

| convert ctime(time)

| fieldformat time = strftime(time, "%c")

---
If this reply helps you, an upvote would be appreciated.

View solution in original post

0 Karma

Ultra Champion

see https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Commontimeformatvariables

month/day/year format is %x

but

| tstats latest(_time) as _time WHERE index=* BY index

This is enough.

0 Karma

SplunkTrust
SplunkTrust

There are several ways to do that.

Start with | tstats latest(_time) as time WHERE index=* BY index then add your choice of

| eval time = strftime(time, "%c")

| convert ctime(time)

| fieldformat time = strftime(time, "%c")

---
If this reply helps you, an upvote would be appreciated.

View solution in original post

0 Karma

Communicator

Using the following worked:

| tstats latest(_time) as time WHERE index=* BY index
| eval time=strftime(time, "%c")

Thank you!

0 Karma