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