By doing a query of the activity log for event ANE4964I the information you
seek should be available. I do a query like this every day and get the
results below:
q actlog begint=-24 search=ANE4964I
04/17/05 19:13:14 ANE4964I (Session: 8016, Node: RS5) Elapsed
processing
time: 00:01:12
04/17/05 19:36:53 ANE4964I (Session: 8022, Node: RS8) Elapsed
processing
time: 00:00:09
04/17/05 19:47:22 ANE4964I (Session: 8025, Node: RS3) Elapsed
processing
time: 00:00:39
04/17/05 20:01:11 ANE4964I (Session: 8028, Node: RS1) Elapsed
processing
time: 00:03:31
04/17/05 20:06:28 ANE4964I (Session: 8031, Node: RS4) Elapsed
processing
time: 00:01:08
04/17/05 20:21:57 ANE4964I (Session: 8034, Node: RS6) Elapsed
processing
time: 00:00:32
04/17/05 20:30:40 ANE4964I (Session: 8037, Node: RS2) Elapsed
processing
time: 00:01:16
Joni Moyer
<joni.moyer@HIGHM
ARK.COM> To
Sent by: "ADSM: ADSM-L AT VM.MARIST DOT EDU
Dist Stor cc
Manager"
<[email protected] Subject
.EDU> [ADSM-L] summary select statement
04/18/2005 06:01
AM
Please respond to
"ADSM: Dist Stor
Manager"
<[email protected]
.EDU>
Hello everyone!
I have the following command running to see how much data is backed
up/server each day. I was wondering if it is possible to take the start &
end time and figure out the amount of time it took to backup each server?
It seems like it should be rather simple, but yet I am not sure of the
syntax. Thank you in advance!
ANS8000I Server command: 'select entity as node_name, date(start_time) as
date, cast(activity as varchar(10)) as activity, time(start_time) as start,
time(end_time) as end, cast(bytes/1024/1024 as decimal(6,0)) as megabytes,
cast(affected as decimal(7,0)) as files, successful from summary where
start_time>=current_timestamp - 1 day and (entity like 'HM%' or entity like
'PAB%' or entity like 'VMS%' or entity like 'GEOHMKLG%' ) and
activity='BACKUP' order by successful, node_name'
NODE_NAME DATE ACTIVITY START END
MEGABYTES FILES SUCCESSFUL
------------------ ---------- ---------- -------- --------
--------- --------- ------------------
HMCH1016 2005-04-17 BACKUP 19:06:16 19:45:46
813 2326 YES
HMCH1021 2005-04-17 BACKUP 19:11:00 19:23:14
856 2277 YES
HMCH1147 2005-04-17 BACKUP 19:00:01 19:31:47
558 2162 YES
HMCH1150 2005-04-17 BACKUP 19:02:11 19:14:38
750 0 YES
HMCH1160 2005-04-17 BACKUP 19:12:14 19:20:57
525 1970 YES
HMCH1161 2005-04-17 BACKUP 19:01:30 19:11:22
596 0 YES
HMCH1162 2005-04-17 BACKUP 19:09:19 19:21:42
546 2064 YES
HMCH1163 2005-04-17 BACKUP 19:02:24 19:22:12
625 1934 YES
HMCH1164 2005-04-17 BACKUP 19:08:26 19:18:17
518 1944 YES
HMCH1165 2005-04-17 BACKUP 19:02:31 19:16:55
525 1948 YES
HMCH1169 2005-04-17 BACKUP 19:06:35 19:16:42
542 2096 YES
HMCH1186 2005-04-17 BACKUP 19:14:04 19:21:10
556 2101 YES
HMCH1187 2005-04-17 BACKUP 19:10:09 19:15:46
549 2130 YES
HMCH1188 2005-04-17 BACKUP 19:12:20 19:25:01
688 2260 YES
HMCH1189 2005-04-17 BACKUP 19:09:21 19:15:55
613 2209 YES
HMCH1194 2005-04-17 BACKUP 19:02:48 19:19:11
1007 2779 YES
HMPG1109 2005-04-17 BACKUP 19:06:26 19:22:05
3474 3153 YES
HMPG1124 2005-04-17 BACKUP 19:11:48 19:23:05
640 2319 YES
HMPG1143 2005-04-17 BACKUP 19:00:09 20:45:30
312 2129 YES
HMPGCWSI 2005-04-17 BACKUP 19:08:53 19:25:23
3436 2475 YES
ANS8002I Highest return code was 0.
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
|
