Re: Réf. : Re: [ADSM-L] tape content with backup date

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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
vincent.ratajszczak AT RTE-FRANCE DOT COM
Sent: Monday, June 26, 2006 11:13 AM
To: ADSM-L AT VM.MARIST DOT 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 <alexander AT SARA DOT NL> Envoyé par : "ADSM: Dist Stor
Manager" <ADSM-L AT VM.MARIST DOT EDU>
26/06/06 16:02
Veuillez répondre à "ADSM: Dist Stor Manager"

 
        Pour :  ADSM-L AT VM.MARIST DOT 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of Vincent RATAJSZCZAK
> Sent: donderdag 22 juni 2006 18:07
> To: ADSM-L AT VM.MARIST DOT 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
>