마지막 로그인 시간
SELECT cwd_user.user_name ,cwd_user.DISPLAY_NAME ,cwd_user.active ,to_date('01-01-1970', 'DD-MM-YY') + ( 1 / 24 / 60 / 60 / 1000) * ca.attribute_value AS "Last Login" FROM cwd_user join cwd_user_attribute ca ON cwd_user.id = ca.user_id WHERE ca.attribute_name = 'lastAuthenticated' AND cwd_user.active = 'T' ORDER BY "Last Login";
active or inactive 사용자 조회
SELECT user_name ,DISPLAY_NAME ,active FROM cwd_user WHERE active = 'T'; -- or WHERE active ='F';
active or inactive 사용자 수 조회
SELECT COUNT(*) AS USER_CNT FROM cwd_user WHERE active = 'T'; -- or WHERE active ='F';