IBM Security Verify

 View Only
Expand all | Collapse all

Approval Request "Processed By" in Security Identity Manager

  • 1.  Approval Request "Processed By" in Security Identity Manager

    Posted Mon December 02, 2019 09:15 AM
    Hello,

    Within the operational workflow, is there any way to get the name or DN of person who actually processed the approval request. The request is sent for approval to an ISIM group which contain multiple persons.

    ------------------------------
    Best regards,

    Muhammad Hamza
    ------------------------------


  • 2.  RE: Approval Request "Processed By" in Security Identity Manager

    Posted Mon December 02, 2019 09:30 AM
    That is one of the real FAQ for ISIM - alas the answer is more muddy ;-)

    There is no ootb JavaScript method that provides this - but using the API you can find the actual itim user approving the request and from there the DN of the person.

    I do not have a sample handy - if nobody is faster to dig one up I will see if I can find some pseudo code showing the logic during the week - this is no promise as my availability is challenged :-)

    ------------------------------
    Franz Wolfhagen
    IAM Technical Architect for Europe - Certified Consulting IT Specialist
    IBM Security Expert Labs
    ------------------------------

    Original Message


  • 3.  RE: Approval Request "Processed By" in Security Identity Manager

    Posted Mon December 02, 2019 09:45 AM
    Hi Muhammad...

    I've done similar in the past, with custom JavaScript Extension that essentially would take in the ID of the Approval Activity, and execute an SQL Query...similar to the following:

    //db2Conn = DriverManager.getConnection("jdbc:db2://127.0.0.1:50000/itimdb","itimuser","itimuser");
Connection db2Conn = DriverManager.getConnection(dbURL,dbUID,dbPWD);
Statement st = db2Conn.createStatement();
String myQuery = "SELECT REQUESTOR FROM ITIMUSER.PROCESSLOG WHERE ACTIVITY_ID = " + actid + " AND EVENTTYPE = 'CM'";
System.out.println("QUERY: " + myQuery);
ResultSet resultSet = st.executeQuery(myQuery);
resultSet.next();
String apprvr = resultSet.getString("REQUESTOR");
System.out.println("APPROVER: " + apprvr);
resultSet.close();
st.close();
db2Conn.close();​
return apprvr;


    ------------------------------
    Grey Thrasher
    IBM
    ------------------------------

    Original Message