you can use a select * from backups where node_name='NODENAME' and type=file           
  or
select * from archives where node_name='NODE_NAME' and type=file

This will list only the files and not each directory.  Hope this helps.

T

-----Original Message-----
From: Herkenrath, Wolfgang [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 6:21 AM
To: [EMAIL PROTECTED]
Subject: AW: AW: Listing of all Backups and Archives


Hi,

well, it's not my decision ;-)

I need all files from all clients. At the meantime I think I have to do it with a 
select for the occupancy. Correct me if I'm wrong.

Wolfgang

-----Ursprüngliche Nachricht-----
Von: Christian Svensson [mailto:[EMAIL PROTECTED] 
Gesendet: Montag, 10. März 2003 13:00
An: [EMAIL PROTECTED]
Betreff: Re: AW: Listing of all Backups and Archives



                                                                       
                                                                       
                                                                       


Hi!
I can not help you if you going to move from TSM to NetBackup. I´m just jokeing! ;-)

Do you only want to see the files who going to expire or all files?

Med Vänliga Hälsningar/Best Regards
Christian Svensson

-------------------------------------------------------------------------------

Cristie Nordic AB
Box 2
SE-131 06 Nacka
Sweden

Phone : +46-(0)8-718 43 30
Mobil : +46-(0)70-325 15 77
eMail : [EMAIL PROTECTED]
MSN : [EMAIL PROTECTED]


                                                                       
                      "Herkenrath,                                     
                      Wolfgang"                To:       [EMAIL PROTECTED]
                      <Wolfgang.               cc:                     
                      [EMAIL PROTECTED]          Subject:  AW: Listing of all Backups 
and Archives
                      DE>                                              
                      Sent by: "ADSM:                                  
                      Dist Stor                                        
                      Manager" <ADSM-                                  
                      [EMAIL PROTECTED]>                                 
                                                                       
                                                                       
                      2003-03-10 12:08                                 
                      Please respond to                                
                      "ADSM: Dist Stor                                 
                      Manager"                                         
                                                                       
                                                                       




Hi Cristie,

thanks for answer.
I need information for all files and when they will expire. For sure, it will be a 
large list. My company will replace TSM with NetBackup :-((((( So I need the 
information, wich data are at my TSM.

Wolfgang

-----Ursprüngliche Nachricht-----
Von: Christian Svensson [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 10. März 2003 11:23
An: [EMAIL PROTECTED]
Betreff: Re: Listing of all Backups and Archives








Hi Wolfgang!
Everything is possible to do. Becuse you have all the information in the databas. So 
if you just use a select command you can get any information you want. But do you want 
information for each file or do you want information how much who going to expire in 
the closest 24 hours on each filespace or on each node?

Med Vänliga Hälsningar/Best Regards
Christian Svensson

-------------------------------------------------------------------------------


Cristie Nordic AB
Box 2
SE-131 06 Nacka
Sweden

Phone : +46-(0)8-718 43 30
Mobil : +46-(0)70-325 15 77
eMail : [EMAIL PROTECTED]
MSN : [EMAIL PROTECTED]



                      "Herkenrath,
                      Wolfgang"                To:       [EMAIL PROTECTED]
EDU
                      <Wolfgang.               cc:
                      [EMAIL PROTECTED]          Subject:  Listing of all
Backups and Archives
                      DE>
                      Sent by: "ADSM:
                      Dist Stor
                      Manager" <ADSM-
                      [EMAIL PROTECTED]>


                      2003-03-10 11:17
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






Hi all,

is there a way to create a list of all backups and archives and there expiration date? 
I mean all backups and archives for all clients. I think it could be possible to do 
this with an SQL-script, but I'm not sure. And if it is possible, does anyone has such 
a script. I don't want to invent the wheel again.

THX

Wolfgang

Reply via email to