hii everyone & ">HolyGuacamole i dont have knowledge in programming and sql variables co i need a to configure npm to send a mil when node goes down and comes up with downtime value in hour : minutes so can you pleased help me
${SQL:SELECT DATEDIFF(mi, '${AlertTriggerTime}', GETDATE())/60 } : ${SQL:SELECT DATEDIFF(mi, '${AlertTriggerTime}', GETDATE())%60 }
To learn more, see arithmetic operators in SQL - Arithmetic Operators (Transact-SQL)
Hi ">HolyGuacamole
thank you soo much you have helped me in solving this issue once aagin thanks
warm regards