topic Re: Problem with case statement using eval in Splunk Search

Problem with case statement using eval

selinakvle — Thu, 04 Apr 2019 17:09:22 GMT

Hi all,

Getting this error:

Error in 'eval' command: The expression is malformed. Expected ).

I'm following the following tutorial:

https://www.splunk.com/blog/2017/06/01/enhancing-splunk-visualizations-with-mapbox.html

Everything was going fine until I got to the part of the search where I had to add the eval case statement color parameters. Can someone tell me where I'm going wrong? Thanks!

sourcetype="test" severity="critical" | iplocation src prefix=start_ | iplocation dest prefix=end_ | search start_Country="*" end_Country="*" | table start_lat start_lon end_lat end_lon app | eval animate="yes", pulse_at_start="yes" | eval color = case (
match(app, "ssh"), "#c0392b"
    match(app, "web-browsing"), "#e67e22",
    match(app, "unknown-tcp"), "#f1c40f",
    match(app, "webdav"), "#27ae60",
    1==1, "#7f8c8d")

It doesn't look like I'm missing anything..but then again..Its always better with another set of eyes:)

Re: Problem with case statement using eval

martinpu — Thu, 04 Apr 2019 17:16:37 GMT

Missing a comma after first match, this should help

sourcetype="test" severity="critical" 
    | iplocation src prefix=start_ 
    | iplocation dest prefix=end_ 
    | search start_Country="*" end_Country="*" 
    | table start_lat start_lon end_lat end_lon app 
    | eval animate="yes", pulse_at_start="yes" 
    | eval color = case (
        match(app, "ssh"), "#c0392b",
        match(app, "web-browsing"), "#e67e22",
        match(app, "unknown-tcp"), "#f1c40f",
        match(app, "webdav"), "#27ae60",
        1==1, "#7f8c8d")

Additionally, one useful thing for formatting your queries, if you press CTRL and \ at the same time while in the search window, your query gets automatically formatted to be readable, try it out, it makes troubleshooting queries a lot easier.

Re: Problem with case statement using eval

skoelpin — Thu, 04 Apr 2019 17:50:07 GMT

You're missing a comma on line 2. Fix that and it will work

Re: Problem with case statement using eval

selinakvle — Thu, 04 Apr 2019 19:07:04 GMT

Thank you, I feel dumb now.

Re: Problem with case statement using eval

selinakvle — Thu, 04 Apr 2019 19:07:20 GMT

Thank you...face palm

Re: Problem with case statement using eval

skoelpin — Thu, 04 Apr 2019 19:23:34 GMT

No need to feel dumb, everyone goes through this and understands the missing parenthesis error message doesn't always mean the parenthesis are missing