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

Cisco Switch Temperature Reports Units in Farenheight

Would like to be able to create a report on Cisco switch temperatures in Fahrenheit. Currently the report only shows the temperature units in Celsius.

Find more posts tagged with

Active

feature request

Status: Active

Comments

donrobert5

https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-changing-hardware-health-units-in-hardware-health-resources-sw1601.htm

P.Bhattacharjee

Use this SWQL in a Custom Report (Advanced Database Query → SWQL):

SELECT DISTINCT    n.Caption                         AS [Node Name],    n.IP_Address                      AS [IP Address],    n.MachineType,    hi.Name                           AS [Sensor Name],    hi.OriginalStatus                 AS [Status],    hi.Value                          AS TemperatureRaw,    CASE         WHEN hi.HardwareUnit.Name = 'DegreesC'             THEN ROUND(((hi.Value * 9.0) / 5.0) + 32, 1)        WHEN hi.HardwareUnit.Name = 'DegreesF'             THEN ROUND(hi.Value, 1)        ELSE NULL    END                               AS TemperatureF,    hi.HardwareUnitDescription,    hi.MessageFROM Orion.HardwareHealth.HardwareItem AS hiINNER JOIN Orion.Nodes AS n    ON n.NodeID = hi.NodeIDINNER JOIN Orion.HardwareHealth.HardwareCategoryStatus AS hcs    ON hcs.HardwareInfoID = hi.HardwareInfoIDWHERE n.Vendor LIKE 'Cisco%'              -- Cisco switches only  AND hi.HardwareCategoryID = 4          -- Temperature category  AND hcs.HardwareCategoryName = 'Temperature'  AND hi.IsDeleted = FALSE  AND hi.Value IS NOT NULLORDER BY TemperatureF DESC, [Node Name], [Sensor Name]