More customization of email notifications
The dev database is going to be drifting frequently, and we don't need an email every time that happens. But we definitely want to know when prod is changed. We would like to turn on notifications per environment, or per database.
We may also want one person notified if Project A changes, and another notified about Project B.
Andrea
shared this idea
Jonathan Hickford
responded
We’ve not implemented this feature quite yet. In the mean time if you’re on SQL Lighthouse v1.1.10 we do now show project and environment in the notification email subject. Hopefully that helps set up filters as a stop gap
-
Arnold Lieberman
commented
Even some colour-coding in the email alert would be useful. We have the email going to a Slack channel but different teams care about different environments, so I can see them getting bored and not bothering to follow changes especially when they get many dev environment alerts.
-
Don Turrentine
commented
It would be great to see at least a partial glimpse into what changed in the email. Some changes (i.e. to the actual layout of the views and so forth we could then disregard).
-
aaron bennett
commented
I would like to exclude alerts for schema changes by a given user as I have code that changes schema and I don't want to know every time it runs and changes the schema.