Finding server names

[Oscar Leon]

Hello everyone,

I need to know in which table/field can I see in which server a job is running.

Thanks in advance for help and any information you can provide.

Have a nice day ahead!

[Daryl Brown]

Assuming your agent names match your server names, then you can look at the EH.EH_HOSTDST field for active jobs, or AH.AH_HOSTDST for active/historical jobs.

If you're talking about file transfer jobs in particular where there are two agents involved, you'll also want to look at the EH_HOSTSRC / AH_HOSTSRC fields.

[Oscar Leon]

Hi Daryl,

Thank you very much for your prompt reply.

Unfortunately, our agents don't have the same name of the server they are installed.  That's why I need to find out the name of the actual servers.

[Lester Chew]

I must be missing something or reading the question wrong.  If you know the job name, you can look at the job's attribute for either the HOSTG or Agent name.  Then go to administration perspective, look for the agent name.  To the right is the IP address.  then execute ping -a IP address and it will return the actual server name.

[Daryl Brown]

Okay, that does complicate things if your agent names don't match your server names...I don't think Automic actually cares about the real server name or stores it anywhere.

To build on Lester's suggestion, if you could build a variable object that maps all of your agent names to server names, we could assist with a query to join the tables in question.

(You could build a job or two (unix & windows?) to run against an agentgroup -- all agents of that OS type -- to report their server name, and then read  (prep_process_report) that in and write it to a variable object.)

[Oscar Leon]

Hi Lester,

Thank you very much for the information you provided,

As I said, our agents don't have the exact name of the server they are installed on.  For that reason, I'm trying to generate a report, based on agents or jobs/workflows, to find out in which server each agent is installed and document that.

I hope my question makes more sense to you know.

Have a nice day!

[Arun Choudhari]

Hi Oscar,

Assuming that you don't have list of agent server and you want to know the server name for all your agents and document that for your reference then you may need to run job in each agent with simple hostname command you will get server name in report. hope this will help you.

[MartinZell]

Hey, as Daryl Brown already mentioned, the EH.EH_HOSTDST / EH.EH_HOSTSRC / AH.AH_HOSTDST / AH.AH_HOSTSRC fields contain the agents that the job was using (eh = running, ah = ended; dst = target for the job or destination agent for JOBF, src = src agent for JOBF). 

Having the agent name, you can then refer to the ACTEX table that lists the reported hostname/ip for the agents that is seen in Administration > Agents. Keep in mind that hostnames there usually only contain the local hostname (`testserver`) and not the FQDN (`testserver.company.example.com`). Also note that the hostname should reflect whatever you may have set in the agent ini under [VARIABLES] -> UC_EX_IP_ADDR (e.g. to get the FQDN).

The agent's OH_IDNR is in ACTEX.ACTEX_OH_IDNR, the agent name is also reported in ACTEX.ACTEX_HOST. Hostname is ACTEX.ACTEX_HOSTNAME, IP is in ACTEX.ACTEX_IPADDR. There is also other potentially useful information about agents in this table.