Hi
i have table poller with RowID and RowLabel. need to trigger alert based on count value of a specific rowlabel. Pls help
You should be able to select a RowID field like this in the alert
Hi Thanks for your suggestion.my requirement is to trigger alert upon reaching failure count , say , more than 5 as major alarm. if it is less than or equal to 5 then it is minor alarm. is there any SQL script to count the label or Value of a specific column record in a table? I can see the value of the record which is reflecting the failure count. i am not sure how to extract and set a logic for the condition. Pls help
have used SQL (see below) to trigger alert. it works but some times is not. it is very strange and not able to understand why it is not working.
there is a label column ("Label") where the status is stored. i am trying to count the specific label "6" to trigger the alert. Pls check what is the mistake
