Reporting

Is it possible to force the results to be used in a report to be case insensitive? For example UDP and udp are shown as different items.

zliu
Splunk Employee
Splunk Employee

Is it possible to force the results to be used in a report to be case insensitive? For example UDP and udp are shown as different items.

Tags (1)
1 Solution

gkanapathy
Splunk Employee
Splunk Employee

You can use the lower() (or upper()) function in an | eval command to normalize field values and report accordingly.

source=x userid=* | eval userid=lower(userid) | stats count by userid

View solution in original post

gkanapathy
Splunk Employee
Splunk Employee

You can use the lower() (or upper()) function in an | eval command to normalize field values and report accordingly.

source=x userid=* | eval userid=lower(userid) | stats count by userid
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 ...