Use TSM�s commands to list the LiteSpeed backup files. Open a TSM Administrative Command Line on the TSM server. then to see all of the volumes type:
tsm: BLOCK_SERVER1>query Volume *
Volume Name Storage Device Estimated Pct Volume
Pool Name Class Name Capacity Util Status
------------------------ ----------- ---------- --------- ----- --------
C:\TSMDATA\SERVER1\0000- FILPOOL1 FILEDEV1 25.0 36.1 Filling
0003.BFS
C:\TSMDATA\SERVER1\DISK- DISKPOOL DISK 5,000.0 0.0 On-Line
1.DSM
C:\TSMDATA\SERVER1\DISK- DISKPOOL DISK 1,000.0 0.0 On-Line
2.DSM
Then choose the destination volume for the SQLLiteSpeed backups, based on the storage pool assigned to the client node for the connection and run a query contents on that.
Example:
tsm: BLOCK_SERVER1>query CON "C:\TSMDATA\SERVER1\00000003.BFS" NODE=block FI=SLS_Russel-October
Node Name Type Filespace FSID Clients Name for File
Name
--------------- ---- ---------- ---- --------------------------------------
BLOCK Bkup SLS_Russe- 1 \Northwind\ (Full_10_24_2006_16_00)_d- l-October ata
BLOCK Bkup SLS_Russe- 1 \Northwind\ (Full_10_24_2006_16_00)_x- l-October mlData
BLOCK Bkup SLS_Russe- 1 \Northwind\ (Full_10_24_2006_16_00)_h- l-October eaderInfo
BLOCK Bkup SLS_Russe- 1 \pubs\ (24)Tuesday_16:25_data l-October
BLOCK Bkup SLS_Russe- 1 \pubs\ (24)Tuesday_16:25_xmlData l-October
BLOCK Bkup SLS_Russe- 1 \pubs\ (24)Tuesday_16:25_headerInfo l-October
BLOCK Bkup SLS_Russe- 1 \pubs\ (25)Wednesday_15:06_data l-October
BLOCK Bkup SLS_Russe- 1 \pubs\ (25)Wednesday_15:06_xmlData l-October
BLOCK Bkup SLS_Russe- 1 \pubs\ (25)Wednesday_15:06_headerInfo l-October
BLOCK Bkup SLS_Russe- 1 \Northwind\ (Full_10_26_2006_11_15)_d- l-October ata
BLOCK Bkup SLS_Russe- 1 \Northwind\ (Full_10_26_2006_11_15)_x- l-October mlData
BLOCK Bkup SLS_Russe- 1 \Northwind\ (Full_10_26_2006_11_15)_h- l-October eaderInfo
BLOCK Bkup SLS_Russe- 1 \Northwind\ abc_data l-October
BLOCK Bkup SLS_Russe- 1 \Northwind\ abc_xmlData l-October
BLOCK Bkup SLS_Russe- 1 \Northwind\ abc_headerInfo l-October
BLOCK Bkup SLS_Russe- 1 \Northwind\ Northwind.sls_data l-October
BLOCK Bkup SLS_Russe- 1 \Northwind\ Northwind.sls_xmlData l-October
BLOCK Bkup SLS_Russe- 1 \Northwind\ Northwind.sls_headerInfo l-October
tsm: BLOCK_SERVER1>
Also, the user can just run xp_view_tsmcontents.
For additional information, see
https://support.quest.com/SUPPORT/index?page=solution&id=SOL22650