hi joni,

i think this select statement will show you the information what you are
looking for.

SELECT ENTITY as "Activity", -
 Activity as "Process", -
 Start_Time as "Start Time",End_Time as "End Time", -
 END_TIME-START_TIME as "Runtime D HH:MM:SS", -
 Examined as "Files/Dirs checked", -
 Affected as "Files/Dirs transfered",cast(BYTES/1048576 as decimal(12,3))
as "Bytes transfered in MB", -
 FAILED as "Files/Dirs with failures", -
 Mediaw as "Media Wait in sec.", -
 Processes as "Number of Processes", -
 Successful as "Successfull" FROM ADSM.SUMMARY -
 where ACTIVITY like upper('MIGRATION') and date(start_time) >=
current_date - 1 days -
 ORDER BY "Start Time"


this select statement shows you all migration processes with a start-time
current_date - 1 day,
feel free to modify this line to get the information of more days.








James.Brents AT VALERO DOT COM
Sent by: ADSM-L AT VM.MARIST DOT EDU
26.07.2005 20:08
Please respond to
ADSM-L AT VM.MARIST DOT EDU


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: Migration Summary






You could query the activity log and look at the message for the process
completion status.  It will tell you how much that process moved.

Regards,
James

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Tuesday, July 26, 2005 12:52 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Migration Summary


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