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?