Enterprise Manager Generic (MOSC)

MOSC Banner

SQL query to export Patch Recommendations from an EM 13.5 repository to a file.

I would like to be able to export the data from the MGMT$ views related to patch recommendations. My company wants to automate this process / take the human interaction out of the equation. I figured out so far that the views of interest are SYSMAN.MGMT$MOS_PA_FINAL_RECOM, SYSMAN.MGMT$ARU_PATCH_RECOM_MD and SYSMAN.MGMT$TARGET. One thing however I can't seem to find, and that's where to obtain the ORACLE_HOME from of the targets involved in the recommendations. It's not there in the three views I list in this question. Anyone have an idea which view can be used to couple the ORACLE_HOME to the TARGET_NAME?

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