Report Name: Report of Reports
File Name: EarthSoft.Reports.Library.48827.dll
Dependencies: Licensed SPM and SPM Schema
Source: SPM install
Output Type: Excel1
Description: The Report of Reports compiles information about reports run in EQuIS Professional and Enterprise as well as EQuIS Information Agents (EIAs) run in EQuIS Enterprise.
Installation Instructions: This report requires a licensed SPM and the SPM Schema applied to the database. For SPM usage, no additional steps are necessary. For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.
The report contains two output sections: "Reports Run by User" and "EIA Summary".
The Reports Run by User section contains ST_USER.USER_NAME, ST_REPORT.DISPLAY_NAME, and the number of times the user ran the report within the specified date range for each unique user/report combination.
The EIA Summary section contains ST_USER.USER_NAME, ST_USER_REPORT.NAME, ST_REPORT_EVENT.REMARK, the number of notifications delivered within the date range, the last delivered date, and the last read date for each unique user/EIA combination.
Tables: ST_NOTICE, ST_REPORT, ST_REPORT_EVENT, ST_REPORT_TASK, ST_REPORT_USE, ST_USER, ST_USER_NOTICE, ST_USAGE
1Excel report output requires a valid license of Microsoft Excel to view the output.
Copyright © 2020 EarthSoft, Inc • Modified: 23 Jul 2020