How to check in IDM 7.1 version, through which job the roles are added and deleted etc

[devaprakash_b]

Hello experts,

can you kindly let me know which tables i need to check in 7.1, to find when the roles have been added/deleted/modified to users.

In 7.2 we have table like idm_ovalue_basic which provides who modified and all

Thanks in advance

Regards,

DP

[devaprakash_b · Accepted solution]

Thanks to Pradeep Rawat. The table in 7.1 which i could easily find which entries were deleted are from mxi_old_values

[former_member198652]

Hi DP,

We can get the same values in  syslog table in IDM 7.2, but am not sure about the 7.1.

Check whether this query will be help full, select * FROM MC_SYSLOG where LOGTEXT like '%MSKEYVALUE%' 

Regards,

Jaya

[Former Member]

Hi DP,

You can try this select:

select LA.userMSKEYVALUE, LA.auditDate, LA.AssignmentMSKEYVALUE, LA.operationtext, LA.auditid, A.taskid, T.taskname

from idmv_linkaudit_ext LA

  left outer join mxp_audit A on A.AuditID = LA.auditid

  left outer join mxp_tasks T on T.taskid = A.TaskId

where LA.userMSKEYVALUE = 'USERID'

Regards

Kiril