Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Is there any way to display the individual CPU core usage in alert message.?

I want to display the alert message that contains the information of each CPU load usage (from multiple CPU cores) in a single node instead of average CPU load usage.

Find more posts tagged with

Accepted answers

adam.beedell

The answer is definitely yes, though offhand I'm not sure if an easy way to do it. Hopefully there's a obscure macro. Else it's a select x where x is cores then dump it into a FOR XML PATH or similar.

kalaiarasikanagaraj

yaeh sure.i am using your concept but tried it with SQL query.

below one will display max cpu load and its corresponding index.

${SQL: select top 1 c.CPUIndex+1 as CPUIndex,max(c.MaxLoad) as MaxLoad from CPUMultiLoad c,Nodes n

where c.NodeID=n.NodeID

AND n.Caption = '${N=SwisEntity;M=Caption}'

AND DATEDIFF(mi, C.TimeStampUTC, SYSUTCDATETIME()) <10

group by c.CPUIndex,c.MaxLoad order by C.MaxLoad desc}

All comments

adam.beedell

kalaiarasikanagaraj

Thank you so much.
Do you mean whether we can try it via SQL/SWQL in alert message itself?

Actually, I researched a lot. I am totally blank now. Any small help would be greatly appreciated.

adam.beedell

Had a quick swing at it

Is this the sort of output you're after? The column i've cut off is the device name, you could probably drop the frequency, so the middle 2 columns are I guess what you'd be after?

Doesnt feel super useful to me but could be in your environment. A MAX of the Maxload column would be easier to work with

This was produced with a query like this

select TOP 100 n.Caption, n.CPUMultiLoadHistory.CPUIndex, n.CPUMultiLoadHistory.MaxLoad, n.CPUMultiLoadHistory.ObservationTimestamp
from orion.nodes N 
where n.Caption = 'TARGET'
-- and n.CPUMultiLoadHistory.ObservationTimestamp = 'TIMESTAMP'
ORDER BY  n.CPUMultiLoadHistory.ObservationTimestamp desc

So there's a few bits left to work out before putting that in an email, assuming you still want it

1) You dont really want to use the TOP 100 the way I am here, you want to select all given other specifics, then maybe bound with a TOP for safety.
2) Make a macro in a test action, put this in, and replace specifics with variables that produce those specifics given a node ID or whatever
3) You'll know it "kinda works" when if you substitute in the submacros in SWQL studio it produces the correct output, but when you do it in the action it gives you the top left cell
4) once it kinda works, you then save that as a macro, and put that in a SQL macro, using the FOR XML PATH verb to squish it into one cell
5) once that kinda works, you probably need to use a subquery and REPLACE to make it readable, else make the rest of a XML table to put it in

Not that easy as you can probably tell

kalaiarasikanagaraj

I really appreciate it. Thank you.
To show an alert message, the result shown above is sufficient.
Let me give it a go, and I'll let you know soon.

kalaiarasikanagaraj

Thank you so much.

i have completed my task.
Your support means a lot to me. Thank you.