Hi all!
i'm just did a script that the output must be comma separated to be imported into a spreadsheet.
the output that i obteined was
Date/Time,We. Active Threads,W. Total Threads,W. Worker Threads,Name
29-12-10/11:43:01,0,250,0,/FIM
,0,/mytest
,0,/mockofprod/financing/customercentre
,0,/mockofprod/financing/commercial/amt
,0,/account/orderstatus
,0,/activities
as you can see, the first row it's ok, but the second and third, etc etc, are not formated. any ideas of how can i achive this?
NOTE: the first three values are simple commands that i put in order, the fourth and fifth are from a file.
this is part of the code.
printf "%s,%d,%d" $DATE $WSAT $WSTT >> output.${STANZA}.txt
for i in `cat jlist.${STANZA}.txt`
do
JUNCTION=${i}
WSWJ=`pdadmin -a sec_master -p ${PASSWD} server task ${STANZA} show ${JUNCTION} | grep 'threads' | awk '{ print $4 }'`
printf ",%d,%s\n" ${WSWJ} ${JUNCTION} >> output.${STANZA}.txt
done
----------------------------------
Alejandro Rodriguez Luna
Movil: 044-311-112-86-41
----------------------------------