ST_USAGE

•Tracked Activities in ST_USAGE

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];

Tracked Activities in ST_USAGE

Below is a general summary of activities recorded in the ST_USAGE table:

•opening Windows applications/extensions from EarthSoft

•registration

•running PowerShell scripts on the EQuIS database

•routine database statistics (e.g. size, record count, Enterprise processes/logging)

•EQuIS Professional

oopening tables and views in EQuIS Professional

orunning reports

ocreating, reopening, or completing a Data Quality Module (DQM) event

•EQuIS Data Processor (EDP) - loading EDDs

•EQuIS Enterprise

oaccessing dashboards and widgets

opreviewing, editing properties on, and downloading files

oviewing folders

ousing formats

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

•EQuIS Collect

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