myDBR gathers statistics on reporting activity, storing the following information:
- User
- Report accessed
- Run start time
- Run end time
- Full query with parameters
These statistics are stored in the database table mydbr_statistics. Pre-installed reports such as sp_DBR_StatisticsSummary and sp_DBR_StatisticsReport utilize this table for reporting purposes. Administrators can also create custom reports based on this stored data.
Administrators can utilize this information for:
- Finding actively used reports
- Optimizing slow reports
- Understanding which users or user groups utilize specific reports
- Planning for new reports
The administrator's 'Statistics summary' report (sp_DBR_StatisticsSummary) provides insights into the most active users, most accessed reports, and the slowest reports.
The 'Statistics for a report' report (sp_DBR_StatisticsReport) offers detailed information on individual reports. It serves as a drill-down report accessible via the 'Show Report Statistics' button
(
).
Reports without a run end time indicate executions that failed.
You can disable statistics (for example if you are running myDBR on read-only mode) by adding following line to :
$mydbr_defaults['statistics']['enabled'] = false;
The statistics routines in myDBR are defined in $mydbr_defaults['statistics']. If you want to create your own routines, take a look at the default ones and create your own based on the defaults, modifying the $mydbr_defaults['statistics']['start'] and $mydbr_defaults['statistics']['end'] definitions.
myDBR version 6.1 added the cache parameter to the end-report. To maintain compatibility with old user-defined end-reports, myDBR will add the cache parameter only when the end-report is myDBR's default or when $mydbr_defaults['statistics']['include_cache_param_to_user_defined_end_call'] is set to true.