Claus_Jambrich_5663

Jobs on an agent on different clients

Discussion created by Claus_Jambrich_5663 on Dec 22, 2016
A customer asked, if there is a way to find out, which jobs are running on an agent on all clients. Of course you can see this from client 0

0jlp7l55k7a6.png

But the customer wanted a solution he can use in a Script. Automic has no script function to show jobs on all agents, but this SQL might help:

SELECT
    EH.EH_Client    AS "Client"
  , EH.EH_Otype     AS "Type"
  , EH.EH_Name      AS "Name"
  , EH.EH_Starttime AS "Start time"
  , EH.EH_Queue     AS "Queue"
  , AH.AH_Name      AS "Name of caller"
FROM
    EH, AH
WHERE
    EH.EH_ParentAct = AH.AH_Idnr
AND
    EH.EH_Hostdst = 'WS10_VWGSUP15_WX6_01_SYS'
AND
    EH.EH_Otype IN ('!EVNT','EVNT','JOBF','JOBS','JOBP');

Outcomes