Try running this one (I can't remember if this is long running or not and I don't have TSM DB available to me right now):
select distinct date (archive_date) as date, node_name, filespace_name, description from archives ______________________________ John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-221-6938 http://www.computechresources.com De Keyser Bart <[EMAIL PROTECTED] L.BE> To Sent by: "ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager" <[EMAIL PROTECTED] Subject .EDU> select statement for Archives 01/06/2006 02:10 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> Hi there, We're trying to get an overview of all the archives we've already taken, sorted on their annotation. When we try the select description from archives statement, we get one line per file within the archive... Since we've got archives with about 30.000 files, our server falls on timeouts and often no returns are given. Within the retrieve module of the Backup-Archive Gui, you can view a list of all available archives.. so it should be possible to generate this list with a select, no?? Does anybody have an idea?? Thanks This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal.
