Splunk Search

Extract string from VERTICA-MIB::vertHostName = STRING: "vertica-1"

ispdev
New Member

This is the string :
VERTICA-MIB::vertHostName = STRING: "vertica-1"

i'm trying to extract the hostname so added the following at props.conf:

EXTRACT-vertHostName = ((?(<name>)yes|VERTICA-MIB::vertHostName\s=\sSTRING:\s\")(?<vertHostName>[^"]+))

which returns:
STRING: "vertica-1"

need to return:
vertica-1

Tags (1)
0 Karma

ispdev
New Member

OK this works fine on splunk:
EXTRACT-vertHostName = .+VERTICA-MIB::vertHostName\s=\sSTRING:\s\"(?[^\"]+)

0 Karma

alacercogitatus
SplunkTrust
SplunkTrust

Your regex is pulling all of the string initially. You have 5 capture groups, only 2 of which are named. Try this.

EXTRACT-vertHostName = VERTICA-MIB::vertHostName\s*=\s*STRING:\s*"(?<vertHostName)[^"]*)"

0 Karma

ispdev
New Member

there is a ( missing here...
and > missing i think...

i also checked this
((?()yes|VERTICA-MIB::vertHostName\s=\sSTRING:\s\")([^"]+))

with a regexp tool "Regulator" and it seems to work fine there.
at splunk i just add the ? but it keeps returning:
STRING: "vertica-1"

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...