I use this script. This will gove you the total size of each storage
pool. 
 select stgpool_name as "Storage Pool",sum(num_files) as "Number of
Files", sum(logical_mb)/1024 as "Total PhysicalGBs" from occupancy group
by stgpool_name 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lee, Gary D.
Sent: Wednesday, July 02, 2008 9:30 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] How to verify storage pool backup

Is there a practical way to verify that all contents of storage pools
have been backed up?

It looks as if it would be unwise to try checking each individual file,
however, I need this to show management that we are taking dr seriously.

Thank you for your time and consideration.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310