We have a limited amount of licenses and we need more but… management.
Anyway - I need to find a good way via SQL to report on users that have not been assigned a run or creating cases in the last XX days so we can inactivate users that are not currently testing. I am going to assume that the API does not have anything to really help with this as well.
I know I can’t use the Sessions table as records from that table are deleted when 30 days old… Other than that - am I correct that the only other way to do this is to use the Changed_on/Changed_by and Updated_on/Update_by on several tables (cases/runs etc…) and find the max date per user (most recent create/update), calculate how many days in the past for each one and filter for those XX days old.
Any other way/suggestions? We are on 4.1 right now with self hosted TR. Naturally will not update anything in the DB - just straight up query.
Would Gurock consider adding a setting in the Administration to determine how many days to save the Sessions data with a default of 30? That would help a ton if we could set it to 120 days - give us a lot clearer idea of who has not logged in recently (naturally we would have to add in a rule for users to log out after testing).