- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
enVision Report - BlueCoat activity by Category
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi,
Do you mean the category as in the content filter category?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
