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" <ADSM-L AT VM.MARIST DOT EDU> 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.