How to get Report from IDM to see time taken in Business role raise till final approval

[Former Member]

Hi Experts

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.

Aman

[Former Member · Accepted solution]

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.

Br,

Chris