SQL Query to check all the plugins deployed in OIM

Question

I have to check what all plugins are deployed in my all the environments of OIM. I can do MDS export to check the same.

But I need a quicker solution to do the same.

Is there a SQL query to check the same?

Answer 1

Try using following SQL:

select name,zipid from plugins;