Skip to main content

Export user details from ATG


Use the following query to export user details from database directly

SELECT CORE.dps_user.id as User_ID, CORE.dps_user.first_name, CORE.dps_user.email, CORE.dps_user.realm_id, CORE.dps_user_org.organization
FROM CORE.dps_user
INNER JOIN CORE.dps_user_org 
ON  CORE.dps_user.id= CORE.dps_user_org.user_id
ORDER BY CORE.dps_user.realm_id

Popular posts from this blog

#ThankYouCitrisys

MAY 5, 2015 an unforgettable day in my life. Why this award is so special to me? Because, after 8 years (After completion of Engineering), I landed on a good place where they identified me and involved me in the good projects with suitable PMOs. With all their support in Citrisys, I did small things with my involvement. For that, Citrisys, awarded me this "Award of Excellence". This award not shows me the best performance, but, it shows me to work more and more. Thank you Mr.ARA (CEO, Citrisys Solutions) for this award. #ThankYouCitrisys

Citrisys Poster Competition work 02