On Mar 26, 2007, at 2:40 AM, Paul Dudley wrote:

I would like to run a query that will give me a list of all the
archives
we have done.
I don't want a list of every file archived, just the general list
of the
archive backups on each server.
...

It's not clear what you're after.
You can inspect the Filespaces, Occupancy, and Auditocc tables for info.
You can also do:  select * from summary where ACTIVITY='ARCHIVE'
(but the TSM accounting records are a more reliable source of that
info).

  Richard Sims