on 07-23-2014 6:17 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.