Suad wrote:
> select node_name,sum(physical_mb) as "Physical MB" from occupancy
> group by node_name order by "Physical MB" desc

Exactly, thank you :-)  I hadn't noticed the occupancy table; I'd got
as far as    select object_id from backups where node_name='whatever'
and was wondering how to turn object_id into bytes...  Thanks again,

Regards, Peter

AUS/TAS/DPIW/CIT/Servers hbt/lnd/l8   6233 3061   http://www.pjb.com.au
Pasari, pasarimos    dice el agua    y canta la verdad contra la piedra
 -- Pablo Neruda