How to obtain the last login date and time for users in Raisers Edge?

We are doing a year USER audit of all accounts setup in Raisers Edge and would like to determine how best to obtain the last time a user would have logged into Raisers Edge. 
 
We have access to the SQL USER table, but it only seems to include the date that the USER record was created and doesn't keep track of when the user lasted logged in. How would we obtain this type of information?
The SQL table which stores the user login and logout information is the LOGINAUDIT table. Please see the RE Schema documentation for more information on the LOGINAUDIT table, including a listing of all fields.  Among them are LOGIN_TIME, LOGOUT_TIME, MACHINENAME, as well as USER_ID and USER_NAME.

Some examples of SQL queries to display this information are listed below:

/*After specific date*/
select * from LOGINAUDIT
where USER_NAME not in ('Shelby','Integration User','Synchronization User')
AND LOGIN_TIME > '2016-01-01 00:00:01.000'
order by LOGIN_TIME;

/*Complete History*/
select * from LOGINAUDIT
where USER_NAME not in ('Shelby','Integration User','Synchronization User')
order by LOGIN_TIME;

/*Specific time frame*/
select * from LOGINAUDIT
where USER_NAME not in ('Shelby','Integration User','Synchronization User')
AND LOGIN_TIME > '2016-01-01 00:00:01.000'
AND LOGIN_TIME < '2016-01-13 23:59:59.000'
order by LOGIN_TIME;

/*Specific User Account*/
select * from LOGINAUDIT
where USER_NAME like '%Exact_RE_Username%'
Note: Unfortunately a similar user login audit table is not available in The Financial Edge or The Education Edge.
Disclaimer: We provide programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Structured Query Language and the tools used to create and modify SQL statements and Crystal Reports. Our Customer Support may help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality.

Environment

 7.94.6116

Was this article helpful?