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
order by sampletime desc))/14336*100 as 'Combine Usage'
order by sampletime desc