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