on 07-31-2015 9:38 AM
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
Thanks to Pradeep Rawat. The table in 7.1 which i could easily find which entries were deleted are from mxi_old_values
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.