This report is generated on demand whenever needed by Harold MacBeth at the USGS.
Log as dcmgr on transform and go to /home/dcmgr/misc.
Run AQMS_SQL.pl with the desired dates.
[dcmgr@transform misc]$ ./AQMS_SQL.pl -h
AQMS_SQL.pl version 1.0 (2016/08/18)
AQMS_SQL.pl - Queries for Hal (annual report).
Syntax: AQMS_SQL.pl [-h] -s start_date -e end_date
where:
-h Help - prints this help message.
-s Start date - YYYY/MM/DD
-e End date - YYYY/MM/DD
[dcmgr@transform misc]$ ./AQMS_SQL.pl -s 2020/01/01 -e 2020/04/01
...