nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
- SolarWinds Academy
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
- Goal Oriented AI
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

SWQL Needed for KPI Widget for hardware components in critical state

jasonford1971

hi all - need help on SWQL for KPI widget for hardware components in critical state - thanks

Find more posts tagged with

Comments

jasonford1971

Thank you - just what i needed😀

yellowtj

Basically, you need to create a SWQL Select statement that provides a number to each KPI box in the KPI object. So for nodes in critical state this should work:

SELECT Count(H.NodeID) AS Critical

FROM Orion.HardwareHealth.HardwareInfo H

JOIN Orion.NodesCustomProperties C ON H.NodeID = C.NodeID

WHERE StatusDescription = 'Critical' AND C.Company = 'Your Company Name'

jasonford1971

hi - if would be for multiple vendors cisco & windows (for now) component would be for all Hardware devices - i do have this in a table widget but i need it just to specify for company =**** via custom properties (**** being the company name)

SELECT
n.Caption AS [Node Name]
,n.DetailsUrl AS [_LinkFor_Node Name]
,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node Name]
,hi.name as [HW Device]
,'/Orion/images/StatusIcons/Small-'+hi.StatusDescription+'.gif' as [_IconFor_HW Device]
--,hi.DetailsUrl AS [_LinkFor_HW Device]
,hi.OriginalStatus
FROM Orion.Nodes n
inner join Orion.HardwareHealth.HardwareItem hi on hi.NodeID=n.nodeid
WHERE -- n.nodeid= ${nodeid}
hi.StatusDescription not in ('up','unknown')

HillyBilly

Hi Jason,

we need some more information to offer the Help.
What type of Hardware (windows/Linux Server, Network Device(if poss what type of device) and what component)

and what platform SHO or Saas

Quick Links

Cisco Firepower Threat Defense FTD-1.3.6.1.4.1.9.1.2320.ConfigMgmt-Commands
Cisco Firepower Threat Defense FTD-1.3.6.1.4.1.9.1.2320.ConfigMgmt-CommandsExported with NCM 2023.4.2
Summary of Alerts Generated
AlertSummary.xmlHi All, I've done some work to tidy up our alert definitions (both the Alert Manager and Alert Actions) and the more important alerts have now been tailored and given a "[ *** ]" prefix so it is easy to see the alerts we have catered for versus those that might appear once in a while. I am monitoring this…
Dynamic Interface Dashboard; HTML/JS
I wanted to share a new dashboard a co-worker ( @mblackburn ) came up with to help us better view groups of interfaces and various metrics for each. Using a single HTML widget, we are able to visually compare numerous different interfaces by populating each interface dataset onto its own graph. We are able to view…
PALO-ALG - Logging
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022