ended ok /Not ok reports on weekly basis.

saxenaa · Post by **saxenaa** » 27 Oct 2011 7:18

In my control-M environment.. The “ControlM servers” are the physical systems where the ControlM application (ControlM/Server and ControlM/EM) is installed. The systems are: sun1036. And on sun1036 we have some IBM( AIX) agents insttaled in which lots of jobs are running.

Now the user have below query.

They need ended ok/Not ok with sysout details for all runinng jobs on Ibm agents and they requesting when their jobs run and how they terminated ( on AIX agent) and also they want ended ok /Not ok reports on weekly basis.
what is the way out ?
I tried some below commands.
ctmlog list YYMMDD 0800 YYMMDD 0759 | grep NOTOK ctmlog list YYMMDD 0800 YYMMDD 0759 | grep OK
and after run the above command we get some reports but that was for all the Agents .. i need report for some sepecificAGENTS.

As we dont have reporting facility .

Hagar · Post by **Hagar** » 27 Oct 2011 10:13

You can do it like this:

1: grep on the agent name
2: use awk to get the orderid
3: grep on orderid and OK
4: grep on orderid and NOTOK

saxenaa · Post by **saxenaa** » 27 Oct 2011 10:36

Thanks a lot for your quick responce.

Like the command would be as below ?

ctmlog list YYMMDD 0800 YYMMDD 0759 | grep IBM2136

where i can mentioned OK/NOT OK ?

Hagar · Post by **Hagar** » 27 Oct 2011 1:17

something like this

ORDERID=$(ctmlog list YYMMDD 0800 YYMMDD 0759 | grep IBM2136 |awk -F\| '{print $5}')
OK=$(ctmlog list YYMMDD 0800 YYMMDD 0759 | grep $ORDERID | grep OK) >> OK.date
NOTOK=$(ctmlog list YYMMDD 0800 YYMMDD 0759 | grep $ORDERID | grep NOTOK)>>NOTOK.date

saxenaa · Post by **saxenaa** » 27 Oct 2011 1:33

Hi Hager,

It's not working for me.

Did i miss something?

sun1036-controlm [1] ctmlog list 111025 1200 111026 1159 | grep ibm5000 |awk -F
awk: syntax error near line 1
awk: bailing out near line 1

Hagar · Post by **Hagar** » 28 Oct 2011 4:50

Your command misses the end

your: sun1036-controlm [1] ctmlog list 111025 1200 111026 1159 | grep ibm5000 |awk -F

Add this at the end: \| '{print $5}')

mwright · Post by **mwright** » 02 Nov 2011 6:48

if you have access to the server you can do the same thing as if you were on the control-m gui, you can list ok and not ok from the selected option of list ok or list notok, gui just gives you the pretty picture, hope this helps