Re: 6.2 output formatting

2011-03-10 Thread deehre01
Run it thru awk (or your favorite tool) and drop all the blank lines before sending it on to your script. >>> Steve Harris 3/9/2011 5:17 PM >>> 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 t

Re: 6.2 output formatting

2011-03-09 Thread Steven Harris
From: Steve Harris To: ADSM-L@vm.marist.edu Date: 2011-03-09 17:18 Subject: 6.2 output formatting Sent by: "ADSM: Dist Stor Manager" Hi All I've inherited a Rube Goldberg reporting system where TSM queries are run against systems, and the results from all the TSM instan

Re: 6.2 output formatting

2011-03-09 Thread Andrew Raibeck
u > Date: 2011-03-09 17:18 > Subject: 6.2 output formatting > Sent by: "ADSM: Dist Stor Manager" > > 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 >

Re: 6.2 output formatting

2011-03-09 Thread Marcel Anthonijsz
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.js

6.2 output formatting

2011-03-09 Thread Steve Harris
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