MQSeries.net :: View topic

ankurlodhi · Posted: Wed Jan 15, 2020 6:59 am Post subject:

I am trying to fetch the value of Queue Manager name from the below output using Powershell,

QMNAME(TEST) STATUS(Running)
QMNAME(CLxxxxxxxxx) STATUS(Running)
QMNAME(QMxxxxxxxxxxxxx) STATUS(Running)
QMNAME(QMxxxxxxxxxxxxxx) STATUS(Running)
QMNAME(xxxxxxxxxxxxxxx) STATUS(Running)
QMNAME(xxxxxxxxxxxx) STATUS(Running)

i am basically trying to convert the below script to Batch but can't find a replacement for CUT and AWK.

NOW=`date +"%Y%m%d"`
rootdir="Directory"
FILE_LOC="Directory"
rm $FILE_LOC/*.csv
QMGR=`dspmq |grep "Running"| awk '{print $1}' | cut -f2 -d "(" | cut -f1 -d ")" `
QMSTATUS=`dspmq | awk '{print $2}' | cut -f2 -d "(" | cut -f1 -d ")"`

for e in $QMGR
do
echo "Application Connected to QMGR : $e"
echo "DISPLAY QSTATUS(*) TYPE(HANDLE) OPENTYPE ( ALL ) CONNAME" | runmqsc $e > $FILE_LOC/$e.csv
echo "DISPLAY QSTATUS(*) TYPE(HANDLE) OPENTYPE ( ALL ) Where( CONNAME NE ' ') CONNAME CHANNEL" | runmqsc $e > $FILE_LOC/$e.mqsc
echo "QMANAGER:$e" > $FILE_LOC/$e.csv
port=`echo "dis LISTENER($e.LSTR) PORT"|runmqsc $e|grep PORT|tr -s ' ' '|'|tail -1|cut -d '|' -f3|tr -s '(' '|'|tr -s ')' '|'|cut -d '|' -f2`
echo "PORTNUMBER:$port" >> $FILE_LOC/$e.csv
echo "DISPLAY QSTATUS(*) TYPE(HANDLE) OPENTYPE ( ALL ) Where( CONNAME NE ' ') CONNAME CHANNEL" | runmqsc $e|grep -v MQMON|grep -v SYSTEM|grep -v UT|grep -v AMQ8450|grep -v DISPLAY|grep -v Copyright|grep -v Starting|grep -v MQSC|grep -v commands|grep -v valid|tr -s " " "\n" >>$FILE_LOC/$e.csv

chmod 757 $FILE_LOC/$e.csv
done