>From my experience the mediaw is in seconds.
Guillaume Gilbert Storage Architect 514.866.8876 Office 514.866.0901 Fax 514.290.6526 Cellular [EMAIL PROTECTED] StorageTek Canada Inc. INFORMATION made POWERFUL -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: July 26, 2005 15:14 To: [email protected] Subject: Re: [ADSM-L] Migration Summary Thank you very much!!! Would you happen to know if the mediaw is in seconds? Or how I can find out valid values for each column in the summary table? Thanks again! ******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ******************************** "Gilbert, Guillaume" <guillaume_gilber To [EMAIL PROTECTED]> [email protected] Sent by: "ADSM: cc Dist Stor Manager" Subject <[EMAIL PROTECTED] Re: Migration Summary .EDU> 07/26/2005 03:04 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> Hi Joni Try this : select entity, - date(start_time) as "Date", - time(start_time) as "Start", - time(end_time) as "End", - cast((end_time-start_time)seconds as decimal(6,0)) as "Length", - cast(bytes/1024/1024 as decimal(8,2)) as "MB",- cast(bytes/((cast((end_time-start_time)seconds as decimal(18,0))))/1024/1024 as decimal(10,2)) as MBs/Secs", - processes as "Processes", - mediaw as "Media Wait" - from summary - where activity='MIGRATION' and - start_time>=timestamp(current date - 20 day, '00:00:00') and - end_time<=timestamp(current date - 0 day, '22:00:00') Adjust the start and end_time in the where clause to suit your needs. Guillaume Gilbert Storage Architect 514.866.8876 Office 514.866.0901 Fax 514.290.6526 BlackBerry [EMAIL PROTECTED] StorageTek Canada Inc. INFORMATION made POWERFUL -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: July 26, 2005 13:52 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] ********************************
