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
joni.moyer AT highmark DOT com
********************************
"Gilbert,
Guillaume"
<guillaume_gilber To
t AT STORAGETEK DOT COM> ADSM-L AT VM.MARIST DOT EDU
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
guillaume_gilbert AT storagetek DOT com
StorageTek Canada Inc.
INFORMATION made POWERFUL
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: July 26, 2005 13:52
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
********************************
|