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