Splunk Search

most frequent eventlogs challenge

kspoton
New Member

Here is the custom event log format:

field1 field2 field3 FREE_TEXT

How would one query, say Top 10, FREE_TEXT ignoring first 3 fields which are space separated. FREE_TEXT can be any application level debug message which is not a fixed format.

Creating Fields is not an option. Neither is the code change to generate standard log format like Apache web log.

Just a single instance Splunk server(no clustering).

Tags (2)
0 Karma

joebensimo
Path Finder

Why is creating fields not an option? Even if you don't want fields for all searches, you can create per-search fields using the rex command.

You should be able to do something like:

... | rex field=_raw "^[^ ]+ [^ ]+ [^ ]+ (?<free_text>.+)" | top limit=10 free_text
Get Updates on the Splunk Community!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...