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';