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?