How can I retrieve entitlements associated with uncorrelated accounts using reports?
Hi @shruthi_m,
you can start with this and change for your necessity:
<TaskDefinition executor="sailpoint.reporting.LiveReportExecutor" name="Custom Report" progressMode="Percentage" resultAction="Rename" subType="Custom Reports" template="true" type="LiveReport">
<Attributes>
<Map>
<entry key="report">
<value>
<LiveReport title="Account Group Membership Report">
<DataSource type="Hql">
<Query> from Link l, IdentityEntitlement ie,ManagedAttribute ma,Identity identity left outer join identity.manager m
where ie.value = ma.value and ie.application.name = ma.application.name and ie.name = ma.attribute
and l.application.name = ie.application.name and l.nativeIdentity = ie.nativeIdentity and l.identity.id = identity.id and identity.correlated = false
</Query>
<QueryParameters>
<Parameter defaultValue="Connected" property="ie.aggregationState" valueClass="sailpoint.object.IdentityEntitlement$AggregationState"/>
<Parameter defaultValue="true" property="ma.aggregated" valueClass="boolean"/>
</QueryParameters>
</DataSource>
<Columns>
<ReportColumnConfig field="identity" header="Username" property="l" sortable="true" width="80">
<RenderScript>
<Source>
import sailpoint.object.Link;
Link l = value;
return l.getIdentity().getName();
</Source>
</RenderScript>
</ReportColumnConfig>
<ReportColumnConfig field="lastname" header="Lastname" property="identity.lastname" sortable="true" width="110"/>
<ReportColumnConfig field="firstname" header="Firstname" property="identity.firstname" sortable="true" width="110"/>
<ReportColumnConfig field="email" header="Email" property="identity.attributes.email" sortable="true" width="110"/>
<ReportColumnConfig field="id-role" header="Role Code" property="ie.value" sortable="true" width="150"/>
<ReportColumnConfig field="desc-role" header="Name Role" property="ma.displayName" sortable="true" width="150"/>
</Columns>
</LiveReport>
</value>
</entry>
</Map>
</Attributes>
</TaskDefinition>
1 Like
Hi @shruthi_m,
You can utilize OOTB report "Uncorrelated Accounts Report " and add one extra column with existing ones to get entitlement details.
<ReportColumnConfig field="EntitlementName" header="Entitlement Name" property="attributes.entitlement_name" sortable="true" width="110"/>
Let me know if further input is needed.
Thanks
1 Like