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 >