Versions Compared

Old Version 1

changes.mady.by.user Robert W Smyser

Saved on

compared with

New Version 2

changes.mady.by.user Robert W Smyser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Reporting on software downloads

"Simple Downloads"

Complex Downloads

Downloads.mit.edu is accessible only through VPN using SecureCRT.

...

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.

Panel

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

...