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:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Tuesday, July 26, 2005 12:52 PM To: [email protected] 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 [EMAIL PROTECTED] ********************************
