t by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: script to total backups
This will give you average backup stats for the last 14 days.
SELECT entity as node, avg(end_time-start_time) as elapsed_time,
avg(cast((bytes/1024/1024) as decima
Try this
It gives the averages by node for all successful backups in the summary table
select entity, avg(bytes) "Avg Bytes", avg(end_time - start_time) "Elapsed" \
from summary \
where activity='BACKUP' \
and failed=0 \
group by entity
ENTITY Avg Bytes
ond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:script to total backups
Does anyone have a query that will tell me the average time a backup took
and the average amount of data transmitted?
Does anyone have a query that will tell me the average time a backup took
and the average amount of data transmitted?