How to get the all users list along with their assigned roles/privileges/groups in SAP IDM?

[Former Member]

Hi Dear,

I am searching for all users list along with their assigned roles/privileges/groups in SAP IDM?

How to pull the list and which views and tables we need to use?

Our main aim is to pull the list of users who don't have any access in SAP IDM at all.

Regards,
SD

[Former Member · Accepted solution]

Thanks Matt You Help me to get the list.

select ent.mcmskey as PersonMsKey, ent.mcmskeyvalue as UniqueUserID, ent.mcdisplayname as UserDisplayName from idmv_entry_simple_all ent where ent.mcentrytype='MX_PERSON' and ent.mcmskey not in (select lnk.MCTHISMSKEY from idmv_link_ext lnk where lnk.mcthisocname='MX_PERSON') ;

[former_member2987]

Hi Sudheer,

This is fairly easy, run a query on the idmv_link_ext table. It should give you the information you need. If you can't get direct access to the database, run a To ASCII pass with the query in the source and then output as a CSV. You can bring the data into Excel to see which columns are useful to you and then tailor the query or just process from Excel.

This should put you on the right path 🙂

Matt