how to retrive the values above and below the certain limit

[splunkpoornima]

hi all ,

source="taskmanger_logs"|transaction TaskAction startswith=START endswith=Succeeded|table TaskAction duration

so i got the result as

TaskAction duration

task1 45

task2 90

task3 221

task4 765

task5 534

now i want to display the tasknames where the duration is >90 but < 534

what command i have to use for this kind of problem ...eval???..

Thanks in advance

poornima

[sbrant_splunk]

Something like this maybe?

source="taskmanger_logs"
|transaction TaskAction startswith=START endswith=Succeeded
|where (duration>90 AND duration<534)
|table TaskAction duration