Entitlement export

[ramthetribo (Ramakrishnan Narayanasamy)]

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.

hello All,

Added below one under entitlementCatalogTableColumns in the UI Config to show the created date of the entitlement.
ColumnConfig dataIndex=“created” dateStyle=“short” groupProperty=“created” headerKey=“Created” property=“created” sortProperty=“created” sortable=“true” stateId=“created” width=“150”

Am trying to get created show up in the Entitlement export too.
Can you please let me know what config i should look at to get created show up in entitlement export task

Thanks in advnace!

[vishal_kejriwal1 (Vishal Kejriwal)]

@ramthetribo

below one under entitlementCatalogTableColumns in the UI Config to show the created date of the entitlement.
ColumnConfig dataIndex=“created” dateStyle=“short” groupProperty=“created” headerKey=“Created” property=“created” sortProperty=“created” sortable=“true” stateId=“created” width=“150”

Are you talking about ootb export EC option ? today you need to export 2 times to get the full details , one with description and other one with remaining attributes . I don’t think any ootb option to add created , even thought you add that value will come in epoc time .

better i would say write a custom report / task to get the required value in one sheet and also you can add any additional column and will have more control over any transformation .

[ramthetribo (Ramakrishnan Narayanasamy)]

Hi Vishal,

Yes, i was trying to get it done via ootb export in EC.
Thanks for the inputs. Before start working on the custom report, wanted to see whether we can tweak ootb to get expected results.
Will setup custom reports.

Thanks!

[vishal_kejriwal1 (Vishal Kejriwal)]

I don’t think that would be possible using ootb option using EC export .

[ashutosh08 (Ashutosh Singh)]

Hi @ramthetribo,

You may use the below sample report to take out the created date along with few other details. Feel free to add extra attribute as per your use-case.

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE TaskDefinition PUBLIC "sailpoint.dtd" "sailpoint.dtd">
<TaskDefinition executor="sailpoint.reporting.LiveReportExecutor" name="ManagedAttribute Report" resultAction="Rename" template="true" type="LiveReport">
  <Attributes>
    <Map>
      <entry key="TaskDefinition.runLengthAverage" value="4"/>
      <entry key="TaskDefinition.runLengthTotal" value="18"/>
      <entry key="TaskDefinition.runs" value="4"/>
      <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="created" header="Creation Date" property="created" 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

[ramthetribo (Ramakrishnan Narayanasamy)]

Hi @ashutosh08
It worked. Thank you very much!