Last User Login LiveReport in MS SQL for LL 9.2

Paul Langham

Can anyone help?Help/pointers much appreciated.

Steve_McDonough

Hello Paul,I run this autolive 'User Login Activity' report:SELECT A.NAME "Login Name", A.LASTNAME + ', ' + A.FIRSTNAME "Member Name", COUNT(B.EVENT) "Number of Logins", MAX(CONVERT(CHAR(10), B.AUDITDATE, 111)) "Last Login", MIN(CONVERT(CHAR(10), B.AUDITDATE, 111)) "First Login", ISNULL(A.MAILADDRESS, "* Generic Login *") "email Address" FROM KUAF A, DAUDIT B WHERE B.EVENT = 'LOGIN' AND A.ID = B.USERID AND A.DELETED = 0 AND A.USERPRIVILEGES <> 14 GROUP BY A.NAME, A.LASTNAME, A.FIRSTNAME, A.MAILADDRESS ORDER BY "Number of Logins" DESCRegards,Leon Kish