OIM - SQL Query to get all the Users having specific entitlement provisioned.
SELECT USR.USR_LOGIN, USR.USR_FIRST_NAME, USR.USR_LAST_NAME
FROM ENT_LIST EL, ENT_ASSIGN EA, USR
WHERE EL.ENT_LIST_KEY = EA.ENT_LIST_KEY
AND EA.USR_KEY = USR.USR_KEY
AND EA.ENT_STATUS = 'Provisioned'
AND EL.ENT_CODE = '<Replace_Entitlement_Name>';
What is the point of the blog if one is unable to copy it from?
ReplyDeleteIt helps me to at least try to understand the query.
ReplyDelete