2 Replies Latest reply on Jan 27, 2017 8:24 AM by morphicstates

    Mass Alert Subject and Message Update...

    morphicstates

      I'm on a job for a client and we just created a few hundred new alerts.  The client now wants to change the Subject and Message body format of the Trigger Action (Email Alerts).  I wanted to avoid the click and past nightmare that comes along with this, so my first thought was and run an update query against the DB.  I found the AlertDefinitions, AlertConfigurations, and AlertDefinitionsView along with all their dependencies; I however don't see the Subject or Message body data in any of the tables.  I however did not run across where the data I need to update is stored in order to perform a mass update.  Does anyone out there have a solution for this particular problem?  To date I've come across no information covering this.

        • Re: Mass Alert Subject and Message Update...
          morphicstates
          SELECTAlertDefV.[AlertDefID],
          AlertDefV.[AlertName],
          AlertDefV.[AlertDescription],
          AlertDefV.[Enabled],
          AlertDefV.[NotifyEnabled],
          ActionDef.[ActionType],
          ActionDef.[Title],
          ActionDef.[Target] AS [To],
          ActionDef.[Parameter1] AS [Subject],
          ActionDef.[Parameter2] As [Body],
          ActionDef.[Parameter3] As [From],
          ActionDef.[Parameter4]

                         

          FROM[NetPerfMon].[dbo].[AlertDefinitionsView] AlertDefV

           

           

          LEFT JOIN [NetPerfMon].[dbo].[ActionDefinitions] ActionDef

          ON AlertDefV.AlertDefID = ActionDef.AlertDefID

          ORDER BY AlertDefV.[AlertName]

           

           

          Unfortunately, I've noticed that all custom Alerts are listed as NULL values for the following:

           

          ActionDef.[ActionType],
          ActionDef.[Title],
          ActionDef.[Target] AS [To],
          ActionDef.[Parameter1] AS [Subject],
          ActionDef.[Parameter2] As [Body],
          ActionDef.[Parameter3] As [From],
          ActionDef.[Parameter4]
          • Re: Mass Alert Subject and Message Update...
            morphicstates

            All Settings >

            Manage Alerts >

            Action Manager (Tab) >

            Group By (Drop Down Menu) >

            Action Type (Selection) >

            Send an Email/Page (Selection)