Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 23, 2014 at 08:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded