I'm looking for a way to exclude the alerts for login failed on the Error Log Alert. If it can be logged as informational that's great but I don't want it to be a Warning and fire an email.
SQL Server instance <ServerName> recorded 4 error log messages requiring attention.
The messages are shown below in context (if applicable):
Warning 5/17/2021 1:26:40 PM Logon Error: 18456, Severity: 14, State: 8.
OK 5/17/2021 1:26:40 PM Logon Login failed for user 'login name'. Reason: Password did not match that for the login provided. [CLIENT: xxx.xxx.xxx.xx]