Top Ten Users SQL query

EC posted on 7 May 2012 12:58 PM

rated by 0 users

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.

The query:

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.

Thanks