Capability Report for inactive Identities

[Alyson_Trad]

Which IIQ version are you inquiring about?

Version 8.2

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

I am looking for a modification/ new report that is basically the same as the Identity to Capability Report, but I would like another column added that states the status of the identity. We have the attribute Inactive and it is either TRUE or FALSE.

[vishal_kejriwal1 (Vishal Kejriwal)]

try this one

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE TaskDefinition PUBLIC "sailpoint.dtd" "sailpoint.dtd">
<TaskDefinition  executor="sailpoint.reporting.LiveReportExecutor"  name="Vishal Capabilities per Identity" progressMode="Percentage" resultAction="Rename" subType="Identity and User Reports" template="true" type="LiveReport">
  <Attributes>
    <Map>
      <entry key="report">
        <value>
          <LiveReport title=" Capabilities per Identity report">
            <DataSource defaultSort="name" objectType="Identity" type="Filter">
              <Query>(capabilities.name.notNull() || workgroups.capabilities.name.notNull())</Query>
            </DataSource>
            <Columns>
              <ReportColumnConfig field="displayName" header="displayName" property="displayName" sortable="true" width="110"/>
              <ReportColumnConfig field="directcapabilities" header="direct capabilities" property="capabilities.displayName" sortable="true" width="110"/>
              <ReportColumnConfig field="workgroupcapabilities" header="capabilities through workgroup" property="workgroups.capabilities.displayName" sortable="true" width="110"/>
            </Columns>
          </LiveReport>
        </value>
      </entry>
    </Map>
  </Attributes>
  <Description>Displays the capabilities that identities have in IdentityIQ</Description>
</TaskDefinition>

[vishal_kejriwal1 (Vishal Kejriwal)]

Add below to get status
<ReportColumnConfig field="inactive" header="Inactive" property="inactive" sortable="true" width="110"/>

[enistri_devo (Emanuele Nistri)]

Hi @Alyson_Trad,

First of all I suggest to you the very short guide on reports

8.4 IdentityIQ Reports Guide

So, you can try to add something like this:

ReportColumnConfig field="status" header="Status" property="name" width="110">
        <RenderScript>
          <Source>import sailpoint.object.Identity;
            import sailpoint.api.*;
        		Identity idn = context.getObject(Identity.class,value);
        		return idn.isInactive == "true" ? "Active" : "Inactive";
        </Source>
        </RenderScript>
      </ReportColumnConfig>

but is better if you create a new custom report, personally i dont like work on SP LiveReport