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: [email protected] IBM Tivoli Storage Manager support web page: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager "ADSM: Dist Stor Manager" <[email protected]> wrote on 2011-03-09 17:17:51: > From: Steve Harris <[email protected]> > To: [email protected] > Date: 2011-03-09 17:18 > Subject: 6.2 output formatting > Sent by: "ADSM: Dist Stor Manager" <[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
