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
