Entitlement valid from and valid to date

Objective:

Getting information regarding entitlement start and end date from OIM database.

Let's start:

Start date and end date plays vital role for any iam system like forgerock, sailpoint, OIM and so on.
When it comes to the entitlement start date and end date, it may not give you this information on OIM GUI.

But there is a way to get these details from OIM database from ENT_ASSIGN  table.
Here is the query to do the same.

SELECT USR_LOGIN,EL.ENT_CODE "Entitlement Name",EA.VALID_FROM_DATE,EA.VALID_TO_DATE
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 UPPER(USR.USR_LOGIN) = UPPER('<USER_LOGIN>');

Conclusion :We are good to get the entitlement start and end date now :)




Comments

Post a Comment

Popular posts from this blog

BI Publisher Bursting

Image
Reports plays important part for management. It gives a birds eye view for a set of data, which allows the top management to take business decisions. BI publisher as a tool itself provides the reporting capability for OIM. Simple reports can be created by creating a data model which are backed by SQL; and delivering the report to the required participant by configuring destination under output as follows: But what if we want to deliver the single report by splitting it into different reports containing relevant data to the individual ? Bursting is the solution. Bursting is a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations. The data for the report is generated by executing a query once and then splitting the data based on a “Key” value. For each block of the data, a separate document is generated and delivered. Example implementations include: Invoice generation and delivery based on c
Read more

Assigning the “System Administrator” Role to the user

Assigning the “System Administrator” Role to the user step 1 : Login to the self-service Step2 : Click on “Manage” tab Step3 :Go to “Organisations” tab Step4 : Click on “Top” as Organization name Step5 : Go to “Admin” tab and select “System Administrator” as Admin Role Name Step6 : Click on Assign button Step7 : Select user, Click on add selected and then click on “select” button Step8 :Now you can see that user in the User Member’s list , select the “include sub-orgs” Step9 :Check“include sub-orgs”and click on Apply button
Read more