Hi Gerhard,

I was not paying as close attention as I should to what I was typing. You
are correct.

Thanks for catching this.   :-)

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-03-01
00:27:36:

> Andrew Raibeck wrote:
>
>  > Hi Eric,
>  >
>  > For your example, \\MOLSON\C$\DATA\status.txt, the correct criteria
would
>  > be:
>  >
>  >    filespace_name='\\MOLSON\C$' and
>  >    hl_name='\DATA\' and
>  >    ll_name='STATUS.TXT'
>  >
>  > For Windows, note that:
>  >
>  > - All components are stored in upper case, regardless of how they
appear
>  > on the client machine.
>
> Hmm, my filespace_names are in lower case:
> Node Name           Filespace       FSID     Platform     Filespace
>                      Name                                  Type
> ---------------     -----------     ----     --------     ---------
> CC.AMSEL            \\amsel\c$         1     WinNT        NTFS
>
>  >
>  > - The hl_name begins and ends with a backslash (unless it is the
drive
>  > root, in which case there is only one backslash).
>  >
>  > - When you concatenate filespace_name, hl_name, and ll_name, they
should
>  > form a proper path.
>  >
>  > Regards,
>  >
>  > Andy
>  >
>  > P.S. Suggestion: Selecting from the BACKUPS table can take a very
long
>  > time. If you plan to do a lot of data mining from it, consider
selecting
>  > all output from the table and redirecting to a file (make sure you
have
>  > tons of free disk space), then use an external tool to mine the data.
>  >
>  > Andy Raibeck
>  > IBM Software Group
>  > Tivoli Storage Manager Client Development
>  > Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
>  > Internet e-mail: storman AT us.ibm DOT com
>  >
>  > The only dumb question is the one that goes unasked.
>  > The command line is your friend.
>  > "Good enough" is the enemy of excellence.
>  >
>  > "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-02-27
>  > 17:54:07:
>  >
>  >
>  >>This is something I was also looking for.
>  >>Normally I go to the client machine and query the backups to see the
>  >>history of a file.
>  >>From what I can tell and I'm not very good at the "select" SQL
>  >>statements is the following a correct interpretation of the statement
if
>  >>I was looking for a single files backups.
>  >>----------------------------------------------
>  >>Select * from backups where node_name='MOLSON" and
>  >>FILESPACE_NAME='\\MOLSON\C$' and HL_NAME='C:\DATA\' and ll_name like
>  >>'status.txt'
>  >>--------------------------------------
>  >>MOLSON - client node
>  >>FILESPACE_NAME - FILESPACE where file is located
>  >>HL_NAME - Directory where file is located
>  >>ll_name - actual file you are looking for
>  >>
>  >>Thanks
>  >>Eric
>
> --
> _____________________________________
> eMail: gerhard.ginzler AT meduniwien.ac DOT at
> tel: +43 1 40160-21209
> IT Systems & Communications (ITSC)
> Medizinische Universitaet Wien
> Spitalgasse 23, A-1090 WIEN