We are on IDM 7.2,SP9
We have a requirement that we need to create report which can give below information-
1. When Access Workflow was Started with User, Business Role Requested Information.
2. Role Owner name with whom it is pending & for how long.
We can use BODS/ Business Objects for this reporting but need to create a customised SQL queries to fetch the information we need from IDM.
We need to find the IDM tables/views which contains below Information-
1. Business Role Requsted in Workflow.
2. User for whom access workflow is started.
3. Position Number of User.
4.. Time when Workflow was started.
5.. Role Owner name with whom it is pending.
4 Time for which it is pending with role owner.
We Tried to fetch information starored in IDM View -" MXWV_ALL_APPROVALS” but it is not giving all information we need such as
role owner name & above information, it is giving us below Information as in screen shot-
SELECT * FROM mxmc_oper.mxmv_all_approvals where status='WAIT'
Please advise if it is better to use BW reporting or HTML reports visa to ASCII pass to create report for above requirement.