In the alerting we have a tab called add actions in that do we have something like counter?

Question

I configured one alert for interface utilization when its crossing 85% threshold. So for this i don't want to trigger a mail . I want a counter which will count the number of times that alert has been triggered (cout should be captured) instead of triggering a mail .

Can this be done? Counter can be enabled? Which option i need to choose?

soumya_t · Answer

I found this Query but im not sure which tables to select? in JOIN command

I found 'YOUR_ALERT_DEFINITION_ID' form the database

SELECT a.Name,

COUNT(alert.MsgID) AS NumFailures

FROM AlertLog alert JOIN APM_Application a

ON a.ID = alert.ObjectID

WHERE DATEPART(month, alert.[LogDateTime]) = DATEPART(month, GETDATE())

AND [Message] = 'Alert Triggered'

AND [AlertDefID] = 'YOUR_ALERT_DEFINITION_ID'

GROUP BY a.Name

soumya_t · Answer

Can anyone help on this....

Mine is NPM 12 Version.