Hello and thanks for the response.
I am trying to determine a couple of different things.
- I want to be able to tell which of our users have NEVER logged into the system. If I compare my total users count against successful login attempts I see successful logins < total users. This I assume tells me that a number of my users have NEVER logged into the system.
I would like to be able to determine who these users are i.e., map the user_logins with users as well as determine when their account was created.
It seems to me that this information should be readily available within the TR DB however, I cannot easily find it.
I can map between user_logins and users by finding all usernames from user_logins who have a successful login and then I their Real name on a NON TR system at which point I can locate them in the USERS table. The assumption here is that anyone left in the USRES table has never logged in before.
Seems quirky and this still does not tell me when an account was created.