Re: Archive list query
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
Archive list query
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. I have found this command: select distinct description from archives But when I ran it TSM replied with a warning that this command may create a very large table and take a long time to complete. I would rather do this from the TSM server and not have to go to each individual client to get this information. Am I on the right track with the above command or is there another one I should be running? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.