Query to Join on the same table

Below query helps us in getting User login and Manager login in single query
Basically in OIM USR table we have user user key, user login and manager key fields, so if we want User login and Manager login in the single query we can use below query.


select u.USR_KEY,u.USR_LOGIN,u.USR_DISPLAY_NAME,
u1.USR_KEY as "Manager USR_KEY",u1.USR_LOGIN as "Manager Login",u1.USR_DISPLAY_NAME as "Manager DisplayName"
from usr u
join usr u1 on u1.USR_KEY = u.USR_MANAGER_KEY
--where u.usr_login ='User login  Id';

Comments

Post a Comment

Popular posts from this blog

Rules in Sailpoint

Rules in Sailpoint Below are few commonly used rules in Sailpoint Sailpoint rules gets executed in the below order during aggregation Flow: Pre-Iterate Rule BuildMap Rule Managed Entitlement Customization Rule Customization rule Correlation rule Manager correlation rule Creation rule PostIterate Rule Pre-Iterate Rule: 1st rule that runs during aggregation You can perform below operations in this rule Check file existence Modify the data in the files Merge files BuildMap Rule: 2nd Rule thats runs during aggregation, Using build map rule you can deal with application schema ex: populate value for custom column for the application. Build map is not available for connected apps(JDBC has jdbc buildmap). Available only for disconnected apps like delimited files. Customization Rule:  Runs after buildmap rule, this can be used to transform data of resource object/account data during account aggregation Ex: if you have status value...
Read more

Sailpoint Installation Steps (IdentityIQ 7.3 Installation in Windows Machine)

This document helps you set up Sailpoint IdentityIQ 7.3 in Windows Operating System Softwares Required: MySQL 5.6 server Click here to download Apache Tomcat  9.0 Click here to download Java JDK 1.8 and above Click here to download Sailpoint IdentityIQ 7.3 application You may require to login into Sailpoint community to download Install the above softwares, update JDK, MySQL paths in environment Path variable Note: If you are facing issue in MySQL service then try running below commands mysqld –install net start mysql Sailpoint Configuration Steps: Create an \idenityiq directory under the Tomcat webapps directory: for example, C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\identityiq Unzip the identityiq-7.3.zip file. Copy iidentityiq.war file to the C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\identityiq Run below command to extract identityiq.war jar -xvf C:\Program Files\Apa...
Read more

How to develop a Scheduler in OIM

Image
Below steps help us in developing a new Scheduler in OIM 11G R2 PS3. Create a new Java project in Eclipse and add external jars from design console(you can add whatever Jars required for your scheduler) Create a new class which extends oracle.iam.scheduler.vo.TaskSupport as super class Write your business logic in Execute method Below is the basic structure of the Scheduler package com.ghr; import java.util.HashMap; import oracle.iam.scheduler.vo.TaskSupport; public class UpdateTCADRemovalDate extends TaskSupport { @Override public void execute(HashMap taskparams) throws Exception { // TODO Auto-generated method stub } @Override public HashMap getAttributes() { // TODO Auto-generated method stub return null; } @Override public void setAttributes() { // TODO Auto-generated method stub } } 3. Reading Task input parameters All the task input parameters available in taskparams variable which is of...
Read more