Version 1

    Displays the active alerts by their name.  It is the following query:

     

    select TriggeredMessage, count(TriggeredMessage) as Number from alertactive group by TriggeredMessage