Export Alerts, Templates, and Report from Orion DB

Yes, alerts, reports, and application templates can all be exported/imported

https://support.solarwinds.com/SuccessCenter/s/article/Export-and-import-alerts-via-the-web-interface?language=en_US

https://documentation.solarwinds.com/en/Success_Center/orionplatform/content/core-exporting-reports-sw1547.htm

https://documentation.solarwinds.com/en/Success_Center/SAM/Content/SAM-Templates-import-export.htm

There is also an API available which may be more what you are looking for.

mesverrum has a nice collection here using PowerShell and the API: https://github.com/Mesverrum/MyPublicWork/

https://github.com/Mesverrum/MyPublicWork/blob/master/AlertArchiver.ps1

https://github.com/Mesverrum/MyPublicWork/blob/master/BackupApplicationTemplates.ps1

So you are trying to pull the data directly from the database without bringing up the main poller?

Hey, thanks for sharing those links Tony!

You're right, looking for a way to pull them via API or DB query if possible.

Nice!! I didn't know about this collection. This could work.

I'll elaborate a bit - Currently our main Orion polling engine is powered off due to the breach. Our client is advising that they want both the Orion and Orion DB servers rebuilt and we cannot backup/import the DB to the newly rebuilt server.

So I'm looking for a way at the very least to export some of the configuration (alerts, app monitor templates, reports) to give us something to work with. Even if we have to export them to a flat file.

Yes, that's exactly what we are attempting to do.