I would like to receive an email every day from each of "my" SQL Servers, with information from the ErrorLog.
I would like an easy way to determine if there is any important new information, that I should not overlook.
So I've tried to categorise all the messages into "Database Backup", "Reboot", "Noise" etc. All un-categorised messages I list as "Unusual event".
I've been looking for some time for a list of messages that it is safe to ignore, but found none. So here is my list.
Am I pruning the list too hard?
Are there other messages that I should ignore?
Can you point me to other methods, that work better?
here is my code: github gist