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]
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:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Tuesday, July 26, 2005 12:52 PM To: ADSM-L@VM.MARIST.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 [EMAIL PROTECTED]
Re: Migration Summary
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: ADSM-L@VM.MARIST.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 [EMAIL PROTECTED]
Re: 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] ADSM-L@VM.MARIST.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 [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: ADSM-L@VM.MARIST.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 [EMAIL PROTECTED]
Re: Migration Summary
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: ADSM-L@VM.MARIST.EDU 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] ADSM-L@VM.MARIST.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 [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: ADSM-L@VM.MARIST.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 [EMAIL PROTECTED]
Re: Migration Summary
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.
[EMAIL PROTECTED]
Sent by: ADSM-L@VM.MARIST.EDU
26.07.2005 20:08
Please respond to
ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: Tuesday, July 26, 2005 12:52 PM
To: ADSM-L@VM.MARIST.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
[EMAIL PROTECTED]
