I am using the Cloud control 13c.Here we can have the view of targets for which database monitoring credentials are set.
Whether we can have an sql query using EM management views from which the details can be obtained.