If I log into Reporter, using a Role configured for a client IP filter, these two reports take hours to load.

Solution

Overview

If I log into Reporter, using a Role configured for a client IP filter, these two Dashboard reports take hours to load.

  • View browsing per user.
  • Blocked web sites.
Cause
Resolution

They will eventually load, but  they will take longer than the other Dashboard Reports.

This is expected behavior, because we don't pre-build the required datasets to run these two reports with a filter on client ip. While the Reporter database is  configured with pre-built datasets, that allow all pre-defined reports to run as efficiently as possible, not all combinations, can be ready made in advance, especially when we add in our own filtering.  In this case ,  the reports are running fine, but the user does need to wait a while Reporter builds the required sets on the fly to fill our the Report.

Look to this article for ideas on how to improve the performance of these, and other reports:

/articles/Solution/HowcanIaddmoreindexedpairsortripletstomyDatabase

Workaround
Additional Information
Bug Number
InQuira Doc IdKB3399
Attachment

Article Feedback

Did this Article solve your issue?
Additional Comments:
 
Previous MonthNext Month
SunMonTueWedThuFriSat