AnsweredAssumed Answered

Inactive user in CMN_sessions

Question asked by Krishna4452769 on Mar 27, 2014
Latest reply on Mar 27, 2014 by Chris Wuenstel

Hi All ,

 

We have an inactive user who is showing up while we run the below query. is this fine ?

 

SELECT CS.ID, SR.USER_ID,CSU.USER_NAME, SR.FULL_NAME, SR.UNIQUE_NAME, CS.CREATED_DATE
FROM SRM_RESOURCES SR,
CMN_SESSIONS CS,
CMN_SEC_USERS CSU
WHERE SR.USER_ID = CSU.ID AND
SR.USER_ID=CS.USER_ID
ORDER BY CS.CREATED_DATE DESC , UNIQUE_NAME

Outcomes