Hello everyone,
Is there any way to export Alerts, Application Templates, and Reports directly from the 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.
