Statistics

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 ( ).

Note: Reports without a run end time indicate executions that failed.

Disabling Statistics/Defining Your own Statistics Routine

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.