AnsweredAssumed Answered

Table Query which shows last 24 hours of alarms

Question asked by javier.vazquez on Sep 30, 2010
Latest reply on Sep 30, 2010 by 3859

I have a prospect that is wanting to know when processes are hogging the CPU and when he sees a spike he wants to know which one is the culprit.  I imagined a dashboard with a graph that shows the CPU or CPUs of his machines and a table beneath that graph.  That table would be running a query against the NAS table in the SLM database.  Here is what I’ve come up with:


select        time AS [Time], message AS [Alarm Message]

from          NAS_TRANSACTION_SUMMARY WHERE PRID='processes'

order by time


The only problem is that I just want the last 24 hours of alarms to show not all of them.  Does anyone know a way of modifying this query to show just those last 24 hours of alarms from the processes probe? 


I won’t need to filter on the message because the only thing that the processes probe will be used for will be for the profile which sees which processes are hogging the CPU.


Is there a better way to do what I’m trying to do?