We have setup an alert base on an APM component and the statistical data. The conditions were met, but the alert did not fire. Looking at the query in NetPerfMon, it looks to query a table that does not exist. The query is:
SELECT APM_AlertsAndReportsData.ComponentID AS NetObjectID, APM_AlertsAndReportsData.ComponentName AS Name
FROM APM_AlertsAndReportsData
WHERE
(
(APM_AlertsAndReportsData.ComponentName = 'IMTEMP Script 1 Hour imgs') AND
(APM_AlertsAndReportsData.StatisticData > 0)
)
dbo.APM_AlertsAndReportsData does not exist in our NetPerfMon database.
Am I missing something?