Ian, If you only keep 60 days of activity you'll only be able to use TSM selects to find successful backups for 60 days not for going back years.
David >>> "Smith, I (Ian)" <[EMAIL PROTECTED]> 10/11/2006 8:48 AM >>> 60 days for act and summary logs... Ian Smith -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: 11 October 2006 13:45 To: [email protected] Subject: Re: [ADSM-L] SQL Query for monthly backups >I am trying to find out all the successful backups for a monthly node - >going back for years. > You keep your TSM Activity Log for years???? David _____________________________________________________________ This email (including any attachments to it) is confidential, legally privileged, subject to copyright and is sent for the personal attention of the intended recipient only. If you have received this email in error, please advise us immediately and delete it. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Although we have taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the viruses in this email or attachments. We exclude any liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided in this email or its attachments, unless that information is subsequently confirmed in writing. If this email contains an offer, that should be considered as an invitation to treat. _____________________________________________________________
