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 |
storman AT us.ibm DOT 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 AT vm.marist DOT edu> wrote on 2013-05-07
09:03:11:

> From: "Lee, Gary" <GLEE AT BSU DOT EDU>
> To: ADSM-L AT vm.marist DOT edu,
> Date: 2013-05-07 09:10
> Subject: select question on backups table
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT 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?
>