ADSM-L

Re: Select list of files backed up/archived on tsm?!?

2004-05-21 07:57:14
Subject: Re: Select list of files backed up/archived on tsm?!?
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 21 May 2004 07:57:07 -0400
...
>select * from backups where node_name='CHSU050', but that doesn't give me
>the actual name of the file, it just gives high level and low level. ...

FILESPACE_NAME + HL_NAME +  LL_NAME constitute the full path spec of the file.
The Select is not withholding anything.
You can do like  select concat(HL_NAME, LL_NAME) from backups
to stick those two components together.

   Richard Sims

<Prev in Thread] Current Thread [Next in Thread>