I want to take out list of roles in IDM with role owners and functional area it belongs..

[Former Member]

I want to take out list of roles in IDM with role owners and functional area it belongs..

Plzz help

rgdz........kk

[Former Member]

Hi Krishna

Do you want to do this through SQL ? like:

select * from idmv_value_ext where mskey in (select mskey from idmv_value_ext where attrname='MX_ENTRYTYPE' and searchValue='MX_ROLE' and is_id=1) and attrname in ('MSKEYVALUE','MX_ENTRYTYPE','MX_OWNER','DISPLAYNAME'

)

Best regards
Roy T

[Former Member]

Hi,

You can improve the performance of this statement by using the idmv_entry_simple view as the inner select in this statement. This works towards the mxi_entry table, which already holds the entry type.

( select mcMSKEY from idmv_entry_simple

where mcEntryType='MX_ROLE')

And if you were not interested in the owner, you could pull all the other attributes (mskeyvalue, entrytype and displayname) from this view.

Best regards

John Erik Setsaas

Development Architect SAP NW IdM