The simple way to capture last login by
turning on the auditing
SQL Server can audit logins. Read more detail http://msdn.microsoft.com/en-us/library/ms175850.aspx and http://technet.microsoft.com/en-us/library/dd277388.aspx
I do not think you can track login usage unless the auditing is turned on.
You can try this to find out when it was last used:
SELECT accdate, name FROM master.dbo.syslogins
OR
By using
LOGON triggers available since SQL Server 2005
USE master;
GO
CREATE LOGIN login_test WITH PASSWORD = '3KHJ6dhx(0xVYsdf' MUST_CHANGE,
CHECK_EXPIRATION = ON;
GO
GRANT VIEW SERVER STATE TO login_test;
GO
CREATE TRIGGER connection_limit_trigger
ON ALL SERVER WITH EXECUTE AS 'login_test'
FOR LOGON
AS
BEGIN
IF ORIGINAL_LOGIN()= 'login_test' AND
(SELECT COUNT(*) FROM sys.dm_exec_sessions
WHERE is_user_process = 1 AND
original_login_name = 'login_test') > 3
ROLLBACK;
END;
refer the website for more info regrding
LOGON triggers
http://msdn.microsoft.com/en-us/library/bb326598.aspx