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

The old company comeup with new brand MAXBEN - Logo meaning

I am so happy to design this logo for my friend Suresh Mahalingam to boost his paint business to the next level. The first step in his process is logo design. He had a clear idea about his business, processes, pricing and target audience. I just collect all those information from him and created the logo with some appropriate meanings. Check out the logo here