Nibor

Hi Václav We have found there is one change that needs to be added for the PID change alert. At the end of both SQL queries you need to change: [PE].[PID] = [PED].[PID] To: ([PE].[PID] = [PED].[PID] OR [PE].[PID] IS NULL) This is so you can take into account previous polls that gave a null result for the PID. I have…

That worked perfectly. Thanks Václav. Tim.

Ok, The steps for number three are now working. However I my trigger actions are not being performed and my reset actions are being performed every time the alert is checked (as long as we're within ten minutes of the PID change). This means I never get the trigger email and I get 10 alert reset emails. Any ideas what may…

For part three I'm having an issue with: "The multi-part identifier "" could not be bound." I am interested in having an alert when any component has its PID change. I also had some issues with table names but so I am assuming the following: [PED] = APM_ProcessEvidence_Detail, [PE] = APM_ProcessEvidence and [C]…

From the previous post the following works for alarming on PID Change: PID has changed for any of instances in last 10 minutes: Trigger Condition: WHERE APM_AlertsAndReportsData.ComponentId IN( SELECT [C].[ID] FROM [dbo].[APM_Component] [C]INNER JOIN [dbo].[APM_CurrentComponentStatus] [CS] ON [C].[ID] =…

Any idea where in the database the PID value is stored? And how to make one of those fancy Custom SQL Alerts? Thanks, Tim