Hi Steve,
Off-hand I'm not sure what changed in the output formatting, but have you
looked into use the "-tabdelimited" and "-dataonly=yes" options on the
dsmadmc command line? This should overall make parsing much easier than
trying to handle the default formatting. For example:
dsmadmc -id=adminid -pa=secret -tabdelimited -dataonly=yes
-outfile=select.out select node_name, status, result, ...
Best regards,
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Product Development
Level 3 Team Lead
Internal Notes e-mail: Andrew Raibeck/Hartford/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
IBM Tivoli Storage Manager support web page:
http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager
"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 2011-03-09
17:17:51:
> From: Steve Harris <steve AT STEVENHARRIS DOT INFO>
> To: ADSM-L AT vm.marist DOT edu
> Date: 2011-03-09 17:18
> Subject: 6.2 output formatting
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> Hi All
>
> I've inherited a Rube Goldberg reporting system where TSM queries are
> run against systems, and the results from all the TSM instances, then
> run through a very ugly rexx script to produce a consolidated csv file
> for each day. This is then further processed by some rather opaque VBA
> and the end result is a consolidated backup spreadsheet for each
> customer, for the whole month.
>
> The issue I have is that with a 6.2.0.0 admin client (on windows) and a
> 5.5 server the TSM query output looks like...
>
> NODE_NAME STATUS RESULT
> SCH_DATE SCH_TIME ACT_DATE ACT_TIME
> -------------------------- ---------- -----------
> ---------- -------- ---------- --------
> ADCMOHTSM01-BA Completed 0
> 2011-03-09 20:00:00 2011-03-09 20:00:08
> ARTHUR Completed 4
> 2011-03-10 00:30:00 2011-03-10 00:31:54
> AT1RTJA Completed 0
> 2011-03-10 03:30:00 2011-03-10 03:30:39
>
> But with the same admin client and a 6.2.2.0 server I get
>
> NODE_NAME STATUS RESULT
> SCH_DATE SCH_TIME ACT_DATE ACT_TIME
> ------------------ ------------------ ------------
> ----------- --------- ----------- ---------
> KDCUNITSM00-BA Completed 0
> 2011-03-09 08:00:00 2011-03-09 08:00:04
>
> KDCUNITSM00-BA Completed 0
> 2011-03-09 10:02:16 2011-03-09 10:05:39
>
> KDCUNITSM00-BA Completed 0
> 2011-03-09 11:07:00 2011-03-09 11:07:02
>
> I can cope with the column spacing being different, but the blank lines
> are throwing the rexx script into a tight loop.
>
> I've tried sqldisplaymode wide/narrow with no effect, and the problem
> persists if I drop the number of fields in the output, so its not that
> the line is just full enough to overflow.
>
> Any ideas on how to get around this?
>
> Thanks
>
> Steve
>
> Steven Harris
> TSM Admin Paraparaumu New Zealand
|