Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Backup all alerts

I'm looking for a way to bakup all of my alerts. In the event that say a single alert is deleted or modified incorrectly I would like to be able to restore the alert without doing a full server restore. What it the proper method for doing this as I can't check multiple alerts for export?

Find more posts tagged with

alert backup

Accepted answers

All comments

bhilgenkamp_botw

I was looking for this answer again today. Google led me here, two years later almost to the day. It's as though Google is mocking me.

bobmarley

You can import/export them individualy

bhilgenkamp_botw

Thanks, but looking for a way to bulk export them all at once, or as a scheduled task if possible.

cahunt

This is possible via the SDK;

Orion SDK

GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in Powe…

bhilgenkamp_botw

Which tables need to be backed up?

cahunt

Orion.AlertConfigurations

There is an export verb available.

bhilgenkamp_botw

This won't get all the associated actions though. I wasn't clear on my initial request though that I'm looking for a way to fully recreate the alert (actions included).

joedissmeyer

Here you go! This is a nice little powershell script to backup all ACTIVE (a.k.a. Enabled) alerts from your Orion instance.

I have this run as a daily scheduled task.

# --- POWERSHELL ---
# --- Requires the source machine where script runs has the OrionSDK installed. ---
# --- Download binaries from here: github.com/.../OrionSDK       --- 
#
# Requirements: 
# Create an Orion basic user that has "Alert management rights" enabled.
# That's about it. 
# 

# Verify OrionSDK SwisSnapin presence
if (!(Get-PSSnapin -Name "SwisSnapin" -ErrorAction SilentlyContinue))  
{      
    Add-PSSnapin SwisSnapin -ErrorAction SilentlyContinue  
}    

# Define Variables
$swis = Connect-Swis -Hostname my-orion-host.domain.com -Username alertbackup -Password Jello12#

# Get all AlertId
$AlertList = Get-SwisData $swis "SELECT AlertId FROM Orion.AlertConfigurations WHERE Enabled = True"
$AlertIds = $AlertList -split ' '

foreach($alertid in $AlertIds){
  $alerttitle = Get-SwisData $swis "SELECT Name FROM Orion.AlertConfigurations WHERE AlertId = $alertid"
  $alerttitle = $alerttitle -replace '(#|\||"|,|/|:|\<|\>|\[|\]|%|$|@|â|€||\?)', ''
  $alerttitle = $alerttitle -replace '\s','_'

  $filename = "$alerttitle-ID-$alertid.xml"
  
  Set-Content $filename $ExportedAlert.InnerText
  $ExportedAlert = Invoke-SwisVerb $swis Orion.AlertConfigurations Export @($alertid)
}

(Edit --- was missing closing bracket on line 32)

bobmarley

This is great many thanks!

joedissmeyer

My pleasure!

I went ahead and posted this in a formal way. A few extra notes, yada yada - Full Orion alert rule export using Powershell and OrionSDK