SAP IDM query and views to get report of all valid dialogue users

[Syamkriz]

Dear SAP IDM development experts,

Good afternoon.

Kindly tell me the query to get all valid dialogue users . Browsing via database and looking at the documents , blogs and previous q&a on the topic I found that ,

1) MX_VALIDTO and MX_USERTYPE are attributes

2) mcattrname is the field to store the attribute entries that mentioned above.

3) Each users have a number represented in mcmskey ( in the view idmv_entry_simple_all), mcThisEntryMskeyvalue ( in the view mxiv_link_entry), mskey (in view idmv_vallink_basic) ,

I am not able to understand how to find the views and columns which says validity date and usertype of the each users , so that I can get the report. Could you please tell me which view and which column contains the data. My version is IDM 7.2

Thanks and Regards,

Syam

+91 9739007395

[Syamkriz]

Thanks Dominik , This worked like charm for me. I removed the (nolock) and its awesome. Apologies for late reply because I was shifting my kids away from covid region 🙂