AW: [ADSM-L] AW: [ADSM-L] Find what tape a particular backup resides on
2006-03-22 11:16:50
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:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag
von Joni Moyer
Gesendet: Mittwoch, 22. März 2006 17:06
An: ADSM-L AT VM.MARIST DOT EDU
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
joni.moyer AT highmark DOT com
********************************
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- AW: [ADSM-L] AW: [ADSM-L] Find what tape a particular backup resides on,
Thomas Rupp <=
|
|
|