Queries for Targets

The topology and metric integrations of Ops Connector for OEM each provide Operations Connector with a mapped subset of entities defined and available in Oracle Enterprise Manager (OEM). In each integration the entire OEM entity set is filtered with SQL queries so that only the entities applicable for mapping are retrieved. This prevents the product from retrieving redundant data and keeps the amount of retrieved data within reasonable boundaries. The predefined SQL queries are part of the integration configuration, and suffice for most uses.

In case you want to retrieve additional entities from the OEM database (and extend the mappings accordingly), you can alter the SQL queries of the topology and metric integrations.

You should be familiar with the SQL language and the OEM database schema to make changes to the SQL queries. In case your changes are incorrect, Ops Connector for OEM may not send the chosen data to Operations Connector and OMi, or it may even fail to send any data at all.

Topology Integration SQL Queries

SQL queries of the topology integration are stored in <ovdatadir>\conf\HPBsmIntOEM\classpath\config\application-defaults.properties file.

Metric Integration SQL Query

The single SQL query that the metric integration uses depends on the integrated OEM version. SQL query for supported OEM version can be verified in the <ovdatadir>\installation\HPBsmIntOEM\policy directory.

For 12c or 13c:

oemMetricsQuery.sql

For 11g:

oemMetricsQuery_11g.sql