Hi Vincent, Sorry for the slow response.
No, I don't know a way to access the real tables but I saw somebody else suggested using ODBC. Best regards, Alexander > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Vincent RATAJSZCZAK > Sent: Monday, June 26, 2006 5:13 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Réf. : Re: [ADSM-L] tape content with backup date > > 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 > > >