Saturday, 9 September 2017

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


2 comments:

  1. What is the point of the blog if one is unable to copy it from?

    ReplyDelete
  2. It helps me to at least try to understand the query.

    ReplyDelete