Tuesday, November 25, 2025

Content Assist set up in Eclipse

# Open the Eclipse application

# Navigate to Windows > click on Preferences

# Navigate to Java and expand it

# Navigate to Editor and expand it

# Navigate to Content Assist and click on it

# Navigate to Auto Activation > Enable Auto Activation 

    Auto Activation > Auto activation triggers for Java

            Enter the following Characters :

            abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ._

Sunday, November 23, 2025

Saturday, November 22, 2025

End of Support Policy

 
End of Support Policy :
IdentityIQ and File Access Manager End of Support Policy - Compass

https://community.sailpoint.com/t5/Working-With-Support-Knowledge/IdentityIQ-and-File-Access-Manager-End-of-Support-Policy/ta-p/77580#toc-hId-447416239

Monday, November 17, 2025

Fetch Entitlements Based on IT Role

SELECT

    b.name AS IR_Role_Name,

    b.type AS Role_Type,

    pr.value AS ENT_Value,

    a.name AS Application_Name

FROM

    identityiq.spt_bundle b

JOIN

    identityiq.spt_profile_relation pr ON pr.bundle_id = b.id

JOIN

    identityiq.spt_application a ON a.id = pr.source_application

WHERE 

b.name ='Pedia - IT - DPA Role';


#####################################################

SELECT

    b.name AS it_role_name,

    pc.elt AS constraint_value   

FROM

    identityiq.spt_bundle b

JOIN

    identityiq.spt_profile p ON p.bundle_id = b.id

JOIN

    identityiq.spt_profile_constraints pc ON pc.profile = p.id

WHERE 

b.name ='Pedia - IT - DPA Role';

Fetch Business Roles based on IT Role

SELECT

    br.id            AS business_role_id,

    br.name          AS business_role_name,

    br.type          AS business_role_type,

    it.id            AS it_role_id,

    it.name          AS it_role_name,

    it.type          AS it_role_type

FROM identityiq.spt_bundle_requirements r

JOIN identityiq.spt_bundle it ON it.id = r.child

JOIN identityiq.spt_bundle br ON br.id = r.bundle

WHERE 

it.name = 'Pedia - IT - DPA Role';

Fetch Roles based on Container Role Name

SELECT

    br.name         AS it_or_business_role_name,

    br.type           AS it_or_business_role_type,

    it.name          AS org_role_name,

    it.type            AS org_type

FROM identityiq.spt_bundle_children c

JOIN identityiq.spt_bundle it ON it.id = c.child

JOIN identityiq.spt_bundle br ON br.id = c.bundle

WHERE 

it.name = 'Pedia - IT - DPA Role';

=================================================================

import java.util.ArrayList;

import java.util.List;

import sailpoint.api.SailPointContext;

import sailpoint.object.Bundle;

import sailpoint.object.Filter;

import sailpoint.object.QueryOptions;

import sailpoint.tools.GeneralException; 


private static List getRolesBasedOnContainer(String container) {

List aList = null;

QueryOptions qo = null;

try {

aList = new ArrayList();

qo = new QueryOptions();

qo.add(Filter.eq("inheritance.name", container));

List<Bundle> objects = context.getObjects(Bundle.class, qo);

for (Bundle bundle : objects) {

aList.add(bundle.getName());

}

} catch (GeneralException e) {

System.out.println("GeneralException : " + e.getMessage());

}

return aList;

}

String container = "Pedia - IT - DPA Role";

List bundles = getRolesBasedOnContainer(container);

Access Intelligence Center

  Search Overview - SailPoint Identity Services https://documentation.sailpoint.com/saas/help/search/index.html