ISC PAT Generation

 High-Level Steps:-

# Login to SailPoint ISC tenant.

# Navigate to your profile/name, it is available on leftside topmost.

# Navigate to Personal Access Tokens

# Click on New token

# Provide the name of the token, remove the expiration date,  and give the scope is sp:scopes:all

# Click on create

# PAT contains Secret and Client ID

Note: 

Any user with admin access to the tenant can create up to 10 tokens.

PAT - Personal Access Token

Sailpoint ISC URL's & Paths

ISC Tenant URL :
https://{{tenant}}.{{domain}}/login/login/?brand=default

ISC Docs:
https://documentation.sailpoint.com/saas/help/index.html

ISC Glossary URL:
https://documentation.sailpoint.com/saas/help/common/glossary.html

ISC Developer Community URL: 
https://developer.sailpoint.com/docs/

ISC Postman Setup URL:
https://developer.sailpoint.com/docs/api/postman-collections
https://www.postman.com/sailpoint/identitynow/overview
Token URL : https://[tenant].api.identitynow.com/oauth/token

ISC API's URL:
https://developer.sailpoint.com/docs/api

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>