Enterprise Manager Generic (MOSC)

MOSC Banner

how a Monitor Tool can get the agent status from the GC repository

edited Apr 6, 2015 10:02AM in Enterprise Manager Generic (MOSC) 2 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center