Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 31, 2015 at 01:21 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 31, 2015 at 09:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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