Wednesday, April 15, 2015

Script to get the user login details in Siebel


Script to fetch the User login details.

SELECT C.FST_NAME,C.MID_NAME,C.LAST_NAME,U.LAST_LOGIN_TS
FROM SIEBEL.S_USER U INNER JOIN SIEBEL.S_CONTACT C
ON U.ROW_ID=C.ROW_ID
ORDER BY U.LAST_LOGIN_TS DESC ;


No comments:

Post a Comment