I want to analyze all the alerts being generated by NPM. I'd like to get a CSV file for an arbitrary period of say, a week.
How to do that is not apparent to me. Any easy way to do this?
1. Remote access your Orion server
2. Start >> All program >> Solarwinds Orion >> Advance Features >> Database Manager
3. Add Default server >> Click the plus sign beside your NPM Database >> look for Alert_Logs Table
4. Right click >> Query Table
5. Click Execute query
6. it will show the alert logs.
7. click export to CSV.
Exactly what I needed, thanks.
The query I actually ended up using was
SELECT TOP 1000 LogDateTime,AlertName,L.ObjectType,ObjectName,ActionType,Message
FROM [dbo].[AlertLog] as L, [dbo].[AlertDefinitions] as D
WHERE L.AlertDefId = D.AlertDefId
