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

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

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

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')

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

Thank you - just what i needed😀