how a Monitor Tool can get the agent status from the GC repository
Hi all
How may i get the real Agent status for one monitoring tool that use to do a query against the gc repository
Currently it's using this one dbsnmp user
SQL> col 'DATABASE NAME' for a20
SQL> col AGENT for a15
SQL> col LAST_UPLOAD for a15
SQL> r
1 SELECT DATABASE.target_name as "DATABASE NAME",AGENT.AGENT,AGENT.LAST_UPLOAD,AGENT.STATUS,AGENT.UPLOAD_STATUS
2 FROM (SELECT target.host_name as AGENT,
3 to_char(target.last_metric_load_time,'DD/MON/YYYY HH24:MI')||' '
4 ||target.timezone_region AS LAST_UPLOAD, DECODE(metric.value,0,'DOWN',1,'UP','UNKNOWN') AS STATUS,