Splunk Search

Time format for given log

VijaySrrie
Builder

Hi Team,

What is the Time_Format for
Tue Sep 17 12:43:09.925775 2019
I am not able to get it exactly from the below link
https://docs.splunk.com/Documentation/Splunk/8.0.3/SearchReference/Commontimeformatvariables

Labels (1)
Tags (1)
0 Karma
1 Solution

PavelP
Motivator

Hello @vijaysri ,

it should work with the current Splunk version automatically.

Alternatively you can set TIME_FORMAT=%a %b %d %H:%M:%S.%6N %Y

View solution in original post

PavelP
Motivator

Hello @vijaysri ,

it should work with the current Splunk version automatically.

Alternatively you can set TIME_FORMAT=%a %b %d %H:%M:%S.%6N %Y

harsmarvania57
Ultra Champion

Hi,

Please try below config

TIME_FORMAT = %a %b %d %H:%M:%S.%6N %Y
0 Karma

vnravikumar
Champion

Hi

Try this

| makeresults 
| eval temp="Tue Sep 17 12:43:09.925775 2019" 
| eval epoch=strptime(temp,"%a %b %d %H:%M:%S.%6Q %Y") 
| eval output=strftime(epoch,"%a %b %d %H:%M:%S.%6Q %Y")
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Developer Spotlight with Denis Gladkikh

From Splunk Engineer to Kubernetes App Builder Denis GladkikhWhat happens when a lifelong developer turns a ...

Governing Enterprise AI, Bringing Cisco Telemetry Home, and More from Splunk Lantern

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...

Agentic SOC Triage: Investigating Splunk ES Notables with MCP Server and a Local LLM

The Problem: Too Many Alerts, Too Little Context Security operations teams running Splunk Enterprise Security ...