I am not knowledge able on how to write a query that will only show me say the top ten noisiest objects for everything that is contained in a particular group. It would be nice to get another query that can display the most common alerts for a specific group as well.
Kevin H. does not have a query that will do this, yet.
Thank you in advance
There is a built in report that should be able to provide the information you are looking for.
On the Reporting Tab in the Operations Console, navigate to the Microsoft Generic Report Library folder. In here you will find an Alerts report that can be scoped to the group level.
If you specifically want a SQL Query that returns this data please add a comment, these reports are based on SSRS and could provide hints into how to make it.