Sailpoint Identity IQ Reading Data from Custom Table

Reading Data from the Custom Table created in the Sailpoint identity IQ Database ,

Once the table is created within the IdentityIQ database, it can be queried like any JDBC connection.  However, the advantage of using a table within the IdentityIQ database is that the connection to the database can be obtained from the IIQ context rather than having to store the URL, username, and password within the code itself.

Below sample code can be used in any places , such as showing the data in the Form (from custom table) , Rules or Workflow

   List itemList = new ArrayList();
            
   try{

   String  columnSearch = "ACCOUNT_ID";
   String  tableName = "VIS_SERVICE_ACCOUNT";
   String  conditionColumnName = "ACCOUNT_ID";
   String  sqlStatement ="select "+columnSearch+" from "+tableName;
   Iterator it = context.search("sql:"+sqlStatement, null,null);

    while ((null != it) && it.hasNext()) {
      String i= it.next();
      if(!itemList.contains(i)) {
       itemList.add(i);
      }
    }
   Util.flushIterator(it);
   }
   catch(GeneralException ex){
    logger.error("Error in form : " +ex.getMessage());
   }
   return itemList;

Sailpoint IIQ Audit WorkFlow using OOTB Audit Method

If you want to add custom auditing to existing Audit method in a workflow or any where in the call etc., it's as easy as below, creating and call a audit method and setting the Action, Source, Target and values.

Here we need to make sure that we are adding proper action and source so that it's easily tracked.  

<Step action="call:audit" icon="Audit" name="Audit" posX="920" posY="91">
    <Arg name="string1" value="value1"/>
    <Arg name="string2" value="value2"/>
    <Arg name="string3" value="value3"/>
    <Arg name="string4" value="value4"/>
    <Arg name="action" value="Service Account Management"/>
    <Arg name="source" value="Service Account Management"/>
    <Arg name="target" value="spadmin"/>
    <Description>This step is use to Audit the Operation performed and the Values set during the operation.</Description>
    <Transition to="Stop"/>
  </Step>

Enable the Audit from the Audit Config Object from the Sailpoint IIQ Debug Page  

Use the Advance Analytics and Use Search Type as Audit to see the Entry