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!

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...

Security Highlights | January 2023 Newsletter

January 2023 Splunk Security Essentials (SSE) 3.7.0 ReleaseThe free Splunk Security Essentials (SSE) 3.7.0 app ...

Platform Highlights | January 2023 Newsletter

 January 2023Peace on Earth and Peace of Mind With Business ResilienceAll organizations can start the new year ...