Hi, Maybe you could use the -tab (or the -comma) option of dsmadmc to get what you want. It gives you the output on one line although it may require some formatting to make it readable.
dsmadmc -id=MyAdmin -pa=MyPassword -tab "q ev * *" > bla.txt Regards, Alexander > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Robert Ouzen Ouzen > Sent: Monday, August 07, 2006 7:41 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Output question > > Hi to all > > Running a query event to pick exception status as: q event > * * ex=yes begind=-1 begint=17:00 endd=today endt=08:00 > > c:\tsm\exception.txt > > Sometimes I got for a long nodename two lines: > > 08/03/2006 22:45:00 > SCHED3 WEBLXN > Missed > 08/04/2006 04:00:00 > DRM_HIGHLEAR- DRM_HIGHLEAR- Missed > > N_WEB > N_WEB > 08/04/2006 09:00:00 08/04/2006 09:00:06 DRM_MARVEL > DRM_MARVEL Failed > > I have a SQLDISPLAYMODE wide > > Column Date-Time Arithmetic Cursors > Display Format Mode Allowed? > Format > -------- --------- ---------- -------- > Wide ISO Truncate Yes > > But still two lines I prefer to run the query event instead > of a select command , did is possible to get only one line ?????? > > Regards Robert >