• This tool generates information about BK/BP sites as well as all stations archived at the NCEDC. It is needed for reports like the USGS Network Coop one.
• Log as dcmgr on transform and go to /home/dcmgr/misc.
• Run Network_SQL.pl with the desired dates.

[dcmgr@transform misc]$ ./Network_SQL.pl 
- Total no. of stations operated and/or recorded (BK,BP): 133
- Total no. of stations operated and/or recorded (All): 2261

- Total no. of channels recorded (BK,BP): 5837
- Total no. of channels recorded (All): 22411

- No. of short-period (SP) stations (BK,BP): 37
- No. of short-period (SP) stations (All): 1066

- No. of broadband (BB) stations (BK,BP): 95
- No. of broadband (BB) stations (All): 282

- No. of strong motion (SM) stations (BK,BP): 111
- No. of strong motion (SM) stations (All): 1176

- No. of stations maintained & operated by network: 133

- No. of stations maintained & operated as part of ANSS: 133
[dcmgr@transform misc]$