sys_user_session table

[Maxwell3]

Hello all,

I just have a question about the 'sys_user_session' table. Does anyone know when the 'invalidated' field get updated. I was looking into the 'sys_user_session' table, and some of the records in the invalidated field are empty and some have dates in them. We have a couple of widgets which are querying the 'sys_user_session' table. I wanted to tweak the conditions in the query but I need to know how the 'invalidated' field gets updated.

Thank you,

[Michael Jones - · Accepted solution]

I can tell you that blank means either "Still active" or "Not properly closed out" as in the user is either still active in the session or; they are idle in the browser or have closed that browser. You can identify the first scenario by looking at the last accessed date; if it's recent, they're still there, if it's not they're probably one of the latter cases. 

That field is populated with a date when a user clicks the logout button or when the session limit has been reached and the user is logged out. 

I can't tell you exactly what mechanism performs the update at logout, but you can see it occurring if you log log in with different sessions (incognito window) etc. 

I hope this helps!

If this was helpful or correct, please be kind and remember to click appropriately!

Michael Jones - Proud member of the CloudPires team!