Client Metrics Report (67954)
Copyright © 2019 EarthSoft, Inc • Modified: 31 Jul 2019
Beginning with EQuIS Version 6.3, the results generated for ALS users are limited to subscribed or granted facilities over Professional or Enterprise (with at least Viewer permission for Enterprise). Log in to Professional as a facility group, the report will return results only from the facilities in the group.
Report Name: Client Metrics Report (67954)
Report Type: Standard
Description: The Client Metrics Report summarizes how many records are available in several main tables, how many total records in the DT_/AT_/RT_ tables of each facility listed in DT_FACILITY are in the EQuIS Database, and the number of records in the tables without the FACILITY_ID field in the DT_/AT_/RT_ tables. The summary of the DT_/AT_/RT data associated to the facilities that are not listed in DT_FACILITY is also generated. Information of EDD, Reports, and EIA activities in the months selected by users is also summarized.
As of EQuIS Version 6.4, the report includes an option to include Logger Data in the output. If checked, two additional worksheets, Logger Monthly Statistics and Logger Facility Totals, are populated with statistics from DT_LOGGER, DT_LOGGER_SERIES and DT_LOGGER_DATUM.
The Logger Monthly Statistics worksheet includes results from all facilities, including FACILITY_ID=null for EQuIS Professional Database level users; results [...] are included only for subscribed facilities for Enterprise Application Level Security users. Statistics are based on loggers for which there are records in DT_LOGGER_DATUM within the selected date range as indicated below.
•Number of Loggers: DT_LOGGER.LOGGER_CODE
•Number of Locations with Loggers: number of locations associated with the logger output (DT_LOGGER.SYS_LOC_CODE)
•Number of Logger Series: DT_LOGGER_SERIES.LOGGER_SERIES_ID (each may occur on multiple dates)
•Number of Logger Records: DT_LOGGER_DATUM
•Other DT_/AT_Records of each facility do not include the records of the DT_ and AT_ tables that are already listed in the reports such as DT_FACILITY, DT_LOCATION, DT_SAMPLE, DT_TEST, DT_RESULT, DT_WATER_LEVEL, DT_LOCATION_PARAMETER, DT_SAMPLE_PARAMETER and DT_FILE.
•The Date Range on the user interface is used to generate monthly statistical results of Enterprise usage during the user selected date range.
Report Dependencies: There are no dependencies for this report.
File Name: EarthSoft.Reports.Library.67954
Input Parameters: A selection made to customize the output of a report.
Input Parameter Screenshot
# WATER, LEVELS,
# LOCATION PARAMETERS
# SAMPLE PARAMETERS
# Other DT/AT_VALUES
# FILE KB
# TOTAL EDDS
# ENTERPRISE EDDS
# ENTERPRISE EDDS ACCEPTED
# ENTERPRISE EDDS REJECTED
# TOTAL REPORTS EXECUTED
# DISTINCT USERS
# DISTINCT REPORTS
# EIAS EXECUTED
# EIA REPORTS GENERATED
# S USER
# DISTINCT LICENSE USERS
# DISTINCT APPS
Tables: DT_/AT_/RT_ tables
Database Type: SQL
Database Schema: Standard (no custom or add-on schemas required)
Database Version: EQuIS 5.5+
Data Requirements: N/A
Output Type: Excel
Example Output: View the following examples or download the Client Metrics Report_20130604010513.xlsx