We have upgraded our Solarwinds environment recently to new version. After the upgrade I can see some the DB tables have been changed. We were using some SQL queries earlier for generating alert counts for mentioned days. Due to the change in DB tables these queries are not working.
Can anyone help me to write a query to generate a report on alert counts for specific days, say last 7 days, 30 days etc..
