Splunk Search

How to generate a regex to find text and values greater than or equal to 2000001?

kalais
New Member

Hi ,
I have in my log like
{"name":"liquid-networth","value":"2000001"}

I need to get all value which is greater than and equal to 2000001. Please help me to find in splunk search..

0 Karma

woodcock
Esteemed Legend

Like this:

index=YourIndexHere sourcetype=YourSourcetypeHere | spath | search value >= 2000001

Note: the spath command might create a field name with other prefices for value so it may not have that exact name.

0 Karma

micahkemp
Champion

You can use >= in your search, assuming you have "value" parsed out into a field already:

index=(your index) value >= 2000001
Get Updates on the Splunk Community!

Extending Splunk AI Assistant for SPL to Splunk Enterprise customers!

Howdy Splunk Community! It’s an exciting day here at Splunk – Splunk AI Assistant for SPL version 1.3.0 is now ...

Developer Spotlight with Qmulos

Qmulos: Building a Next-Level Cybersecurity Business through Splunk Apps Qmulos started as a scrappy startup ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Enhance Security Operations with Automated Threat Analysis in the Splunk EcosystemAre you leveraging ...