SailPoint IDM - Database Tables

# User master table, consist of firstname, lastname, email etc.
select  * from spt_identity

# Entitlement
select * from spt_identity_entitlement

# Roles
select * from spt_bundle

# Application table details like HR, Finance, PAM application etc.
select * from spt_application

# Managed attributes details like type entitlement, group etc.
select * from spt_managed_attribute

# Profiles related table
select * from spt_profile

select * from spt_profile_constraints

select * from spt_bundle

# Request manage access table
select * from spt_identity_request_item

# Access request table - with completion status, requester, approver etc.
select * from spt_identity_request

# Plugin listing table
select * from spt_plugin

# Password policies
select * from spt_password_policy

# Capabilities
select * from spt_capability

select * from spt_capability_rights

select * from spt_capability_children

# Request Details SQL

SELECT 

SPT_IDENTITY_REQUEST.NAME AS REQUESTID,

    SPT_IDENTITY_REQUEST.COMPLETION_STATUS AS REQUESTIDSTATUS,

    '"'||SPT_IDENTITY_REQUEST_ITEM.APPLICATION||'"' AS APPLICATIONNAME,

    '"'||SPT_IDENTITY_REQUEST.TARGET_DISPLAY_NAME||'"' AS REQUESTEENAME,

    SPT_IDENTITY_REQUEST_ITEM.OPERATION AS OPERATION,

    SPT_IDENTITY_REQUEST_ITEM.PROVISIONING_STATE AS PROVISIONINGSTATE,

    '"'||SPT_IDENTITY_REQUEST_ITEM.NAME||'"' AS ATTRNAME,

    '"'||SPT_IDENTITY_REQUEST_ITEM.VALUE||'"' AS ATTRVALUE

    FROM SPT_IDENTITY_REQUEST,

SPT_IDENTITY_REQUEST_ITEM 

    WHERE 

    SPT_IDENTITY_REQUEST.ID=SPT_IDENTITY_REQUEST_ITEM.IDENTITY_REQUEST_ID AND 

    SPT_IDENTITY_REQUEST.TYPE='AccessRequest' AND 

    SPT_IDENTITY_REQUEST_ITEM.PROVISIONING_STATE != 'Finished' AND 

    SPT_IDENTITY_REQUEST.COMPLETION_STATUS IN ('Failure','Incomplete') AND  

    SPT_IDENTITY_REQUEST_ITEM.OPERATION != 'Set' AND 

    ((CAST(SYS_EXTRACT_UTC(CURRENT_TIMESTAMP) AS DATE) - TO_DATE('1970-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS')) * 86400*1000) -1*86400*1000 < SPT_IDENTITY_REQUEST.END_DATE