ISC Docs URL

https://developer.sailpoint.com/docs/

Identity Security Cloud | SailPoint Developer Community

Fetch the pending ARs associated with the BR

SELECT

c.Name as AR,

TO_CHAR (TO_DATE ('19700101', 'YYYYMMDD') + (p.created / 1000 / 60 /60 / 24), 'DD/MM/YYYY HH24:MI') AS "P CREATED DATE",
TO_CHAR (TO_DATE ('19700101', 'YYYYMMDD') + (p.end_date / 1000 / 60 /60 / 24), 'DD/MM/YYYY HH24:MI') AS "P END DATE",
TO_CHAR (TO_DATE ('19700101', 'YYYYMMDD') + (c.created / 1000 / 60 /60 / 24), 'DD/MM/YYYY HH24:MI') AS "C CREATED DATE",
TO_CHAR (TO_DATE ('19700101', 'YYYYMMDD') + (c.end_date / 1000 / 60 /60 / 24), 'DD/MM/YYYY HH24:MI') AS "C CREATED DATE",

c.Name,
c.Value AS BR,
c.approver_name,
C.operation,
c.approval_state,
c.provisioning_state,
c.compilation_status,
c.identity_request_id 

FROM identityiq.spt_identity_request_item c
JOIN identityiq.spt_identity_request p ON p.id = c.identity_request_id

WHERE c.name = 'assignedRoles' AND
(VALUE IN ('IIQ Role', 'ISC Roles'));

Fetch the roles base on Organizational Role

SELECT

br.name AS itr_or_br,
br.type AS itr_br_type,
it.name AS org_role_name,
it.type AS org_type

FROM identityiq.spt_bundle_children r
JOIN identityiq.spt_bundle it ON it.id = r.child
JOIN identityiq.spt_bundle br ON BR.ID = r.bundle

WHERE
it.name = 'ISC IT - Container'; 

Fetch the ENT membership details based on Logical ENT attribute

 SELECT

    i.name AS identity_name,

    ma.value,

    ma.DISPLAY_NAME,

    ma.ENT_APP_Name

FROM spt_identity i

JOIN spt_identity_Entitlement ie ON ie.Identity_ID = i.id

JOIN spt_managed_attribute ma ON ma.value = ie.value

WHERE ma.ENT_APP_Name = 'PLV' 

ORDER BY i.name;

Access Intelligence Center

 Search Overview - SailPoint Identity Services

https://documentation.sailpoint.com/saas/help/search/index.html

Search

 Search :

Search Overview - SailPoint Identity Services

https://documentation.sailpoint.com/saas/help/search/index.html

SailPoint Support Portal

SailPoint Support Homepage - Customer Support

https://support.sailpoint.com/csm

SailPoint Developer Community

SailPoint Developer Community

https://developer.sailpoint.com/

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._

Link or HyperLink in EmailTemplates

 <a href="http://localhost:8080/identityiq/workitem/WorkItem.jsf?id=$item.id">Link</a>

Refresh Task Options for Joiner

# Process Events

# Identity Attributes

# Manager Status