Query backupset

--
Joshua S. Bassi
IBM Certified - AIX 4/5L, SAN, Shark
Tivoli Certified Consultant - ADSM/TSM
eServer Systems Expert -pSeries HACMP

AIX, HACMP, Storage, TSM Consultant
Cell (831) 595-3962
jbassi AT ihwy DOT com


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Coats, Jack
Sent: Thursday, September 19, 2002 2:33 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: How can I tell what tapes are in a BackupSet?

Anyone have a suggestion for a select statement that could return this a
list of the tapes in each BackupSet that is still active?