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)
List every server
If you refer to the Active jobs on the planning
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 CMR_AJF
ORDER BY NODEID
Code: Select all
SELECT DISTINCT NODEID
FROM CMS_JOBDEF
ORDER BY NODEID
- nicolas_mulot
- Nouveau
- Posts: 149
- Joined: 07 Jan 2010 12:00
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
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