Choose from several options for complete web, email and data security.
Evaluate Websense products by watching demos and installing evaluation software.
Learn how Websense solutions help keep our customer safe, secure and productive
Get information on product updates, support resources and more.
Get the most out of support in five simple steps.
Find tools and assets to help sell Websense solutions.
Come work for the global leader in unified information security.
Does anyone know the sql query to retrieve the top 10 users?
From the Websense Real Time Analyzer browser, when I click the "top ten users" hyperlink, the results and a bar graph are displayed within 5-10 seconds. If I query the "incoming" table/view with inner joins, the query takes 3 minutes to show the results. I need to run the query to display the results on a separate dashboard. I cannot use the Websense real time analyzer browser as it requires a login.
SELECT * FROM INCOMING WHERE (DATE_TIME > '2011-08-07') AND (DATE_TIME < '2011-08-08')
does not return, the usernames or urls that's why I'm using inner joins.
I'm using Version 6.3.2