I want to generate a report of all process utilization history whenever CPU goes 100 %
Getting all the processes isn't possible unless you are running something additional that polls that process list. The process list isn't polled when Orion pulls the CPU load. Unless you have specific processes that you are watching with Server & Application Monitor (SAM), there's no way to retrieve that information from the database (because it's not being stored there).
Imagine this scenario:
You are introducing unnecessary spikes into your CPU usage while trying to determine your excess CPU usage. It can turn into a vicious cycle.
Can you do this? Absolutely! Should you do this? Probably not. Whomever is consuming this monitoring data is going to see a sharp uptick in the processing/memory/etc. usage caused by the monitoring system. This is counter-productive to the purpose of a NMS.
What exactly are you trying to accomplish with this report? There is probably a better way to get this information.
Would you want this for all nodes? Do you want it for a single node? Do you want the count of the times it hit 100% in the last 24 hours? Do you want it for the duration at 100% for 24 hours?
If you can reply with a table layout of the fields and stuff you'd want via reply, it might be easier to help out.
1. report for specific nodes / Selected nodes.
2. No exactly only the count but also need what are all the process are consuming more CPU when the overall CPU hits 100.
3.Last 24/12 hours report with 1 min /5 mins/15mins polling frequency.
by any other chance, i want to achieve the point No.2
Thank you for this My Friend.