Knowledge Management

Workflow Action "case sensitivity" question

gnovak
Builder

Hi,

I have a workflow action that creates a link to an external site based on information in a particular field and eventtype.

The problem i have noticed is that in splunk the field i have chosen for this workflow action is displayed in logs like this: 6411-CP.

This field is inserted into a URL which users can access from a link in splunk. The problem now is the link they access doesn't like the CP being capital. The link returns no results with 6411-CP but does return results with 6411-cp.

Any ideas on how to get splunk to maybe change upper case to lower case for a workflow action using a link?

Tags (1)
1 Solution

ftk
Motivator

Well I think you have a couple of ways you could go about this. If you are using the workflow action on a saved search, you could simply add an eval statement to change the field to lowercase in the results, so when the workflow action is triggered it will use the lowercase field:

your search terms | eval my_field=lower(my_field)

Alternatively, you could convert the data to lowercase at index time using SEDCMD to substitute characters.

View solution in original post

ftk
Motivator

If that answer solved your problem, can you please click the check mark next to the answer? It will mark this questions as answered and help keep the site clean.

Thanks!

0 Karma

ftk
Motivator

Well I think you have a couple of ways you could go about this. If you are using the workflow action on a saved search, you could simply add an eval statement to change the field to lowercase in the results, so when the workflow action is triggered it will use the lowercase field:

your search terms | eval my_field=lower(my_field)

Alternatively, you could convert the data to lowercase at index time using SEDCMD to substitute characters.

gnovak
Builder

That worked...thanks!

0 Karma

gnovak
Builder

I'll give that a shot.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Modernize your Splunk Apps – Introducing Python 3.13 in Splunk

We are excited to announce that the upcoming releases of Splunk Enterprise 10.2.x and Splunk Cloud Platform ...

Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...

After a whole week of being on call, you fell asleep on your keyboard, and you hit a sequence of buttons that ...