Here's a nice select command to see more detailed information . So I don't take all the credit, this select was posted while back one time or other. You can play around with date # to increase or decrease # of days of report.
select entity as node_name, date(start_time) as date, cast(activity as varchar(10)) as activity, - time(start_time) as start,time(end_time) as end, - cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as Length,- cast(bytes/1024/1024/1024 as decimal(6,2)) as - Gigabytes,cast(affected as decimal(7,0)) as files, successful from summary where - start_time>=current_timestamp - 1 day and activity='BACKUP' - order by successful, node_name I dont' think "q event" is a select statement. "ADSM: Dist Stor Manager" <[email protected]> wrote on 01/10/2007 12:25:10 AM: > Hi, > > 1) Is there any command to find the list of all failed backups in a > server? > 2) Is there any command to find the list of all successful backups in a > server? > > Regards, > Srinath G > > This e-mail has been scanned for viruses by the Cable & Wireless e- > mail security system - powered by MessageLabs. For more information > on a proactive managed e-mail security service, visit http://www. > cw.com/uk/emailprotection/ > > The information contained in this e-mail is confidential and may > also be subject to legal privilege. It is intended only for the > recipient(s) named above. If you are not named above as a recipient, > you must not read, copy, disclose, forward or otherwise use the > information contained in this email. If you have received this e- > mail in error, please notify the sender (whose contact details are > above) immediately by reply e-mail and delete the message and any > attachments without retaining any copies.
