If I wanted to get a list of users and their last activity in TR - can I use the Sessions table to do this? Is the sessions table a list of users currently logged into TR and as soon as they log out - the users records are removed from the table?
For as long as we have had TR - the sessions table has less than 100 records so there must be adding in and then removing records from the table. Maybe as long as you do not click on logout and just close the browser the session record does not get removed?
The end all of the question is - can we determine who is active in TR via SQL and the tables or who has not logged in in the past 30+ days so we can make then inactive.
We did find the User_Logins table - will the updated_on field work for what we want to do?