When doing a server side trace and capturing the Audit Login Event it seems that it ignores my filter which is based on LoginName. It still logs any user that logs into the SQL instance whether it is a SQL login or a windows authenticated user. I just want to know when this specific user logs in successfully. Is this a known issue? My filter is as follows:
EXEC sp_trace_setfilter @TraceID, 11, 0, 6, N'XXXXXX'