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

Using OIMService API for raising request

With the latest R2PS2 release OIMService API is been provided to raise any kind of request in OIM. It is a simple yet powerful API with single method which can generate any kind of request. It uses Android’s Intent concept to let the framework decide what to do at runtime by exposing following method. OperationResult   doOperation(RequestData requestData,OIMService.Intent intent) Invoking  doOperation  method will result into either request creation or direct operation based on the Intent passed. The intent value can be “ ANY “, “ REQUEST ” or  “ DIRECT “. If Intent is “ ANY “, operation will result in to either request or direct based on authorization of logged-in user. If Intent is “ REQUEST “, a request will be created for the operation. If Intent is “ DIRECT “, operation will be performed immediately, subject to authorization of logged-in user. Very important aspect of using entity key for entitlement is as follows: If you are working on g...
Read more

Troubleshooting Scheduler plugin in OIM

Objective : To understand how to troubleshoot issues with scheduler plugin registered in OIM. Prerequisites: Basic understanding of plugin registration and plugin structure. Understanding of Scheduler and its related artifacts this can be read here . Lets Start: Many a times we face challenges while working with scheduler in OIM. These challenges can be listed as follows: Plugin registration is completed successfully, but still metadata file is not present in mds. Plugin registration is completed successfully, Unable to find metadata file to create scheduled Job. Plugin registration is completed successfully, metadata file also present and scheduled job is also created but its failing and throwing NullPointerException. Plugin registration is completed successfully, but unable to find jar and metadata. and so on.... do let me know if you face any issue other than these: To troubleshoot this here are the steps you should check for: Plugin registration nee...
Read more

Creating simple Prepopulate Adapter in OIM

Image
Objective: For provisioning any target resource some user information needs to be passed to the user. This information can be filled  and submitted for each user manually which is not efficient process. We can automate this process by creating pre-populate adapters and attaching them in the process form. Here we will create a simple logical task adapter which copies user first name from user profile to target’s process form. Prerequisite:  Access to design console and Some Application Instance which can be provisioned to user. Let’s Achieve this: Open designconsole by running  xlclient.sh from /home/oracle/Oracle/Middleware/Oracle_IDM1/designconsole/ from this path. Login to design console Double click on Adapter Factory Enter the details as follows and Click on Save Go to  Variable List tab Click on Add to  create a variable and enter the details as follows: Click on save and close. Go to Adapter Tasks tab  ...
Read more