IDM8.0 SQL Statement question

[former_member243324]

Hi SQL/IDM Experts,

What is the SQL statement for the following,

     1. All Historical Values Record for user

     2. All Entry Data for user

     3. All Assignment History for user

Thank you!!

Shunji

[former_member243324 · Accepted solution]

Thank you Matt and DP, I got it !!

Do you have any idea how can I get all change history for "Role" changes? ( We don't have this option or tab on UI page )

I went through the document and I cannot find it.

Thank you!!

[devaprakash_b · Accepted solution]

HI shunji,

please use the view idmv_ovalue_basic_all view for history of changes for any entry type with help of mskey using column change type is delete/modify

regards,

dp

[devaprakash_b]

Hi Shunji,

Kindly refer to the below help link of idm for more details.

https://help.sap.com/saphelp_nwidmic72/en/dse.htm

As mentioned by Matt, the schema is idm 8.0 schema and tables are same as 7.2. Kindly refer to the views idmv_value_basic/idmv_vallink_basic, idmv_ovalue_basic_all views.

regards,

DP

[former_member2987]

Hi Shunji,

Please take a look here on the forum and in the blogs.  The schema is basically the same for 7.2 and 8.0.

If you have questions after that, please let us know.

Matt