topic Re: Custom Reports v4.0.1 (be1demo) in General Topics

Custom Reports v4.0.1 (be1demo)

migration — Mon, 28 Mar 2011 11:54:14 GMT

When creating a custom report and using the query builder there seems to be a problem with adding multiple values in the builder (unless I am just doing this wrong)

I am trying to create a report to show from the traffic summary log all peer-to-peer technology traffic of a risk catagory of 4 or 5.

This is the statement I am using:

technology-of-app eq peer-to-peer AND risk-of-app eq 5 OR risk-of-app eq 4

Once I run this report all I seem to get is apps with a risk of 4 or 5 as there is client server, browser based, etc traffic in the report aswell.

If I remove the OR statement and the second risk query I get the correct report but only for a risk of 5 for example.

Any ideas??

Cheers

Marc

Re: Custom Reports v4.0.1 (be1demo)

dmarion — Mon, 28 Mar 2011 18:02:51 GMT

Hi Marc,

I was working on something similar in the gui earlier for threats. I ended up just doing a "greater than or equal to 4", which gave me all the 4s and 5s. (Also still on 3.1.7 - not sure if it changes in 4.0).

Hope the information helps.

Re: Custom Reports v4.0.1 (be1demo)

James — Mon, 28 Mar 2011 18:33:58 GMT

Hi Marc,

I believe you need to use parentheses:

(technology-of-app eq peer-to-peer) AND (risk-of-app eq 5 OR risk-of-app eq 4)

Thanks

James

Re: Custom Reports v4.0.1 (be1demo)

migration — Tue, 29 Mar 2011 06:41:30 GMT

Thanks James.... spot on!!