I use the follwoing statement in excel to return the volumehistory information
tied to the backupset information.
Notice it is keyed off of the date and time so it is possible (although rare) to
 get some invalid information.

SELECT VOLHISTORY.VOLUME_NAME, BACKUPSETS.NODE_NAME, BACKUPSETS.BACKUPSET_NAME,
BACKUPSETS.DATE_TIME, BACKUPSETS.RETENTION, VOLHISTORY.TYPE, VOLHISTORY.COMMAND
FROM BACKUPSETS BACKUPSETS, VOLHISTORY VOLHISTORY
WHERE BACKUPSETS.DATE_TIME = VOLHISTORY.DATE_TIME





"Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM> on 09/19/2002 02:32:34 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: Joseph Pendergast/Corona/Watson)

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?