Try this: select date(start_time) as start_date, time(start_time) as start_time, date(end_time) as end_date, time(end_time) as end_time, SUBSTR (CAST(entity AS char(17)),1,17) as Node_Name, cast((Bytes/1024) as decimal(15,2)) as KB_Archived, affected, (end_time-start_time)minutes as Mins from summary where activity='ARCHIVE' order by start_date
result looks like: START_DATE START_TIME END_DATE END_TIME NODE_NAME KB_ARCHIVED AFFECTED MINS ---------- ---------- ---------- -------- ----------------- ----------------- -------------------- ---------- 2010-03-01 11:50:37 2010-03-01 16:44:35 AUCFDW01_FS 376022498.94 120 293 Regards, Ankur Patel Snr Enterprise Mgmt Administrator Sydney. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of William ZHANG Sent: Thursday, 1 April 2010 12:26 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] how can I know an archive finished Hi All, My colleague is archiving some data by gui interface - dsmj , how can I know the finish of this archive if I can not see the gui interface and he does not close gui. Thanks and regards, William ************************************************************************************************ DISCLAIMER Confidential Communication: This email and any attachments are intended for the addressee(s) only and are confidential. They may contain legally privileged or copyright material. If you are not the intended recipient, please contact the sender immediately by reply email and delete this email and any attachments. You must not read, copy, use, distribute or disclose the contents of this email without consent and Harvey Norman Holdings Limited ACN 003 237 545 (and its related subsidiaries) (“Harvey Norman”) does not accept responsibility for any unauthorised use or reliance on the contents of this email. Harvey Norman does not represent or warrant that the integrity of this email has been maintained or that it is free from errors, viruses, interceptions or interference. Any views expressed by the sender do not necessarily represent the views of Harvey Norman. This notice should not be removed from this email. ************************************************************************************************