Splunk Dev

Building top with log source where values are given with a double dot(:) and not equal(=)

dschuermann
New Member

I’ve got trouble to build a top with log source, where the from value is given by "from*:" and not “from=*"

That way I just got 0 results, using “index="myindex" "from:"| top limit=10 from”
I’ve tried with rename and replace, but no success. How can I tell Splunk that the delimiter is “:” and not “=” for the search value? Or how can I replace/rename the result and then build a top over the result?

Tags (1)
0 Karma

manjunathmeti
Champion

Delimiter ":" or "=" is set during parsing of your logs before indexing them. For existing data you need to extract value using rex and then do top.

index=INDEX_NAME "from:" | rex "from:\s*(?<from>[\w]+)" | top limit=10 from
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!

Defend at Machine Speed: Your Guide to Security Sessions at .conf26

Splunk .conf26   With threats moving at machine speed and attack surfaces expanding across hybrid ...

Where Innovation Takes Flight: The Splunk4Aviation Flight Sim Lands at .conf26

If you hear someone at .conf26 shouting "gear down, GEAR DOWN" across the show floor, you have found us.  The ...

Turn Cisco Telemetry Into Action with Cisco Data Fabric, powered by the Splunk ...

The surge in machine data is already hitting enterprise budgets, and the agentic era will only intensify it. ...