Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question