How to get Report from IDM to see time taken in Business role raise till final approval
We have a requirement, where we need to see how much time it take for business role raised till final approval.
Can we fetch this report through SQL queries.
In 7.2 you should start looking at the link audit, idmv_linkaudit_<> views. Example
select linkid,userMSKEYVALUE,AssignmentMSKEYVALUE,OperationText,auditdate from idmv_linkaudit_ext where linkid in
(select mcUniqueId from idmv_link_basic_active where mcThisMskey = (select mcMskey from idmv_entry_simple where mcMSKEYVALUE='ADMINISTRATOR'))
Go from there, use the columns to add additional filters for specific assignments etc.
If you inspect the view you can see operation codes as well that you can filter on, 1 is initial request, 2 is final approval (by system after all manual approvals are received), 14 someone clicked the approve button. Look at mxi_link_audit_operations for a list.