Splunk Search

how to get middle string from source field in splunk

sreebms
New Member

sourcetype=XXX "Server has been shutdown" | table _time, host, tag::host, _raw,source,field

hear my source is /opt/Messaging/JMS/jms-node1/bin/Nohub.log from this source i need jms-node1

Tags (1)
0 Karma

p_gurav
Champion

Hi,

You can use rex command

| rex field=source "\/opt\/Messaging\/JMS/(?P<nodename>[^\/]+)\/bin\/Nohub\.log"
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Assuming you always want the fourth level of the source path, this should do the job.

sourcetype=XXX "Server has been shutdown" | rex field=source "/opt/Messaging/JMS/jms-node1/bin/Nohub.log" | table _time, host, tag::host, _raw,source,field
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 2)

Welcome to the "Splunk Classroom Chronicles" series, created to help curious, career-minded learners get ...

Index This | I am a number but I am countless. What am I?

January 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  Happy New Year! We’re ...

What’s New in Splunk Enterprise 9.4: Tools for Digital Resilience

PLATFORM TECH TALKS What’s New in Splunk Enterprise 9.4: Tools for Digital Resilience Thursday, February 27, ...