Report of Reports

Report Name: Report of Reports

File Name: EarthSoft.Reports.Library.48827.dll

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

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 usage, this report should be published to the database. The report will be available for selection once it has been published.

•For Professional usage, this report should be published to the database or have the .dll added to the local '.../Earthsoft/EQuIS/' folder.

Overview:

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.

Source Tables: ST_NOTICE, ST_REPORT, ST_REPORT_EVENT, ST_REPORT_TASK, ST_REPORT_USE, ST_USER, ST_USER_NOTICE, ST_USAGE

Report Parameters

Facility	Parameter for selecting the facility
Date Range
Start	Select a start date.
End	Select an end date.

1Excel report output requires a valid license of Microsoft Excel to view the output.