Hi Gary, If this is a Windows client, you do not need to upper-case the HL_NAME as long as the actual pattern you specify is in upper case. This is because file system backups on Windows are always stored in upper case.
The HL_NAME specification should have a terminating backslash. If you want to see backups in subdirectories of ..\FATIGUE STUDY, then append a percent sign to the end of the HL_NAME specification. If you do not want to see the backups in subdirectories, then you can use '=' instead of 'like'. In sum: To see all objects in ..\FATIGUE STUDY but not in subdirectories: select * from backups where node_name='CASTSTORAGE' and hl_name = '\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY\' To see all objects in ..\FATIGUE STUDY and its subdirectories: select * from backups where node_name='CASTSTORAGE' and hl_name like '\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY\%' - Andy ____________________________________________________________________________ Andrew Raibeck | Tivoli Storage Manager Level 3 Technical Lead | stor...@us.ibm.com IBM Tivoli Storage Manager links: Product support: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager Online documentation: https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli Documentation Central/page/Tivoli Storage Manager Product Wiki: https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli +Storage+Manager/page/Home "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> wrote on 2013-05-07 09:03:11: > From: "Lee, Gary" <g...@bsu.edu> > To: ADSM-L@vm.marist.edu, > Date: 2013-05-07 09:10 > Subject: select question on backups table > Sent by: "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> > > 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? >