Sunday, June 28, 2026

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;

No comments:

Post a Comment

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