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

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:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf Of Vincent RATAJSZCZAK
> Sent: Monday, June 26, 2006 5:13 PM
> To: ADSM-L AT VM.MARIST DOT 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 <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
> > 
>