How to find the last logged in date/time for Call Logging for all users

Version 1

    Details

    How to find the last logged in date/time for Call Logging for all users


    Resolution

     

    Run the following query in SQL Server Management Studio:

    SELECT DISTINCT(HeatLogin), MAX(LoginTime)

    FROM HEATLoginStatus

    WHERE AppName = 'CallLog'

    GROUP BY HeatLogin HAVING COUNT(HeatLogin)>0