Joni,

Try "q event * type=admin exceptionsonly=yes". This will list the admin
events that failed.

Rick Saylor
Austin Community College

At 07:56 AM 1/26/2005, you wrote:

Hello everyone!

I am trying to do a script to find out if all admin jobs were successful or
not, the summary of the info. and the time at which the task ended.  I
found a script to run to find the total amount of data backed up with
storage pools, but I was wondering if there is any way to just pull the
summary info. from the activity log or is there a different way to query
the summary table so that I can see stgpool backups, migrations, dbbackups
and reclamation summaries?  Thanks in advance!

select entity as "Storage Pool ", cast(sum(bytes/1024/1024/1024) as
decimal(10,3)) as "Total GB", ' ' as " ", substr(cast(min(start_time) as
char(26)),1,19) as "Start Date/Time", substr(cast(max(end_time) as
char(26)),1,19) as "End Date/Time" from summary where
start_time>=current_timestamp - 24 hours and activity='STGPOOL BACKUP'
group by entity
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************