Here there is not direct method to get the unused logins, as per venkatsh and Shanky,through logon trigger you can find the unused logins.
About direct method not sure but i would like Siva to use this query this will not give complete picture but will provide tentative dates for account created and accessed for all logins,still logon trigger method is best
Use master
go
select createdate,updatedate,accdate,name from sys.syslogins
Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers
