select from DB

[Sagi Abrahamsohn]

Automic Web Interface 12.3.5 (still. on my way for upgrade)
I am looking for some tables for several things.

in the app, I can look at an agent group to find out, what agent are in the group.
I need to see for an agent, in which groups its in.

guess that i can look in a single table for that

the second thing is to find under what JSCH, a job that fail was ran.

the step can be used by several parents, but when it run, it got a job_id

so, how can i find under what JSCH was this jobID ran

if anyone done it before, i will be happy to hear about it

-------------------------------------------

[Peter Grundler]

Hi,

this query returns the list of host groups where an agent is defined:

select OH_Client,OH_Name
from OHGF
 inner join OH on (OHGF_OH_Idnr = OH_Idnr)
 where OHGF_Name = '<your agent name here>'
 order by OH_Client, OH_Name;

regards,
Peter

------------------------------
Automic Certified Professional/Expert & Broadcom Knight
------------------------------

[Sagi Abrahamsohn]

Thank you very much!!!!

Do you know how to find under what JSCH the each RunID is?

-------------------------------------------

[Peter Grundler]

Hi,

Is the JSCH the direct parent?

Regards

Peter 

------------------------------
Automic Certified Professional/Expert & Broadcom Knight
------------------------------

[Peter Grundler]

try this query:

SELECT
    a.AH_Client,
    a.AH_Name,
    b.AH_Name AS Act
FROM AH AS a
LEFT JOIN AH AS b
    ON b.AH_Idnr = a.AH_ParentAct
WHERE a.AH_OType = 'JOBS'
  AND a.AH_SType = 'JSCH'
  AND a.AH_Status >= 1800
  AND a.AH_Status < 1900
ORDER BY a.AH_TimeStamp2 DESC;

------------------------------
Automic Certified Professional/Expert & Broadcom Knight
------------------------------