ADSM-L

Re: Fw: Query.Backup.LANsystems.TSMPROD

2005-05-11 16:00:20
Subject: Re: Fw: Query.Backup.LANsystems.TSMPROD
From: Andrew Raibeck <storman AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 11 May 2005 13:57:25 -0600
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---

<Prev in Thread] Current Thread [Next in Thread>