Unable to Save threshold for component in SAM Teamplte

Question

Hi Everyone

I have configured one SQL UEM to check the status of a task if the task is still running/not completed after one hour the SQL query will return 1 as output if it is returning 0 then there are no issues

am trying to configure the threshold as greater than 0 under the static threshold but once I submit and again edit the component it is getting disappeared

not getting saved (Threshold)

I even tried to reverse the threshold to test if the alert will trigger giving less than 1 in threshold but again static threshold is empty if I edit the component  and status of the component shows green whereas it has to be red since the current output is 0 or there is no task currently pending

rehan.mudassir · Answer

hi neomatrix1217​

Here is the query

SELECT count(*)

FROM   [DBNAME].[dbo].[TASK]

WHERE  status IN (1,2) AND submitteddate < Dateadd(hh, -1, GETUTCDATE())

and I have reached support team regarding this and turns out it is Bug in SAM 6.5, as a workaround i have been asked to

define the threshold at the template level itself and now I have to add the component at the template level and define threshold

it won't work in if we do it at node/application level

neomatrix1217 · Answer

Can you show us your SQL query?