Hello,

The list of activities (SUMMARY.ACTIVITY) seems to be:
'TAPE MOUNT'
'FULL_DBBACKUP'   'INCR_DBBACKUP'    'EXPIRATION'
'RECLAMATION'    'MIGRATION'     'MOVE DATA'   'STGPOOL BACKUP'
'BACKUP'   'RESTORE'     'ARCHIVE'    'RETRIEVE'

You can include those you want.

You can also combine with the field  SUMMARY.SUCCESSFUL  which is 'YES' or
'NO'.

Regards

Christian Bagard
SOS-Restore - 32 cours Mirabeau - 13100 Aix-en-Provence - France

----- Original Message -----
From: "Joni Moyer" <joni.moyer AT HIGHMARK DOT COM>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Wednesday, January 26, 2005 2:56 PM
Subject: Admin Job Summary


> 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
> ********************************
>