Splunk Search

Extract year from filename

C_HIEN
Path Finder

I have some old syslog files to index.
I'm trying to extract year from the filename and month, day, time from events (in a custom datetime.xml) without success.

Is it possible? How to do that?

Thanks

0 Karma

sbbadri
Motivator

@C_HIEN

check that filename and source field have same value. If so you can extract by using regex or field extraction

1) rex field=source "/tmp/filename-(?<fileyear>\d+)"
2) props.conf

EXTRACT-fileyear = /tmp/filename-(?<fileyear>\d+) in source

0 Karma

C_HIEN
Path Finder

Thanks for your answer. I've already seen the answers you mention but it's not exactly what i'm trying to do... I want extract the year only from filename and get day and month from events... I've temporary solved my problem with an uf on a virtual machine within the system date was changed to the year of the files to index. But i still hope there is a better solution...

0 Karma

ekost
Splunk Employee
Splunk Employee

Sorry, I missed the "day, time from events" portion of the question. I think "sbbadri" has the piece you're looking for. Good luck!

0 Karma

ekost
Splunk Employee
Splunk Employee

These: one and two older Answers posts cover the typical scenarios and provide regex samples on using a custom datetime.xml to extract the date from the file name.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk on November 6 at 11AM PT, and empower your SOC to reach new heights! Duration: ...

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...