Re: [ADSM-L] SV: List of files in filespace

I also find it helpful to use the ODBC driver to check out the table names in 
excel.

Thanks,
Mooney

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
David McClelland
Sent: Friday, May 29, 2009 12:16 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SV: List of files in filespace

Try 'BACKUPS', rather than 'BACKUP' as your table name and that should see
you right.

/David Mc
London, UK

http://www.linkedin.com/in/dmcclelland


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Arthur Poon
Sent: 29 May 2009 16:43
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] SV: List of files in filespace

When I execute the SQL statement I got the following errors

tsm: ADSMSERV>select filespace_name as filespace, hl_name as directory,
ll_names
               as file_name from backup where node_name='COMAPPS'
ANR2906E Unexpected SQL literal token - 'BACKUP'.

                                        |
         ...............................V...............................
         ry, ll_names as file_name from backup where node_name='COMAPPS'

ANS8001I Return code 3.

I am using TSM version 5.5 for both server and client on window platform.
Thanks.

AP

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Christian Svensson
Sent: Thursday, May 28, 2009 11:00 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] SV: List of files in filespace

Hi,
Yes you can, my way to do it is probably not the best one but it works.

Select filespace_name as Filespace, hl_name as Directory, ll_name as
Filename from backup where node_name='NODENAME'

But be careful to select from tablespace BACKUP because it's a lot of
information in their and it takes a wild to do a query from it.

Best Regards
Christian Svensson

Cell: +46-70-325 1577
E-mail: Christian.Svensson AT cristie DOT se
Skype: cristie.christian.svensson
________________________________________
Från: ADSM: Dist Stor Manager [ADSM-L AT VM.MARIST DOT EDU] f&#246;r Arthur Poon
[apoon AT MODESTOGOV DOT COM]
Skickat: den 29 maj 2009 00:37
Till: ADSM-L AT VM.MARIST DOT EDU
Ämne: List of files in filespace

Is there any way to list out all the file names from the filespace using the
TSM console?

AP

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.339 / Virus Database: 270.12.39/2134 - Release Date: 05/28/09
18:09:00