Hi, I once needed to know which server backed up files larger x bytes. I used a two phase approach. 1) Find the tapes that where written during last nights backup with SKRIPT 1 (thats the one I attached in my previous post). 2) Run SKRIPT 2 with every volume listed by SKRIPT 1
select node_name as Node, - filespace_name as Filespace,- file_name as Filename,- file_size as Size - from contents - where volume_name='$1' and - file_size>$2 This might be a starting point for you. If you need to know the axact time of backup you have to look into the BACKUPS table - but queries on this table can run forever. Thomas -----Ursprüngliche Nachricht----- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Joni Moyer Gesendet: Mittwoch, 22. März 2006 17:06 An: [email protected] Betreff: Re: [ADSM-L] AW: [ADSM-L] Find what tape a particular backup resides on Thanks! I guess my problem is I still need to know the filespace_name, the volume_name, filespace_id and the date it was written to so I think I have to combine 2 tables: volumeusage & volumes and I can't get the command to work. Any ideas anyone? ******************************** Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED] ********************************
