Splunk Search

inputlookup format to insert wildcard * is it possible?

r999
Path Finder

inputlookup like:

user       mailbox
smithj     john smith
bloggsj    joe bloggs

search string:

| inputlookup usermailbox.csv | fields search user mailbox | format "(" "(" "AND" ")" "OR" ")"]

returns

( ( user="smithj" AND mailbox="john smith" ) OR ( user="bloggsj" AND mailbox="joe bloggs") OR...

what i want is to return

( ( user="*smithj*" AND mailbox="*john smith*" ) OR ( user="*bloggsj*" AND mailbox="*joe bloggs*") OR...

Current workaround is to put the wildcards * in the csv values like so but this is a pain

user       mailbox
*smithj*   *john smith*
*bloggsj*  *joe bloggs*

Drainy
Champion

You could use eval to add them in manually at search time;

| eval user="*".user."*"

0 Karma

the_wolverine
Champion

No, unfortunately that doesn't work.

0 Karma
Get Updates on the Splunk Community!

Updated Team Landing Page in Splunk Observability

We’re making some changes to the team landing page in Splunk Observability, based on your feedback. The ...

New! Splunk Observability Search Enhancements for Splunk APM Services/Traces and ...

Regardless of where you are in Splunk Observability, you can search for relevant APM targets including service ...

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...