Report to find inactive Owners

[Alyson_Trad]

Which IIQ version are you inquiring about?

Version 8.4

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

I am looking for a report that spits out a list of entitlements that have an owner who is no longer active in the system. If this can be done for roles too that would be even better. I dont see an OOB one for this, wondering if anyone has something similar implemented in their environment.

[ashutosh08 (Ashutosh Singh)]

Hi @Alyson_Trad,

I have shared a basic report for Entitlement which gives you manager name and their status depending upon whether they are active or inactive. You can create a similar one for your role as well. Let me know if you need further help.

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE TaskDefinition PUBLIC "sailpoint.dtd" "sailpoint.dtd">
<TaskDefinition executor="sailpoint.reporting.LiveReportExecutor" name="ManagedAttribute Report" resultAction="Rename" significantModified="1718213326336" template="true" type="LiveReport">
  <Attributes>
    <Map>
      <entry key="TaskDefinition.runLengthAverage" value="3"/>
      <entry key="TaskDefinition.runLengthTotal" value="33"/>
      <entry key="TaskDefinition.runs" value="9"/>
      <entry key="report">
        <value>
          <LiveReport title="ManagedAttribute Status Summary Report">
            <DataSource objectType="ManagedAttribute" type="Filter"/>
            <Columns>
              <ReportColumnConfig field="value" header="Entitlement Value" property="value" sortable="true" width="110"/>
              <ReportColumnConfig field="displayName" header="Display Name" property="displayName" sortable="true" width="110"/>
              <ReportColumnConfig field="attribute" header="Entitlement name" property="attribute" sortable="true" width="110"/>
              <ReportColumnConfig field="application" header="Application Name" property="application.name" sortable="true" width="110"/>
              <ReportColumnConfig field="owner" header="Owner Name" property="owner" sortable="true" width="110">
                <RenderScript>
                  <Source>
                                        import sailpoint.object.*;
                                        if (value != null){
                    										System.out.println("value ::"+value);
                                        return value;
                                        }
                                        return "";
                                    </Source>
                </RenderScript>
              </ReportColumnConfig>
              <ReportColumnConfig field="ownerStatus" header="Owner Status" property="owner" sortable="true" width="110">
                <RenderScript>
                  <Source>
                                        import sailpoint.object.*;
                                        if (value != null){
                    										if(value.isInactive())
		{
			return "Inactive";
		}
		else
			return "Active";
                                        }
                                        return "";
                                    </Source>
                </RenderScript>
              </ReportColumnConfig>
              <ReportColumnConfig field="created" header="Creation Date" property="created" sortable="true" width="110"/>
              <ReportColumnConfig field="modified" header="Modification Date" property="modified" sortable="true" width="110"/>
            </Columns>
          </LiveReport>
        </value>
      </entry>
    </Map>
  </Attributes>
  <Description>Displays summary of ManagedAttribute</Description>
  <RequiredRights>
    <Reference class="sailpoint.object.SPRight" name="FullAccessIdentityCubeSummaryReport"/>
  </RequiredRights>
</TaskDefinition>

Thanks