topic How to perfom math calculations in Splunk Search

How to perfom math calculations

bvenom28 — Thu, 13 Mar 2014 14:41:10 GMT

I am trying to figure out how to take two searches and divide their results to create a dial chart showing the percentage of breached records.

index=itsm sourcetype=sm9_incident | dedup NUMBER | search assignmentGroup="WG1555" AND isBreached="t" AND status="Closed" |stats count

index=itsm sourcetype=sm9_incident | dedup NUMBER | search assignmentGroup="WG1555" AND status="Closed" | stats count

Re: How to perfom math calculations

MuS — Thu, 13 Mar 2014 14:52:58 GMT

Hi bvenom28,

try something like this:

index=itsm sourcetype=sm9_incident assignmentGroup="WG1555" | dedup NUMBER | eventstats count(eval(isBreached="t" AND status="Closed")) as isBreachedCount count(eval(status="Closed")) as ClosedCount | eval myPrec=isBreachedCount*100/ClosedCount | table myPrec

cheers, MuS

Re: How to perfom math calculations

bvenom28 — Thu, 13 Mar 2014 15:02:18 GMT

Wow that worked perfect. I have alot to learn. Thanks!!!!

Re: How to perfom math calculations

piebob — Thu, 13 Mar 2014 15:51:31 GMT

bvenom28, i recommend you check out the search and reporting class offered by the Splunk EDU team, it's a good way to get started!

Re: How to perfom math calculations

marcoscala — Thu, 13 Mar 2014 16:06:26 GMT

bvenom28,

your searches where really not well formed:

index=itsm sourcetype=sm9_incident | dedup NUMBER | search assignmentGroup="WG1555" AND isBreached="t" AND status="Closed" |stats count

The search terms should always be places at the beginning of the search, unless you really need to filter out results based on same valued calculated in a stats or eval statement.

As correctly MuS wrote, the assignmentGroup="WG1555" condition has been placed right at the beginning, and he wisely used the "count(eval('condition')) trick to summarize values of events matching a certain condition.

marco