Where do I find alerts info in SQL for NPM 11.5+

AlexSoul

Dear SolarWinds,

I have a number of custom reports and resources which have stopped working in 11.5 because SQL schema has been changed. I am looking for the following information in SQL for NPM 11.5 and I would appreciate if you can help me to find it:

(1)

Alert Status used to be in dbo.AlertStatus [STATE] column with values being 1 for preset, 2 for active/triggered and 3 for reset. Where can I find this info now?

(2)

All my alerts were sitting in dbo.AlertDefinitions table. Now, when I create new alert where does it go?

Thank you for your help,

Alex

AlexSoul

I think I have found the answer:

both tables were moved to views and names changed as follows:

dbo.AlertsDefinitionsView

dbo.AlertsStatusView

Thank you ME for finding them