How to display last logged in Users and the date/time of last login to the Administrator module.

Version 1

    Details

    How to display last logged in Users and the date/time of last login to the Administrator module.


    Resolution

    Run the following query in SQL Management Studio:


    SELECT DISTINCT(HeatLogin), MAX(LoginTime)
    FROM HEATLoginStatus
    WHERE AppName = 'Admin'
    GROUP BY HeatLogin HAVING COUNT(HeatLogin)>0