Advanced Alert Count

Question

I am having trouble getting the Report Writer to recognize Advanced Alerts when i run the following query.

Field: AlertID sort:ascending function: COUNT

It returns the value of 6, but when I go into my NPM alerts webpage, I see 12 active alerts.

6 Basic Alerts and 6 Advanced Alerts.

Thoughts!

rbonn · Answer

Thanks Yann

I quess my only option is to use the Advanced SQL Alert option to farm the data out to a report that i can then use to link to a portlet.

Yann · Answer

Hi,

The AlertStatus table should list what you need for the advanced alerts.

Thanks,

Yann

rbonn · Answer

Ok, so the dbo.ActiveAlerts table does not contain entries for the alerts created in the Advanced Alert Manager. Can someone tell me what database they are in?