Looking for SQL Script to Identify all Users and the date of last login
Here is a SQL Script that can provide this information
SELECT hsi.useraccount.usernum AS "User Num", hsi.useraccount.username AS "User Name", hsi.useraccount.realname AS "Real Name", hsi.useraccount.emailaddress AS "Email Address", CONVERT(nChar(23), hsi.useraccount.lastlogon) AS "Last Login Datetime" FROM hsi.useraccount
ORDER BY lastlogon DESC