Hello Zafar,
Built-in : you can use
predefined variables, like &$AGENT# for instance.
Script :
SYS_HOST_ALIVE will allow you to know if a given agent is active or not.
Via SQL : can be found in the
OH and
HOST tables. Try something like this :
SELECT OH_Name, HOST_HTYP_SW, Host_TCPIPaddr, HOST_Active
FROM OH, HOST
WHERE OH_Idnr = HOST_OH_Idnr
AND OH_Otype = 'HOST'
AND OH_Name NOT LIKE '<%>'
AND OH_DELETEFLAG = 0;
Best regards,
Antoine