topic How to search for values greater than 10 in the results? in Splunk Search

How to search for values greater than 10 in the results?

chinmay25 — Wed, 19 Jan 2022 15:32:19 GMT

I am working on the query that generates a table with count of security violations. I want to filter our the users with violations greater than 10.

| rex field=_raw "(?<Message>Security\sviolation)\s\S+\s\S+\s(?<User>[A-Z0-9]+)"
| eval Time = strftime(_time, "%m-%d-%Y %H:%M:%S")
| rename JOBNAME as Jobname Time as Date
| eval Workload = substr(Jobname,1,3)
| stats count(Message) as "Security Violations" by Jobname User

Resulting table

User	Security Violations
ABC	1
DEF	4
GHI	12
JKL	3
XYZ`	20

Thank you,

Re: How to search for values greater than 10 in the results?

ITWhisperer — Wed, 19 Jan 2022 15:44:41 GMT

| where 'Security Violations' > 10

Re: How to search for values greater than 10 in the results?

isoutamo — Wed, 19 Jan 2022 16:45:28 GMT

In most cases use ” as values and ‘ as field names. Sometimes you need both on same time (see e.g. foreach + eval/fieldformat).