It would be great if there was a central place for Admins to examine what notifications and emails were automatically sent out by Shotgun in response to what events, so that we can assist users who want to adjust their notification settings and tune our overall information stream.
Part of the motivation for this request comes from https://support.shotgunsoftware.com/hc/en-us/community/posts/209479628-See-a-list-of-all-the-things-I-m-following of course.
Our usage of Shotgun typically involves hundreds of users, tens of thousands of Tasks, and hundreds of thousands of Versions, per each feature film. That leads to an enormous volume of automated notifications. While there are EventLogEntries created for activity on those entities, there are no entries for the notifications sent out including who they were sent to and in response to what events. EventLogEntries do generate AMQP messages and we do monitor that stream, but again, that doesn't contain notification events, whose metadata ought to include at minimum the to-lists and the EventLogEntry ID that triggered the notification.
The lack of these sort of administrative tools tends to make us (and other studios I know) want to turn off Shotgun notifications entirely and write our own implementations. That makes me sad because I think lots of us are re-inventing the same wheels. We ourselves are on our 3rd or 4th iteration of our own notification-management system, yet Shotgun's internal notifications still remain a black box.
I understand that exploding the EventLogEntry table even further would not be a popular idea. Personally I would be happy with just a more-detailed daily-rotated email_notifier.log file. As a locally-hosted site, we can get at the email_notifier.log, but that seems to only log errors -- which are valuable, but represent only a very small portion of the activity.