On 29 June 2011 13:39, Tim Brown <[email protected]> wrote: > Is there a select statement that will list all tape volumes that have files > for > > a given TSM node. > > select distinct VOLUME_NAME,STGPOOL_NAME from volumeusage where NODE_NAME='XXXX'
XXXX = the node name in upper case. It also returns the stgpool name as well. Steven
