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
