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

Modern Dashboard Application metrics

I am trying to get metrics for a particular template to show when any of the applications in the template are using high memory (and maybe one for high CPU) in a dashboard.

I have found the right table with the metric(s) but it does not have the node name or component (service) name (or short name).

I realize this may require joining tables (or another method) but that is getting above my skill set.

Here is the query I used to see the correct metrics but this table does not have the component name or server name.

SELECT TOP 1000 ComponentID, ApplicationID, Availability, PercentCPU, PercentMemory, PercentVirtualMemory
FROM Orion.APM.CurrentComponentStatus
WHERE ApplicationID = '21743'
AND PercentMemory > '1'

Does anyone know how to do this?

It looks like I can get the component name from "FROM Orion.APM.Component" but that also does not contain the node name.

Thanks for any help

Find more posts tagged with

Accepted answers

All comments

bourlis

LOL... I've been trying to figure this out for a while and thanks to this post I just figured it out.

You were super close drop the ' ' around the PercentMemory statement, like this:

SELECT TOP 1000 ComponentID, ApplicationID, Availability, PercentCPU, PercentMemory, PercentVirtualMemory

FROM Orion.APM.CurrentComponentStatus

WHERE PercentMemory > 1 AND applicationid = '21743'

KMSigma.SWI

If you want an easier filter, you can use the named Component, Application, or Node by using Navigation Properties.

SELECT [Component].ComponentID
     , [Component].ApplicationID
     , [Component].Availability AS [Status]
     , [Component].ObservationTimestamp
     , [Component].ComponentStatusID
     , [Component].LastTimeUp
     , [Component].ErrorCode
     , [Component].ErrorMessage
     , IsNull([Component].PercentCPU, 0) AS [PercentCPU]
     , IsNull([Component].PercentMemory, 0) AS [PercentMemory]
     , IsNull([Component].PercentVirtualMemory, 0) AS [PercentVirtualMemory]
     , [Component].IsFallbackUsed
     , [Component].PrimaryPollingProtocol
-- Below we'll use navigation properties to "move" across the data set
--     To get the component name/link, we need to use the Navigation Property to connect from Orion.APM.ComponentStatus to Orion.APM.Component
     , [Component].Component.Name AS [Component]
     , [Component].Component.DetailsUrl AS [Component_URL]
--     To get the application name/link, we need to use the Navigation Property to connect from Orion.APM.Component to Orion.APM.Application
     , [Component].Component.Application.Name AS [Application]
     , [Component].Component.Application.DetailsUrl AS [Application_URL]
--     To get the node name/link, we need to use the Navigation Property to connect from Orion.APM.Application to Orion.Nodes
     , [Component].Component.Application.Node.Caption AS [Node]
     , [Component].Component.Application.Node.DetailsUrl AS [Node_URL]
FROM Orion.APM.CurrentComponentStatus AS [Component]
-- Now you can use the component, application, or node names to do filtering (if you want)
WHERE IsNull([Component].PercentCPU, 0) > 0
-- Use one of the below or build them into a logical collection
--AND [Component].Component.Name = 'Windows Event Log Monitor'
--AND [Component].Component.Application.Name = 'Errors in Application Event Log'
--WAND [Component].Component.Application.Node.Caption = 'SURFACE-PRO'

bourlis

Silly question??? Your IsNull % lines return is visually long, what's your option on making the following change? As far as i can tell the I got the same returns, or at least close enough for government work.

replace this:

,IsNull([Component].PercentCPU, 0) AS [PercentCPU]

, IsNull([Component].PercentMemory, 0) AS [PercentMemory]

, IsNull([Component].PercentVirtualMemory, 1) AS [PercentVirtualMemory]

With this:

, CONCAT(round([Component].PercentCPU, 1),' %') as[CPUPercent]

, CONCAT(round([Component].PercentMemory, 1),' %') as[MemoryPercent]

, CONCAT(round([Component].PercentVirtualMemory, 1),' %') as[VirtualMemoryPercent]

mmayer5823

Awesome Kevin and Bourlis, exactly what I needed. Thanks so much for your help.

KMSigma.SWI

I'd personally skip the added percent signs because Modern Dashboards (the original ask) can be told the number is a percentage. As far as rounding the number - that's up to you. If I'm forced to round something, I normally go with two decimal places because that's just what I like.