I use an SQL query to get the info

SELECT VOLHISTORY.VOLUME_NAME, BACKUPSETS.BACKUPSET_NAME,BACKUPSETS.DATE_TIME,
BACKUPSETS.DESCRIPTION FROM VOLHISTORY,BACKUPSETS WHERE
VOLHISTORY.TYPE='BACKUPSET' AND VOLHISTORY.DATE_TIME=BACKUPSETS.DATE_TIME ORDER
BY BACKUPSETS.DATE_TIME DESC

Give that a try!

Chris






Thomas Denier <Thomas.Denier AT JEFFERSONHOSPITAL DOT ORG> on 10/05/2006 
06:09:52

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

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: Chris Pasztor/HCS)
Subject:  Re: [ADSM-L] Media in a backup set?



----- Nick Laflamme wrote: -----

>Is there an easy way to figure out which media go with which backup
>sets (and in which order?), or do I have to be really rigorous about
>culling the information from the server logs? I can see from Q LIBVOL
>which media are backupset media, but I don't yet see a way to see
>which tapes go with each other.

The 'query volhistory' command and the 'volhistory' SQL table will
provide this information, albeit in a somewhat clumsy way.