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

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😀

Quick Links

Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
Cisco ASA SSL Tunnels
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches