Is it possible to answer the question "How much (Mb) data that is over 1
year old is stored on my server?"?
The way I see this working is by joining the BACKUPS and CONTENTS tables.
The problem is that the join between these two tables cannot be perfectly done.
You cannot differentiate between ACTIVE and INACTIVE in the CONTENTS table,
so that if you had three versions in the BACKUPS table, you would match each
of these three times in the contents table (cartesian product?) (This has
been discussed by Reinhard Mersch u.a. earlier on this list.)
Another way could be by using the OBJECT_ID field from BACKUPS and
awk/pipe/whatever it into a SHOW INVO command (for all 60 zillion backup 
objects over
a year old!) and then awk out the sizes.
Has anyone any ways round these "problems" or any other suggestions?

Paul.

--
Sent through GMX FreeMail - http://www.gmx.net
Sent through GMX FreeMail - http://www.gmx.net