Filter for requestResult in Detail Provisioning Transaction Report

IdentityIQ (IIQ) IIQ Discussion and Questions
, ,
1

Which IIQ version are you inquiring about?

Version 8.3

Share all details related to your problem, including any error messages you may have received.

I’m trying to filter by requestResult in Detail Provisioning Transaction Report. I’ve created a child report and added:

  <entry key="requestResult">
    <value>
      <List>
        <String>committed</String>
      </List>
    </value>
  </entry>

to the child report definition. This does not work. It works for a number of columns (ex: identityName, applicationName) but not for requestResult. What am I doing wrong?

I also tried:

  <entry key="requestResult" value="committed"/>
2

Hi Ioan,
Welcome to the Sailpoint Developer Community.
I am affraid you can’t get this information from Provisioning Transaction Report because of the simple reason - this information is not there. This is what you have in spt_provisioning_transaction table which is base for this report
image
that also explains why you can do that with eg. display name because it’s there.

If you tell me what is your goal you are trying to achieve maybe there’s another way to do that :slight_smile:

1 Like
3

Thanks for looking into this! I too investigated and the Detailed Provisioning Transaction Report includes this line:

The info is also present in the db in the Attributes column where it is part of the XML as planResult twice. This same XML object shows up as a ProvisioningTransaction object in the debug page:

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE ProvisioningTransaction PUBLIC "sailpoint.dtd" "sailpoint.dtd">
<ProvisioningTransaction accountDisplayName="10009" applicationName="app" created="1713260372312" id="0ad337068ecd13c0818ee646a1580c52" identityDisplayName="Sumant Peac" identityName="10009" integration="app" modified="1713260372313" name="0000000109" nativeIdentity="10009" operation="Modify" source="IdentityRefresh" status="Success" type="Auto">
  <Attributes>
    <Map>
      <entry key="planResult">
        <value>
          <ProvisioningResult status="committed"/>
        </value>
      </entry>
      <entry key="request">
        <value>
          <AccountRequest application="app" nativeIdentity="10009" op="Modify" targetIntegration="app">
            <Attributes>
              <Map>
                <entry key="provisioningTransactionId" value="0ad337068ecd13c0818ee646a1580c52"/>
              </Map>
            </Attributes>
            <AttributeRequest name="email" op="Set" value="[email protected]"/>
            <ProvisioningResult status="committed"/>
          </AccountRequest>
        </value>
      </entry>
    </Map>
  </Attributes>
</ProvisioningTransaction>

I’m trying to create a report that only shows committed transactions (vs filtered or failed ones) for a specific application.

4

I think you can just filter for status == success and channel == applicationName. If transaction is filtered than channel does not contain ApplicationName

1 Like
5

It was so much simpler than all the things I tried… Thank you!