Splunk Search

How to run a search only if the format of the passed in ticket number is valid?

hmdoan
Explorer

I've been struggling with how to use 'if' via eval to determine whether or not to run a search.

We only want to run a search if the passed in ticket number is in a valid format - e.g., IM123456, IM234567, etc.

Here is my failing code:

| dbquery Netcool "select node, ticketnumber, summary from reporter_status where ticketnumber='$ticket_token$'" | eval ticketed = if(match($ticket_token$,"^IM.*"),1,0) | where ticketed > 0

I know the search works alone. It's the 'if' statement screwing things up.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Wildcards are different in the match function. Try match($ticket_token$, "IM%").

---
If this reply helps you, Karma would be appreciated.
0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...