I try using the following where clause but it not working:
((BUSY > 50 AND CPUNO = 3) AND (BUSY > 50 AND CPUNO = 1) AND (BUSY > 50 AND CPUNO = 0))
What will be the correct approach to acheive the monitor?
The Where Clause logic and parenthesis usage looks correct. This Where Clause should identify when all 3 CPUs show as 50% or higher usage at the same time.
Thank you for your quick reply @SCOTT_BALDWIN ;
I also though the same but that specific where clause is not working for me. I even tried putting then > 1% busy value and it does not work; not even in a display configuration.
Can you try it on your side? Let me know if on your environment my where clause works.
The Where Clause will not work as is. I was mistaken, my apologies.
Reason the Where Clause is not providing the desired output:
1. If the desire is to send an alert when the 3 CPUs are all above 50%, then an Analyst will be needed.
2. If a Display will be used to present an output when the 3 CPUs are all above 50%, there is likely a way to present the desired data using advanced Display features.
3. There is likely a way to use a summary record to get all 3 CPUs on a single row of data.
The alternate options are advanced enough to require the Professional Services team for this level of customization. The Professional Services team would know the best way to provide the desired output. The Professional Services team could provide training on any of the 3 options so you and your team can create a similar solution in the future.
Please let me know if you would like the Account Manager to contact you about a Professional Services engagement or if you have any additional questions.