List of roles & their role owner

[youssef_anegay3]

Hello all

I have been looking for this, but could not find it

I would like to know the SQL request to retrieve the list of business roles and their relevant role owner. Just the same we have in the IdM web interface, in the "Manage" folder when we choose the roles. Anybody got that ?

Thanks !

[terovirta · Accepted solution]

with unique IDs

select mcThisMSKEYVALUE, mcOtherMSKEYVALUE from idmv_link_ext where mcAttrName = 'mx_owner' and mcThisOcName = 'mx_role'

or with displaynames

select b.mcDisplayName as 'role name', c.mcDisplayName as 'owner' from idmv_link_ext a, idmv_entry_simple b, idmv_entry_simple c
where a.mcAttrName = 'mx_owner'
and a.mcThisOcName = 'mx_role'
and a.mcThisMSKEY = b.mcMSKEY
and a.mcOtherMSKEY = c.mcMSKEY

regards, Tero

[youssef_anegay3 · Accepted solution]

The second one is exactly what i was looking for thanks Tero !!