-----Gary Lee wrote: -----

>Tsm server 5.5.4.
>
>Windows client 6.3.0
>Will the following select show me all backups at and below the
>designated subdirectory?
>
>select * from backups where node_name='CASTSTORAGE' AND -
>upper(hl_NAME) like '\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE
>STUDY'
>
>If not, where have I gone wrong?

Selects against the Version 5 'backups' table tend to be very
time consuming. It would almost certainly be faster to use client
facilities to find the backup files. Note that a TSM administer
with system privilege can do this from a Windows system other
than the one the files came from.

Thomas Denier
Thomas Jefferson University Hospital