Search a file for a specific node on the TSM server:
<code>
tsm: TSM1>select * from backups where node_name='AVALOQPROD_ITSM' and ll_name='AVALIV_sbmdqfo1_1'  

      NODE_NAME: AVALOQPROD_ITSM
 FILESPACE_NAME: /tsmorc
   FILESPACE_ID: 1
          STATE: ACTIVE_VERSION
           TYPE: FILE
        HL_NAME: //
        LL_NAME: AVALIV_sbmdqfo1_1
      OBJECT_ID: 801171339
    BACKUP_DATE: 2011-06-01 18:31:30.000000
DEACTIVATE_DATE: 
          OWNER: oracle
     CLASS_NAME: MC_ORACLE_ITSM

 	

tsm: TSM1>select * from backups where node_name='BENJAMIN' and filespace_name='\\benjamin\c$'
	
	
      NODE_NAME: BENJAMIN
 FILESPACE_NAME: \\benjamin\c$
          STATE: ACTIVE_VERSION
           TYPE: DIR
        HL_NAME: \
        LL_NAME:
      OBJECT_ID: 6145
    BACKUP_DATE: 2002-12-30 08:29:29.000000
DEACTIVATE_DATE:
          OWNER:
     CLASS_NAME: STANDARD

      NODE_NAME: BENJAMIN
 FILESPACE_NAME: \\benjamin\c$
          STATE: ACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: 1-3200201.PRT
      OBJECT_ID: 6176
    BACKUP_DATE: 2002-12-30 08:29:29.000000
DEACTIVATE_DATE:
          OWNER:
     CLASS_NAME: DEFAULT
</code>

List the content of a TSM volume:
<code>
tsm: TSM1>select * from contents where volume_name='501245'

      VOLUME_NAME: 501245
        NODE_NAME: AVALOQPROD_ITSM
             TYPE: Bkup
   FILESPACE_NAME: /tsmorc
        FILE_NAME: //AVALIV_g6m0ufb2_1
       AGGREGATED: No
        FILE_SIZE: 2957235626
          SEGMENT: 1/1          
           CACHED: NO
     FILESPACE_ID: 1
FILESPACE_HEXNAME: 2F74736D6F7263
     FILE_HEXNAME: 2F2F4156414C49565F67366D30756662325F31
       BITFILE_ID: 677419256
        OBJECT_ID: 677419256
           COPIED: No
          DAMAGED: Yes

      VOLUME_NAME: 501245
        NODE_NAME: AVALOQPROD_ITSM
             TYPE: Bkup
   FILESPACE_NAME: /tsmorc
        FILE_NAME: //AVALIV_g7m0ufb2_1
       AGGREGATED: No
        FILE_SIZE: 2793244785
          SEGMENT: 1/1          
           CACHED: NO
     FILESPACE_ID: 1
FILESPACE_HEXNAME: 2F74736D6F7263
     FILE_HEXNAME: 2F2F4156414C49565F67376D30756662325F31
       BITFILE_ID: 677419257
        OBJECT_ID: 677419257
           COPIED: No
          DAMAGED: Yes

      VOLUME_NAME: 501245
        NODE_NAME: AVALOQPROD_ITSM
             TYPE: Bkup
   FILESPACE_NAME: /tsmorc
        FILE_NAME: //AVALIV_g9m0ufb2_1
       AGGREGATED: No
        FILE_SIZE: 2006986989
          SEGMENT: 1/1          
           CACHED: NO
     FILESPACE_ID: 1
FILESPACE_HEXNAME: 2F74736D6F7263
     FILE_HEXNAME: 2F2F4156414C49565F67396D30756662325F31
       BITFILE_ID: 677419258
        OBJECT_ID: 677419258
           COPIED: No
          DAMAGED: Yes
</code>