AnsweredAssumed Answered

Create new alarm based on SQL Query output

Question asked by Syahfahmi on Aug 14, 2018
Latest reply on Aug 15, 2018 by Garin

Hi Everyone,


We tried to make a total memory usage from two servers and we managed to create the query, but we cannot create an alarm if the results of the query exceed the threshold. Can CA UIM create a new alarm based on that SQL query output?


This is the query :


select top 1 (samplevalue+
   (select top 1 samplevalue
   from RN_QOS_DATA_0020
   where table_id=55
   order by sampletime desc))/14336*100 as 'Combine Usage'
from RN_QOS_DATA_0020
where table_id=33
order by sampletime desc


Thank You.


Best Regards,