Hello Everyone!
Is there a way that this information would be possible to fit on a single
line for each node? It appears as if there are too many spaces used for
the node name, but I'm not specifying a length so I wasn't quite sure what
I was doing wrong... Any ideas? Thanks!
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
----- Forwarded by Joni Moyer/ISG/CORP/Highmark on 05/11/2005 02:27 PM
-----
root AT chrs144 DOT high
mark.com
To
05/11/2005 07:30 joni.moyer AT highmark DOT com
AM cc
Subject
Query.Backup.LANsystems.TSMPROD
--------------------------------------------------------
---- dsm.query1.lansystems3 ----- Wed May 11 07:30:00 EDT 2005 ----- Start-
IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 5, Release 2, Level 0.0
(c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights
Reserved.
Session established with server TSMPROD: AIX-RS/6000
Server Version 5, Release 2, Level 2.5
Server date/time: 05/11/05 07:30:00 Last access: 05/11/05 07:05:00
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
------------------ ---------- ---------- -------- --------
--------- --------- ------------------
HMCH1127 2005-05-10 BACKUP 21:10:03 03:27:13
500 2214 NO
HMPG1148 2005-05-10 BACKUP 20:09:49 02:44:13
690 2266 NO
GEOHMKLGRB 2005-05-10 BACKUP 21:13:39 21:24:05
563 2331 YES
HMCH0001 2005-05-10 BACKUP 20:06:05 21:43:48
2019 33958 YES
HMCH0001 2005-05-10 BACKUP 21:48:00 22:05:44
1939 33688 YES
HMCH0002 2005-05-10 BACKUP 20:13:05 21:43:11
4202 34002 YES
HMCH1006 2005-05-10 BACKUP 21:04:05 21:18:55
813 2211 YES
HMCH1018 2005-05-10 BACKUP 21:06:10 21:14:25
976 2300 YES
HMCH1019 2005-05-10 BACKUP 20:08:10 20:48:01
10296 2782 YES
HMCH1019 2005-05-10 BACKUP 21:13:04 21:31:17
763 2263 YES
HMCH1022 2005-05-10 BACKUP 21:12:13 21:29:48
1495 2473 YES
HMCH1024 2005-05-10 BACKUP 20:08:19 20:49:25
1056 2162 YES
HMCH1025 2005-05-10 BACKUP 21:00:20 21:21:55
3127 2149 YES
HMCH1029 2005-05-10 BACKUP 21:02:26 22:01:31
3865 2890 YES
HMCH1033 2005-05-10 BACKUP 21:02:27 23:29:30
4099 9002 YES
HMCH1034 2005-05-10 BACKUP 20:06:29 20:53:03
543 189 YES
HMCH1100 2005-05-10 BACKUP 21:10:46 21:30:22
996 3368 YES
HMCH1103 2005-05-10 BACKUP 20:04:50 20:33:37
93 143 YES
HMCH1104 2005-05-10 BACKUP 21:00:40 21:14:36
1210 2210 YES
HMCH1105 2005-05-11 BACKUP 00:04:11 00:45:22
1350 10779 YES
HMCH1106 2005-05-10 BACKUP 21:10:48 21:27:50
631 2321 YES
HMCH1107 2005-05-10 BACKUP 21:00:51 21:13:15
564 2051 YES
HMCH1108 2005-05-10 BACKUP 21:04:52 21:20:04
616 2134 YES
HMCH1111 2005-05-10 BACKUP 21:07:58 21:36:50
427 2722 YES
HMCH1121 2005-05-10 BACKUP 21:07:55 21:30:46
582 2084 YES
HMCH1122 2005-05-10 BACKUP 20:03:57 20:47:25
7596 2779 YES
HMCH1122 2005-05-10 BACKUP 21:12:27 21:32:42
3779 2019 YES
HMCH1123 2005-05-10 BACKUP 21:05:57 21:22:05
670 2324 YES
HMCH1124 2005-05-10 BACKUP 21:06:01 21:30:49
1617 2272 YES
HMCH1125 2005-05-10 BACKUP 21:03:01 21:20:13
666 2218 YES
HMCH1128 2005-05-10 BACKUP 21:05:07 01:34:56
908 2403 YES
HMCH1129 2005-05-10 BACKUP 20:07:10 20:26:34
1583 322 YES
HMCH1129 2005-05-10 BACKUP 21:09:34 21:25:09
1842 125 YES
HMCH1130 2005-05-10 BACKUP 21:06:57 21:41:14
673 2217 YES
HMCH1131 2005-05-10 BACKUP 21:02:10 21:15:26
550 2100 YES
HMCH1133 2005-05-10 BACKUP 21:00:13 22:10:48
21532 2060 YES
HMCH1134 2005-05-10 BACKUP 20:07:14 22:38:53
56302 2605 YES
HMCH1135 2005-05-10 BACKUP 21:08:16 21:59:40
6750 7400 YES
HMCH1136 2005-05-10 BACKUP 21:09:18 21:28:26
732 2251 YES
HMCH1137 2005-05-10 BACKUP 21:07:44 21:14:57
161 482 YES
HMCH1138 2005-05-10 BACKUP 21:00:23 21:47:23
587 3067 YES
HMCH1142 2005-05-10 BACKUP 21:10:26 21:31:42
1799 2299 YES
HMCH1143 2005-05-10 BACKUP 21:10:38 23:20:10
5630 56727 YES
HMCH1144 2005-05-10 BACKUP 21:10:34 21:28:37
688 2200 YES
HMCH1145 2005-05-10 BACKUP 20:04:34 21:21:20
7201 3433 YES
HMCH1145 2005-05-10 BACKUP 21:27:24 21:44:12
603 2022 YES
HMCH1154 2005-05-10 BACKUP 21:13:39 21:26:54
637 2144 YES
HMCH1155 2005-05-10 BACKUP 21:13:42 21:24:49
620 2255 YES
HMCH1159 2005-05-10 BACKUP 21:11:45 21:34:14
556 2417 YES
HMCH1166 2005-05-10 BACKUP 21:02:54 21:31:52
10117 2187 YES
HMCH1167 2005-05-10 BACKUP 20:06:56 20:40:30
897 2730 YES
HMCH1168 2005-05-10 BACKUP 20:11:40 20:45:39
544 284 YES
HMCH1170 2005-05-10 BACKUP 20:09:59 20:41:34
610 2122 YES
HMCH1170 2005-05-11 BACKUP 00:13:39 00:18:52
589 2089 YES
HMCH1171 2005-05-11 BACKUP 00:02:04 00:47:56
4610 127959 YES
HMCH1172 2005-05-11 BACKUP 00:00:03 00:11:27
793 2192 YES
HMCH1173 2005-05-11 BACKUP 00:11:05 00:21:58
836 2201 YES
HMCH1174 2005-05-11 BACKUP 00:02:07 00:07:48
588 2183 YES
HMCH1175 2005-05-11 BACKUP 00:13:07 00:18:42
601 2161 YES
HMCH1176 2005-05-11 BACKUP 00:07:08 00:09:46
584 2190 YES
HMCH1177 2005-05-10 BACKUP 20:00:13 20:46:01
3672 10668 YES
HMCH1178 2005-05-11 BACKUP 00:00:18 00:52:26
5376 9811 YES
HMCH1179 2005-05-11 BACKUP 00:09:32 00:28:13
3773 7364 YES
HMCH1180 2005-05-11 BACKUP 00:03:18 00:12:34
1252 9524 YES
HMCH1181 2005-05-11 BACKUP 00:03:19 00:08:08
654 2188 YES
HMCH1182 2005-05-11 BACKUP 00:14:21 00:18:45
705 2226 YES
HMCH1183 2005-05-11 BACKUP 00:05:24 00:10:14
575 384 YES
HMCH1184 2005-05-11 BACKUP 00:03:07 00:06:53
107 266 YES
HMCH1185 2005-05-11 BACKUP 00:01:23 00:04:25
515 287 YES
HMCH1190 2005-05-11 BACKUP 00:01:39 00:07:14
753 199 YES
HMCH1191 2005-05-11 BACKUP 00:00:48 00:09:43
3677 2441 YES
HMCH1192 2005-05-10 BACKUP 20:07:44 20:39:11
584 2086 YES
HMCH1193 2005-05-11 BACKUP 00:00:48 00:11:32
534 1971 YES
HMCH1195 2005-05-10 BACKUP 20:14:49 20:40:47
569 2293 YES
HMCH1197 2005-05-10 BACKUP 20:04:05 20:46:44
756 2057 YES
HMCH2001 2005-05-10 BACKUP 20:11:06 22:21:50
5492 2534 YES
HMCH2001 2005-05-11 BACKUP 00:09:57 01:05:00
4716 2420 YES
HMCH2002 2005-05-11 BACKUP 00:00:07 00:06:08
755 1982 YES
HMCH2003 2005-05-11 BACKUP 00:04:07 00:08:27
536 2024 YES
HMCH2004 2005-05-11 BACKUP 00:13:10 00:18:27
518 2008 YES
HMCH2005 2005-05-11 BACKUP 00:08:10 00:11:19
536 2021 YES
HMCH2006 2005-05-11 BACKUP 00:11:13 00:18:17
889 2212 YES
HMCH2007 2005-05-11 BACKUP 00:01:13 00:08:15
4591 2083 YES
HMCH2008 2005-05-11 BACKUP 00:07:14 00:19:48
9385 2193 YES
HMCH2011 2005-05-11 BACKUP 00:12:14 00:17:50
592 2097 YES
HMCH2012 2005-05-11 BACKUP 00:00:16 00:05:04
549 2070 YES
HMCH2013 2005-05-11 BACKUP 00:00:21 00:09:05
614 2171 YES
HMCH2014 2005-05-11 BACKUP 00:03:18 00:08:16
870 2215 YES
HMCH2015 2005-05-11 BACKUP 00:13:19 00:18:27
783 2093 YES
HMCH2016 2005-05-11 BACKUP 00:12:20 00:19:16
908 2797 YES
HMCH2018 2005-05-11 BACKUP 00:00:48 00:06:39
496 2020 YES
HMCH2019 2005-05-11 BACKUP 00:02:59 00:16:13
358 5628 YES
HMCH2022 2005-05-11 BACKUP 00:00:25 00:03:38
588 280 YES
HMCH2023 2005-05-11 BACKUP 00:00:42 00:07:26
1589 347 YES
HMCH2024 2005-05-11 BACKUP 00:00:26 01:30:03
2207 9128 YES
HMCH2025 2005-05-10 BACKUP 20:06:16 20:44:03
726 340 YES
HMCH2026 2005-05-10 BACKUP 20:13:25 20:46:00
588 307 YES
HMCH2028 2005-05-10 BACKUP 20:11:25 20:46:21
618 2347 YES
HMCH2030 2005-05-10 BACKUP 20:05:32 20:14:31
56 208 YES
HMCH2031 2005-05-10 BACKUP 20:05:30 20:39:11
500 197 YES
HMCH2032 2005-05-10 BACKUP 20:10:31 20:41:50
462 158 YES
HMCH2033 2005-05-10 BACKUP 20:03:30 20:33:06
502 194 YES
HMCH2034 2005-05-10 BACKUP 20:02:36 20:50:22
1001 9406 YES
HMCH3100 2005-05-10 BACKUP 20:11:10 21:16:22
546 10151 YES
HMCH3140 2005-05-10 BACKUP 20:00:40 20:15:43
945 3073 YES
HMCH3141 2005-05-10 BACKUP 20:10:36 20:43:57
542 324 YES
HMCH3150 2005-05-10 BACKUP 08:00:26 08:03:13
78 148 YES
HMCH3190 2005-05-10 BACKUP 20:02:36 20:33:08
678 333 YES
HMCH3191 2005-05-10 BACKUP 20:00:56 20:27:57
532 202 YES
HMCH3192 2005-05-10 BACKUP 20:05:20 20:33:29
457 148 YES
HMCH3193 2005-05-10 BACKUP 20:10:24 20:54:03
1022 2100 YES
HMCH3194 2005-05-10 BACKUP 21:04:42 21:08:46
143 263 YES
HMCH3196 2005-05-10 BACKUP 20:03:49 20:37:44
545 332 YES
HMCH3198 2005-05-10 BACKUP 20:01:23 20:41:04
535 207 YES
HMCH3231 2005-05-10 BACKUP 20:03:22 20:35:42
653 193 YES
HMCH3232 2005-05-10 BACKUP 20:07:51 20:50:55
1119 3099 YES
HMER1105 2005-05-10 BACKUP 20:12:01 21:25:59
1165 2260 YES
HMJT1001 2005-05-11 BACKUP 00:09:18 00:42:56
611 2098 YES
HMPG0002 2005-05-11 BACKUP 00:11:35 00:31:07
7791 33949 YES
HMPG1022 2005-05-10 BACKUP 20:05:51 21:02:11
3276 6280 YES
HMPG1023 2005-05-10 BACKUP 20:02:53 21:33:13
14532 2625 YES
HMPG1024 2005-05-10 BACKUP 20:00:38 20:32:22
764 2682 YES
HMPG1028 2005-05-10 BACKUP 20:05:09 20:27:51
529 1944 YES
HMPG1029 2005-05-10 BACKUP 20:03:54 20:37:32
548 296 YES
HMPG1107 2005-05-10 BACKUP 20:10:28 20:40:54
587 2372 YES
HMPG1113 2005-05-10 BACKUP 20:10:48 20:55:18
717 2226 YES
HMPG1116 2005-05-10 BACKUP 20:13:37 20:45:16
745 2325 YES
HMPG1119 2005-05-10 BACKUP 20:07:50 20:39:13
559 2059 YES
HMPG1123 2005-05-10 BACKUP 20:06:54 21:07:41
1110 2085 YES
HMPG1126 2005-05-10 BACKUP 20:11:02 20:43:58
1243 2159 YES
HMPG1127 2005-05-10 BACKUP 20:07:10 20:40:54
1131 2141 YES
HMPG1128 2005-05-10 BACKUP 20:13:15 20:48:36
384 2185 YES
HMPG1135 2005-05-10 BACKUP 20:02:00 20:30:47
770 1957 YES
HMPG1137 2005-05-10 BACKUP 20:05:16 20:43:30
3132 2369 YES
HMPG1139 2005-05-10 BACKUP 20:01:21 20:25:32
661 2403 YES
HMPG1140 2005-05-10 BACKUP 20:05:29 21:07:14
768 3625 YES
HMPG1141 2005-05-10 BACKUP 20:07:31 21:57:46
35694 2212 YES
HMPG1142 2005-05-10 BACKUP 20:03:35 20:24:15
1117 2085 YES
HMPG1146 2005-05-10 BACKUP 20:04:40 20:36:50
1240 2118 YES
HMPG1147 2005-05-10 BACKUP 20:11:47 20:42:27
1241 2113 YES
HMPG1154 2005-05-10 BACKUP 20:01:38 20:31:58
1128 326 YES
HMPG1155 2005-05-10 BACKUP 21:09:04 21:18:58
1607 330 YES
HMPG3153 2005-05-10 BACKUP 21:04:10 21:13:19
537 295 YES
HMPG3160 2005-05-10 BACKUP 20:13:19 20:49:59
1745 326 YES
HMPG3161 2005-05-10 BACKUP 20:02:23 20:34:01
600 311 YES
HMPG3162 2005-05-10 BACKUP 20:00:29 20:05:51
586 221 YES
HMPG3163 2005-05-10 BACKUP 20:00:46 20:07:27
826 309 YES
HMPG4001 2005-05-10 BACKUP 20:06:52 20:34:50
1029 2331 YES
VMSNW04 2005-05-10 BACKUP 22:00:47 22:08:52
305 3518 YES
VMSNW11 2005-05-10 BACKUP 22:14:44 22:20:53
24 1812 YES
VMSNW12 2005-05-10 BACKUP 22:00:05 22:04:27
9 1803 YES
ANS8002I Highest return code was 0.
---- dsm.query1.lansystems3 ----- Wed May 11 07:30:02 EDT 2005 ----- End---
|