Hi Steve, How about the client options -dataonly=yes and -commadelimited or -tabdelimited ?
You lose the headers and the formatting and get only the data you need. See also: http://www-01.ibm.com/support/docview.wss?uid=swg21143748 http://publib.boulder.ibm.com/infocenter/tsminfo/v6r2/index.jsp?topic=/com.ibm.itsm.srv.ref.doc/r_cmdline_adclient_options.html Marcel 2011/3/9 Steve Harris <[email protected]> > 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 > -- Kind Regards, Groetje, Marcel Anthonijsz
