Client Metrics Report (67954)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Database Tables Tools >

Client Metrics Report (67954)

Beginning with EQuIS Version 6.3, the results generated for ALS users are limited to their subscribed or granted facilities over Professional or Enterprise (with at least Viewer permission for Enterprise). If users log in to Professional as a facility group, the report returns 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 generated as well. It also summarizes the information of EDD, Reports, and EIA activities in the months selected by users.

 

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

 

Notes:

Other DT_/AT_Records of each facility does 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

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Date Range (ignore day)



Start


End

Include Facility Code


                                               

30025-input.param.scrnsht

FACILITY_ID

# LOCATIONS

# SAMPLES

# TESTS

# RESULTS

# WATER, LEVELS,

# LOCATION PARAMETERS

# SAMPLE PARAMETERS

# Other DT/AT_VALUES

# RT_VALUES

# FILES

# FILE KB

LOC_TYPE

# 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

 

30025-ex.output1_zoom84

 

30025-ex.output2_zoom98

 

30025-ex.output3_zoom83

 

30025-ex.output4_zoom73

 

30025-ex.output5_zoom81

 

EarthSoft.Reports.Library._67954.ClientMetrics