Splunk Search

How do I use Greater Than in a string

devanoverstock
Explorer

I have a field called rules_tripped

It returns the results like this 

 

 

rules_tripped="5237260000001713515:Item Sku Fraud & Chargeback Percentage 0:0"

 

 

Rule ID : Rule Name : Rule Score

I want to only search for rules that have a rule score of > 800 

Is that possible to split the query and search for only rules with a rule score of > 800?

Labels (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Try this

| eval rules_score=mvindex(split(rules_tripped,":"),2)
| where rules_score > 800

View solution in original post

devanoverstock
Explorer

That worked perfectly, thank you!!!

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try this

| eval rules_score=mvindex(split(rules_tripped,":"),2)
| where rules_score > 800
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...