You'll get much better results doing this from the client.
Use Query Backup with the -inactive and -su=yes switches from the root of each filesystem/drive/volume.
Ted
At 07:32 AM 5/21/2004, you wrote:
Hey everyone!
I have a quick question. I am trying to find the file names of all files backed up or archived for a particular node on my tsm server. I have already issued
select * from backups where node_name='CHSU050', but that doesn't give me the actual name of the file, it just gives high level and low level. Does anyone know of such a select statement? Thanks for your help! I'm kind of in a bind for time, so any help is appreciated!
******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ********************************
