Script do know info from Agents

Some examples running with Control-M and Control-EM database.
Post Reply
User avatar
osafr71
Nouveau
Nouveau
Posts: 26
Joined: 21 Jan 2010 12:00

Script do know info from Agents

Post by osafr71 » 04 Apr 2013 4:18

Hi there,

I will upgrade my Control-M version 6.4 to 8, and i need to add a new server name to the Authorized Hosts . I have aboute 600 Agents.

Is there any method or SQL script to view or add this new name for Control-M Server for those Agents?

Thanks in advance

osafr71

User avatar
Manii
Nouveau
Nouveau
Posts: 46
Joined: 28 Jul 2011 12:00

Post by Manii » 04 Apr 2013 10:19

Hi,

If you are using same ports ( Server-to-agent & Agent-to-server ) in new version 8, then you need to update 2 parameter in agent configuration

Update the config.dat file under
<agent>/ctm/data

First 2 parameters are CTMSHOST and CTMPERMHOSTS, here you need to replace/add the new control_M server host name

CTMSHOST <New>
CTMPERMHOSTS <New>

NOTE --> changing only these 2 parameter will work only if u r using the same ports to communicate between server and agent as previous installation

otherwise check the config.dat file for other parameter to be updated

This does not required agent restart as well

User avatar
osafr71
Nouveau
Nouveau
Posts: 26
Joined: 21 Jan 2010 12:00

Post by osafr71 » 05 Apr 2013 5:16

Hi.

Ok, i will do that.
Another questions, where i can find inormation of all agents, like for example the informations when we click on Properties of the Agent on CCM?

Is there any XML or DAT file with all info?

User avatar
Manii
Nouveau
Nouveau
Posts: 46
Joined: 28 Jul 2011 12:00

Post by Manii » 08 Apr 2013 7:13

you can run the following command on Control-M Server DB to get all Nodes associated to it and used in Jobs


select distinct NODEID from CMS_JOBDEF ;

Post Reply