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;