DBO.ALERTS Query

Maybe I'm going crazy but I just tried to run a query against the dbo.Alerts table and the dbo.AlertDefinitions table in SQL for both of my servers. Simple SELECT TOP 50 query in each tool gives NO results. I tried this using SWSQL and SSMS with the same lack of results. I'm using NPM 2020.2. This specific server only has 5 enabled alerts on it.

What am I missing?

Find more posts tagged with

query

sql

npm

Accepted answers

All comments

cahunt

AlertDefinitions is an old table, what you are looking for is on the AlertConfigurations Table.

- CharlesH

cahunt

You could also use this report; https://thwack.solarwinds.com/t5/Report-Lab-Documents/Enabled-Alerts-Query-Details-xml/ta-p/513501

I just pulled it up on my 2020.2 system to confirm it still loads as it should.

antonis.athanasiou

Both tables are legacy (and belong back to NPM 10.x and the Desktop version of the advanced alerting engine) if i'm not mistaken and should give no results back, so you are not going crazy.

Try [dbo].[AlertConfigurations] for the actual definitions. If you let us know what were you looking for on the dbo.Alerts we will be able to re-direct you to the right table or SWQL entity. (Wild guess -> go for the dbo.AlertActive)