enVision Report - BlueCoat activity by Category

[RSAAdmin]

Hello, I am trying to create BlueCoat activity report via enVision, group by BlueCoat CatMap Category.  I am having trouble identifying how BlueCoat Category is mapped within enVision.

I ran a few trials using the AdHoc Reports function under - Host > Web Logs > Blue Coat.  I tried to modify build-in templates and build custom.  In either case, I was not able to create the result I was seeking.

I'm hoping someone can help me out.  Thanks.

[RSAAdmin]

Hi,

Do you mean the category as in the content filter category?

[RSAAdmin]

Yes I am.  Within BlueCoat, there are many content filter CatMap such as "Auction" "Shopping" "Email" and one oddball, which doesn't fit anywhere "Uncategorized".  I am trying to use enVision to generate activity the report on any of these content filter CatMap.

[RSAAdmin]

Ok - in my experience this comes under the 'category' meta within enVision against the web table.

Your best bet is to run a query for 10 minutes, import into excel (.csv) and manipulate the data that way.

Let me know how you get on.

[RSAAdmin]

create sql filter

Username LIKE ${Username} AND DeviceAddress in (select paddr from device_list where dtype=102) AND Filter LIKE ${Category}

than you have following report