Hi Joni,
You can do:
select left(entity, <n>) as node_name ...
where <n> is the number of columns you want. For example, if you know the
longest node name is 10 characters, do:
select left(entity, 10) as node_name
Also, for output with lots of columns, there is (probably) only so much
you're going to squeeze into the regular console output without invoking
line wrapping. Consider loading the data into a spreadsheet or db tool,
which might make viewing easier.
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-05-11
11:29:41:
> 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---
|