Thank's Alexander for your help Do you know a solution to have direct access to the TSM tables, or do I have to forget it ?
Any IBM tech guy around here to confirm if it is or not possible to get the results ? Regards Vince Alexander Verkooijen <[EMAIL PROTECTED]> Envoyé par : "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 26/06/06 16:02 Veuillez répondre à "ADSM: Dist Stor Manager" Pour : ADSM-L@VM.MARIST.EDU cc : (ccc : Vincent RATAJSZCZAK/INFOGER/GRT/FR) Objet : Re: [ADSM-L] tape content with backup date If you had access to the *real* tables that reside in the TSM databse then, yes, it would be possible. Since the SQL interface only provides access to *pseudo* tables I don't think it's possible. Please correct me if I'm wrong. In the past there have been times when I could have used a list like this. Regards, Alexander ------------------------------------------------------------ Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing & Networking Services > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Vincent RATAJSZCZAK > Sent: donderdag 22 juni 2006 18:07 > To: ADSM-L@VM.MARIST.EDU > Subject: tape content with backup date > > Dear lovely TSM World, > > I have a special request for you... > > I would like to list the content of a specific tape (destroyed) with a > column with the backuped date of the objet. > > ==> "Q content XXX" is poor > > ==> "select * from contents where volume_name=XXXX" give me > Node_name/File_name, but no backuped date > > ==> "select * from backups" give me Node_name/File_name and backuped > date, but no tape affectation > > > Between the 2nd and 3rd, I can't find a common field to join > the tables > > > Anyone could help me please ? > > Do you think it's possible ? > > The restore GUI show you the file name and backuped date, so > I think YES, > but.... > > Thank's > > Vince >