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