Re: AW: AW: Listing of all Backups and Archives

[Richard Sims]

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.

You can do a Select on the Backups and Archives tables.
Archive expiration is easy, based upon archive date and retention.
For Backups, you need to look at the STATE value for Active, Inactive
and go from there.
I would not try to also Select on the management class, as hard-coding
those known values into your computation will save a lot of overhead.

  Richard Sims, BU

Viagra - just what the planet needed.

Re: AW: AW: Listing of all Backups and Archives

[Christian Svensson]

   
   
   


Hi!
That is one way to do it.
But you are lucky.  Becuse for a few days i go i create a select command
for one of our larges customers here in Sweden.
And they want to know how many files our Bare Metal Restore software
creating. And the select command to see all backup files is.

tsm: TESTDOMselect NODE_NAME as Node name, LL_NAME as Filename,
HL_Name as Path, Archive_date as Backup Date from archives group by
node_name, HL_Name, LL_Name, Archive_date

tsm: TESTDOMselect NODE_NAME as Node name, LL_NAME as Filename,
HL_NAME as Path, Backup_date as Backup Date from backups group by
node_name, HL_Name, LL_Name, Backup_date

Try this command. Maybe this help you.
If not. Send me a email and tell me more what you searching for.

This script you got right now is a request after Node name, Filename, Path
and Backup date.
And it´s sorted by 1)Node name 2)Path 3)Filename 4)Date.


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, 
  WolfgangTo:   [EMAIL PROTECTED]
  Wolfgang.   cc: 
  [EMAIL PROTECTED]  Subject:  AW: AW: Listing of all 
Backups and Archives
  DE  
  Sent by: ADSM:  
  Dist Stor
  Manager ADSM-  
  [EMAIL PROTECTED] 
   
   
  2003-03-10 13:21 
  Please respond to
  ADSM: Dist Stor 
  Manager 
   
   




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,
  WolfgangTo:   [EMAIL PROTECTED]
EDU
  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