2010-06-28:
Reporting on software downloads
Downloads.mit.edu is accessible only through VPN using SecureCRT.
The downloads database is only accessible through mysql while logged on to that server.
It is possible to formulate relatively simple sql scripts that extract useful fields from the download_log table and excerpt them into a file. That file can then be ftp'd with SecureFX (launched from SecureCRT) out of downloads.mit.edu over to your own PC.
TEE downloads-2010-06.txt ;
SELECT download_date, download_uri, user_id, user_class, user_affiliation, ip_address, user_agent
FROM download_log
WHERE download_date BETWEEN
'2010-06-01' AND '2010-06-30'
;
NOTEE ;
This one will summarize the download counts per filename:with a within-the-month date stamp
TEE temp/downloads-summary-2010-06.txt ;
select download_uri, count(*), download_date from download_log
WHERE download_date BETWEEN
'2010-06-01' AND '2010-06-30'
group by download_uri ;
notee ;