Hey Thwackers,
Can anyone help with an SQL report that displays all active Alerts as just the total number.
IE the report would say...
Active alerts = 51 for example.
Many Thanks,
Grant
Anyone have any ideas?
Sorry.. I have looked at several different variations on this and see no easy way to configure and supply a simple count of active alerts... you might be able to do it in report writer on the NPM server but that might be some detailed SQL...
No worries I figured the same thing. My SQL knowledge is very lacking.
Thank you for looking though