Top Running Reports
Using this report, you can list the reports that have been running for long periods of time or that have run an excessive number of times. A report will be listed as Top Running, based on its overall cost to the system, determined by the average execution time * run count. By default, the most costly reports are listed first. Note that the average execution time includes not only the database query, but also the time associated with building the report on the Portal server.
Explore your data center using customizable report templates or by using parts of your IT infrastructure as entry points. Use Search to find reports, templates and dashboards across the portal.
Use the Reports tab to examine the catalog of templates, dashboards and reports - organized by products along with user-created, and system folders. This report is located here:
Select the time range for the list in the scope selector.
Click the link to view the Top Running Reports.
See Top Running Reports .
Table: Top Running Reports
Column name | Description |
|---|---|
|
Template Name |
The report template name. |
|
Report Name |
The name of the saved report instance. |
|
Is Drilldown |
Indicates if the report is a drilldown from a parent report. |
|
Last Run By |
The login name of the user who last ran the report. |
|
Run Count |
Total number of times the report was run. |
|
Max Execution Time |
The maximum amount of time the report has taken to run. |
|
Avg Execution Time |
The average amount of time the report has taken to run. |
|
Max DB Time |
The maximum amount of time used to access the Portal database. |
|
Avg DB Time |
The average amount of time used to access the Portal database. |
|
Last Run Time |
The date and time the report was last run during this time period. |
|
First Run Time |
The date and time the report was last run during this time period. |