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:ads...@vm.marist.edu] On Behalf Of Arthur Poon Sent: 29 May 2009 16:43 To: ADSM-L@VM.MARIST.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:ads...@vm.marist.edu] On Behalf Of Christian Svensson Sent: Thursday, May 28, 2009 11:00 PM To: ADSM-L@VM.MARIST.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.svens...@cristie.se Skype: cristie.christian.svensson ________________________________________ Från: ADSM: Dist Stor Manager [ads...@vm.marist.edu] för Arthur Poon [ap...@modestogov.com] Skickat: den 29 maj 2009 00:37 Till: ADSM-L@VM.MARIST.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