I have tried to get the following SELECT statement to work, and I know that there SHOULD BE some results :select volumeusage.volume_name,volumes.access,volumes.error_state,volumeusage.stgpool_name from volumeusage,volumes where volumeusage.node_name='*' and volumeusage.volume_name=volumes.volume_name order by volume_name - How to find all volumes which have data for a specific client, and their statusWhat I am trying to do is find out ALL the tapes that I would need in order to restore a client to its current state,in a disaster recovery scenario.This is a VERY important query, so if you can help me out, it would be greatly appreciated
OS LEVEL - 5.2.8TSM SERVER LEVEL - 5.3.3TSM CLIENT LEVEL - varies