Skip to Content
0
May 28, 2020 at 07:38 AM

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

273 Views

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