OIM - SQL Query to get all the members of specific Role.

SELECT UGP.UGP_NAME,USR.USR_LOGIN
FROM UGP, USG, USR  
WHERE USG.USR_KEY = USR.USR_KEY
AND UGP.UGP_KEY = USG.UGP_KEY
AND UPPER(UGP_NAME) = UPPER('<Replace_Role_Name>');