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