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
>