Is there a way to export basic alert settings? I need to document which volumes are selected as monitored objects for several different basic alerts which I would like to compile into Excel. Any ideas?
Hi,
Basic Alerts do not have any export functions, but you can use Database Manager to generate your Excel file.
Start > All Programs > Solarwinds Orion > Advanced Features > Database Manager
If this is the first time you use the tool, add your database server by clicking on the Add server button.
Expand your database and right-click on the Alerts table.
Select Query Table.
Type the below SQL query:
SELECT AlertName, NetObjects FROM Alerts
and click on Refresh to execute the query.
It should return the AlertName and the nodes monitored by each alert. If it returns a *, it means all the nodes are monitored by this alert (if they meet the alert conditions).
Click on File > Export > Export to Excel Spreadsheet...
Save the file somewhere and open it with Excel.
HTH,
Yann
Ok excellent, this has me on the right track but I'm having some issues with it. First issue is that I can't seem to get the Solarwinds Database Manager to connect to the database, so I've logged directly onto the database. I run the query and my result gives the Alert name and a listing of the numerical volume ID's. I tried to do a join but it failed since NetObjects is a single text list deliminated by commas, and Volume IDs are integers. My already limited SQL skills haven't been touched much in 8 years, so I'm at a loss as to getting a human readable display (Volume FullNames). Any ideas?
Can anyone with some SQL experience help me out with this?
Need to parse the volume ids which are comma deliminated text in NetObjects and Alertname in table Alerts and match them up with Fullname and VolumeID in table Volumes.
