• My problem is I need to find successful logins and more specifically last login date time.

    Last login date time is available in sys.dm_exec_sessions but is not recorded unless

    Common Criteria is enabled.

    I am thinking of using logon triggers instead but that either way I think its way to complicated for something that should be recorde by default.(last login date/time)

    Thanks

    Mark