Salut Vincent, there is a way to access the SQL tables, you need the interface called ODBC, you can use that , with MS excell to go and poll the database for pretty much anything. I have to use it cause my Version of ADSM is on a VM server that has not been updated since 96, ODBC is a lifesaver. Au tous, Jeremy
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, June 26, 2006 11:13 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] 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 >