Remove the incorrect vROps instance from the Usage Meter database.

In case you are unable to remove an incorrect instance from the Usage Meter even after removing the plugin from the mob we can use the following method to remove the instance from the UM Database

      Before you start this, please take a snapshot of the Usage Meter appliance
Open up the Console (or SSH) to the Usage Meter appliance. 
Log into the console type sql to access the database. 

Query vCOPS table to verify the record we need to delete type in

select * from "VcopsServer"; 

We can see I only have one instance here, so it's ID is 1

Delete entry using ID, replace [ID] with the ID from above statement type the following commands

delete from "VcVcops" where "vcopsServerId" = [ID]; 

delete from "VcopsServer" where id = [ID];

In our case 

delete from "VcVcops" where "vcopsServerId" = 1;

delete from "VcopsServer" where id = 1;

Now let's check and make sure the vROps instance is removed from UM. Press the up arrow three times and run the select command again. As we can see, there's 0 rows for "VcopsServer"

Now type "\q" to quit out of the database.

Going back to the Usage Meter console, we can now see the vROps instance is now removed from Usage Meter