ST_USAGE tracks the use of EQuIS objects and processes such as EDDs loaded, DQM events created, and reports run. More information on the activities tracked is provided in the next section.
Columns in the ST_USAGE table include user and object references, start & end dates, record counts, action types, HTTP Uniform Resource Identifiers (URIs) associated with actions, the size in bytes of the action, facility, and, where applicable, the HTTP status code associated with the action.
ST_USAGE is used in the Report of Reports and User Activity Report, and data from ST_USAGE is used to generate the ST_REPORT_USE view (listed under Views, rather than System Tables). ST_REPORT_USE was a table in v6.x, but it was replaced with the broader ST_USAGE in v7.x, and a view of the former table was created for backwards compatibility.
For databases that are not hosted by EarthSoft, the following permissions must be granted to read only ALS roles (shown in example below as "EQuIS_ALS_ReadOnly") to ensure that usage from these users is written to the ST_USAGE table.
GRANT SELECT, INSERT, UPDATE ON dbo.st_usage TO [EQuIS_ALS_ReadOnly];
DENY DELETE ON dbo.st_usage TO [EQuIS_ALS_ReadOnly];
Below is a general summary of activities recorded in the ST_USAGE table:
•opening desktop EarthSoft applications/extensions
•running PowerShell scripts on the EQuIS database
•routine database statistics (e.g. size, record count, Enterprise processes/logging)
oopening tables and views in EQuIS Professional
ocreating, reopening, or completing a Data Quality Module (DQM) event
•EQuIS Data Processor (EDP) - loading EDDs
oaccessing dashboards and widgets
opreviewing, editing properties on, and downloading files
oopening facilities and facility groups
orunning reports or changing report parameters
ochanges to user settings or permissions
orunning EQuIS Information Agents (EIAs)
oworkflow service or W3WP activity
oquerying the map server
•EQuIS Live - Agent and logger activity
•Sample Planning Module (SPM)
oplan design and updates
oviewing or editing components in the SPM dashboard in Enterprise
otemplate usage, configuration, and publishing
odata loading and file creation
oform and report usage (mobile and web)
ogroup membership changes
oother required calls such as checking build or admin status
•REST API activity such as accessing permissionable objects (e.g. facilities, reports) or token assignment
Copyright © 2022 EarthSoft, Inc • Modified: 29 Oct 2021