EMCC Metric extension on PDB target is running on CDB$ROOT

Hi,

EM Cloud Control 13.2:

I observed the following issue:

If you create a metric extension which uses the SQL adapter, has a PDB target and you'll deploy this to a PDB it will run at the CDB$ROOT container and not on the targeted PDB.

Here are the steps to reproduce:

Create Metric Extension with Target Type PDB

Setting up the query (here it was made for testing purpose getting the current_container)

Run the test against a PDB other than CDB$ROOT, but the result is the CDB$ROOT

I've noticed that, because I wanted to monitor the temp tablespace usage of a specific PDB.