Here's a select command that will show you all volumes that a client's data
is on for a given storage pool. The only problem with it is that it shows
both active and inactive files, but at least you've got a list of tapes for
that client (many of which you won't need unless you are doing a PIT
restore).
select distinct node_name, volume_name from volumeusage where
node_name='NODENAME' and stgpool_name='STGPOOLNAME'
Laura G. Buckley
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719)531-5133, FAX (719)260-5991
buckley AT storsol DOT com
www.storsol.com
|