afsdb-reports Change History

1.26 (2010-07-07)

Bump large access count report to 10 million

We have lots of volumes that regularly get over one million accesses.

Lines changed: +3 -3

1.25 (2008-03-06)

Removed testing address.

Lines changed: +2 -3

1.24 (2008-03-05)

Case-sensitve match for the "RW volumes relocated" report.

Lines changed: +3 -2

1.23 (2008-02-22)

Added case sensitivity to a GROUP BY statement, where things such as group.SAY and group.say were considered the same.

Lines changed: +2 -2

1.22 (2008-02-22)

Change to the "new changes to unreleased changes" metric, to make sure we get distinct rows.

Lines changed: +2 -2

1.21 (2008-01-31)

Changed SQL statments to run sanely under MySQL.

Lines changed: +99 -66

1.20 (2008-01-23)

Updated AFS reporting scripts for lsdb-new, with changed ID strings for cvs export for Debian packaging, code cleanup, and changes to work with newer Stanford::LSDB for MySQL.

Lines changed: +8 -6

1.19 (2005-02-03)

Add a copyright statement at the top of the script as well.

Lines changed: +4 -1

1.18 (2005-02-03)

Use the latest version printing code and add a COPYRIGHT AND LICENSE section.

Lines changed: +12 -2

1.17 (2005-02-03)

Add a link to the distribution web page.

Lines changed: +6 -1

1.16 (2005-02-03)

Minorly obscure the afs-reports e-mail address since this is going up on the web.

Lines changed: +5 -5

1.15 (2005-02-01)

Modify the query for 1000 volumes to use the new partition_count view that includes the volume type and handle both RW and RO types.

Lines changed: +3 -3

1.14 (2005-02-01)

Use the view name volume_count rather than double_volumes.

Lines changed: +2 -2

1.13 (2005-01-31)

We don't care about additions and deletions of backup volumes, and we don't care about growing volumes of type other than RW.

Lines changed: +6 -3

1.12 (2005-01-25)

Helpful to only grab those volumes from double_volumes where count > 1. Otherwise, you get every volume in the cell, which makes for a long report.

Lines changed: +3 -2

1.11 (2005-01-25)

When selecting from partition_count, you can just select out the count; you don't need count(*).

Lines changed: +2 -2

1.10 (2005-01-25)

Send mail to afs-reports at stanford.edu rather than afs-reports@lists.

Lines changed: +4 -4

1.9 (2005-01-25)

Only report on volumes that grew by 200MB, not just 50MB. Report on any duplicated volumes and on any server/partition pairs with more than 1000 volumes on them.

Lines changed: +33 -15

1.8 (2004-10-08)

Remove unnecessary error handling now that Stanford::LSDB always sets RaiseError. Use SQL parameters wherever possible rather than interpolating strings into the SQL block.

Lines changed: +3 -6

1.7 (2004-03-08)

Add a report for volumes with over one million accesses, and remove the report about people who are over quota by more than 50MB.

Lines changed: +19 -20

1.6 (2003-11-06)

use afs-reports at lists.stanford.edu

Lines changed: +3 -3

1.5 (2003-03-07)

Make -h work more reliably and fix a documentation paste mistake.

Lines changed: +5 -5

1.4 (2001-11-29)

Send the report mail from root, and only send mail if asked to send mail.

Lines changed: +10 -7

1.3 (2001-11-09)

Add the ability to send mail to afs-reports, add command-line parsing, and add documentation.

Lines changed: +82 -1

1.2 (2001-11-08)

Working version, still sending reports to stdout. It works much better now, but it doesn't print out as many nice headings.

Lines changed: +32 -44

1.1 (2001-10-31)

Initial version, sending the report to stdout. We think that it works, but we're not really sure yet. But it prints out nice headings.