List every server

remfleyf · Post by **remfleyf** » 02 Sep 2010 11:15

Hello everyone !

I am a new user of control-M 6.1.03.

I want to create an excel file which contain every server (hostname or ip) that are planned in 'active jobs'

Is there a solution (script, query) where I can list my server ?

I hope I was clear.

Thank you for your help.

(sorry for my english)

LordOfAfford · Post by **LordOfAfford** » 02 Sep 2010 11:35

If you refer to the Active jobs on the planning

Code: Select all

SELECT DISTINCT NODEID
FROM  CMR_AJF
ORDER BY NODEID

If you need to know all your servers regardless if they have active jobs on planning or not

Code: Select all

SELECT DISTINCT NODEID
FROM  CMS_JOBDEF
ORDER BY NODEID

remfleyf · Post by **remfleyf** » 02 Sep 2010 1:35

Hi thank you for your response.

Is that query can give me every server that are scheduled in Control-m ?

I notice in my environnement the node-id doesn't match with the hostname of the server.

Thank

nicolas_mulot · Post by **nicolas_mulot** » 02 Sep 2010 10:43

Remfleyf,

If the fields you find in your jobs do not match the actual hostnames, maybe you use symbolic name which are resolved by NodeGroups.

You can simply check that using ctm_menu - 7 - Node Group,
or by running the following request:

select * from CMS_NODGRP

If it is the case, the nodeid (the actual hostname) will be displayed on an active job only after the job has been submitted. A job which is still waiting only displays the NodeGroup, in which case you need to find out which NodeId is associated. This means the definite info you need comes from 2 different sources: the AJF and the NodeGroups definitions

Try this:
select distinct NODEID from CMS_NODGRP
where GRPNAME in (select NODEGRP from CMR_AJF)
union (select distinct NODEID)
from CMR_AJF

Cheers
Nicolas Mulot