[sgkalluri]

Hello there,

I have a situation wherein I would like to know the session id which the user has logged into. As an example, we can get the user logged by @@USER_LOGGED or $_SESSION['USER_LOGGED']. Is there something like this for the session id?

Best wishes,
SGK

[hekmati]

you can get it from LOG_SID field in wf_<WORKSPACE>.LOGIN_LOG table by querying from last date of logging of current user (LOG_INIT_DATE) with LOG_STATUS='Active'

[sgkalluri]

Thanks for the reply.

Yes, this will work for regular login. However, when logging using web services, then no record is created in the login_log table.

Best wishes

[sgkalluri]

Hello,

I figured out what I need. It is the variable $_COOKIE['PHPSESSID']. This same variable is stored in the login_log table when normal login happens.

Best wishes