How to use SWQL Query to build Time Series Graph in a Dashboard (Example: HardwareHealth.HardwareItem "TemperatureSensor")

I've been trying to build a Time Series graph that shows the Temperature of devices over time. So far, the best I've been able to do is build a Report that runs daily, using the following SWQL Query:

SELECT FullyQualifiedName, Value, HardwareUnitDescription, UniqueName FROM Orion.HardwareHealth.HardwareItem WHERE FullyQualifiedName like '%uop-%' AND UniqueName = 'TemperatureSensor.9.1.0.0'

I would love to effectively figure out how to plug this SWQL Query into a time series graph and put it on a dashboard.

That way, we could watch the trends in temperature over time, which would be much more helpful than the daily report we are getting today!

Thanks!

Ryan

Find more posts tagged with

graph

dashboard

SWQL

Accepted answers

All comments

greskamh

Hi Ryan,

as far as I know, for Modern Dashboards (not available for classic) the Time Series Graph is built only based on a perfStack Analysis, not from a swql. So for your Hardware-Values you could create a perfstack and after that you can integrate that perfstack into a modern dashboard time series widget.

Looking at your swql you want to get data from all nodes containing "uop-", what could be solved in perfstack over a group of nodes, you could create whith a name-pattern.

Also @KMSigma.SWI made a yt-video about perfstack: Building PerfStack Dashboards

rleonar7

Thanks for the video link! It is very helpful to get me started with PerfStack!

I am not figuring out how to create a custom metric in PerfStack to capture the Temperature metric. Is there a way to do that?

rleonar7

Aha! There is the "add all other entities related to this entity" button I did not see before now! That button is how I can access some extra information per-node.

rleonar7

However, there is only "PS Temperature Sensor 2.1.10" and not "TemperatureSensor.9.1.0.0"... So I guess I am back to wondering, can I add that metric somehow?

rleonar7

Thanks again greskamh! I do now wonder where I could find some documentation for: using "name-pattern" to create a perfstack analysis/project over a group of nodes, rather than just one node at a time.