Need a threshold 3 specific CPU goes over 50% busy at the same time.

[Jerry]

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?

Regards.

[SCOTT_BALDWIN]

Hello @Jerry,

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,
Scott Baldwin

[Jerry]

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.

Regards.

[SCOTT_BALDWIN]

Hello @Jerry,

The Where Clause will not work as is. I was mistaken, my apologies.

Reason the Where Clause is not providing the desired output:

• Each CPU has its own row of data in the NonStopJob (JOBS) record.
• Where Clause ((BUSY > 50 AND CPUNO = 3) AND (BUSY > 50 AND CPUNO = 1) AND (BUSY > 50 AND CPUNO = 0)) would require each CPU to be on the same row of data to work as desired.
• Because only 1 CPU will ever be in a row of data, the other 2 CPUs cannot present in any single row of data.
• This results in the Where Clause being at least partially false, causing the issue seen.

Alternate options:

1. If the desire is to send an alert when the 3 CPUs are all above 50%, then an Analyst will be needed.

• An Analyst can look at multiple rows at one time, but a Threshold cannot.
• This Online Help page and its sub-pages have details about creating an Analyst:
  https://help.prognosis.com/server/119/system-functions/analyst

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.

• Note: Solution Optimization hours would be needed for a Professional Services engagement.

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.

Thank you,
Scott Baldwin