Script to clear alerts

• 
  If anyone is interested I used the script below:
  

  DECLARE @Alerts TABLE (AlertId INT, Date BIGINT)
  
  INSERT INTO @Alerts
          ( AlertId, Date )
  SELECT A.AlertId, ASev.Date
  FROM alert.Alert A INNER JOIN alert.Alert_Severity ASev ON A.AlertId = ASev.AlertId
  INNER JOIN alert.Alert_Type AType ON A.AlertType = AType.AlertType
  WHERE A.TargetObject LIKE '%<[i]server/cluster name[/i]>%'
  AND AType.Name = '<[i]alert type[/i]>'
  
  INSERT INTO alert.Alert_Cleared
          ( AlertId, Date, Cleared )
  SELECT A.AlertId, A.Date, 1
  FROM @Alerts A
  
  UPDATE alert.Alert SET [Read]=1 
  WHERE AlertId IN 
  (SELECT AlertId from @Alerts)
  

  johnmcp November 29, 2013 07:26

  - 0 +

Add comment

Please sign in to leave a comment.