Enterprise Manager Generic (MOSC)

MOSC Banner

OEM DB Report

edited Aug 6, 2018 9:24AM in Enterprise Manager Generic (MOSC) 2 commentsAnswered

I need to get a report of all of the unique databases that are being monitored in OEM.

I can list out all of the objects being monitored that are database related (target_type:  rac_database or oracle_database) or target_display_type: (Database System, Database Instance, Cluster Database or Pluggable Database), but I end up with duplicates (databases are listed with database instances).

Is there an OEM report that will show this, or does anyone have a script that will pull this information from the OMS repository?

Tagged:

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