-----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
