Splunk Search

Wildcard lookup returns more than one value

bciancio
New Member

So I have a regex:

rex field=requestUrl "^\w+:\/\/[^\/]+\/(?<uri>.+)$"

And then I use the value of that in a lookup

lookup uri-operationName uri as uri, verb as httpMethod OUTPUTNEW operationName as operationName

Works great, most of the time. As you can see below, if I search for an operationName of "Get Tenders By Account ID" I get results with both operationNames.

uri verb operationName
service-name/accounts/* GET Get By Account ID
service-name/accounts/*/tenders GET Get Tenders By Account ID

How would I go about fixing that within either the regex, search or lookup?

0 Karma

bciancio
New Member
eval operationName=mvindex(operationName,0)

This appears to get the most specific match. If anyone has info about mvindex returning the most specific rex value in some official documentation, I'd appreciate it.

0 Karma
Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...