Is there a way to create a retrospective maintenance window to suppress/remove any alerts generated during the window?

We are looking for ways to suppress/remove alerts that were generated during a maintenance window that we didn't get to schedule until after the event. As far as I can tell, this is not straightforward but I believe it can be done by forming a SQL script to exclude the data in scope from any relevant report. Does anyone have a SQL script that already does this that they would be happy to share or could point us in the right direction to come up with something ourselves? We are not in production yet but are trying to build out functionality so it's in place before we move to production.

Thanks in advance!

  • swis.invoke( 'Orion.AlertSuppression', 'SuppressAlerts',uri,suppressFrom,suppressUntil)

  • Hi WSI, thanks for taking the time to respond. I have been testing with the API and have managed to get a historical alert suppression accepted but it doesn't remove any alerts that had already been raised for that node. The SolarWinds technical Sales guys believed it was possible to do by removing the relevant content from the SQL database but it's that process I'm having problems with. 

  • I would do the following:

    Have each system with a custom property for maintenance start and maintenance end (as date/time type).

    There are multiple benefits to this (in my opinion):

    1. You can run a script to automate Muting Alerts.
    2. If they pass you by, then you can use that timeframe to acknowledge/clear and add a note that this was anticipated downtime.

    Just my thoughts given a few years with the platform.  I haven't been able to implement this myself, but the theory is sound.