Hello Everyone,

I am trying to find out how long each migration task takes.  I tried to do
a select statement through the summary table, but I can't seem to get the
information that I want.  It just lumped all migration tasks together by
storage pool and I would like the ability to have each process reported on,
the start/end time and the MB migrated, and the number of files.  Is this
possible?  Thanks in advance!

Here is what I had tried:

select entity,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='MIGRATION' group by entity


********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************