modern dashboard for hardware sensor statistics

i am trying to create a m.dashboard to reflect my "manage hardware sensor" section.

i wrote a query to select my desire filed:

SELECT 
      node.Name
    , node.FullyQualifiedName
    , node.HardwareCategoryID
    , node.StatusDescription
    , node.DetailsUrl
FROM Orion.HardwareHealth.HardwareItemBase node
where node.StatusDescription!= 'Up'
And (
        (node.Name NOT LIKE '%ethernet%') AND
        (node.Name NOT LIKE '%Receive%')
    )

how can i add :

1- how do i match hardware category ID with sensor category?
2- how add parent or node.caption to my query?
3- how can i add appropriate icon to sensor name based on category name or ID?

Find more posts tagged with

SWQL

Modern Dashboards

Accepted answers

All comments

PhilipIndra

Hi all,
I'm also looking at this "Manage Hardware Sensor" dashboard.
Is there a way to add technology vendor into this dashboard?
Is this dashboard customizable ?
For example the hardware sensors for Check Point Firewall and Aruba Wireless Controller.

zakin23

To build a modern dashboard for your hardware sensor statistics, you’ll need to join your hardware and sensor tables using a common key—typically, matching the hardware category ID with the sensor category ID via a JOIN clause in SQL. For example, JOIN sensor_table ON hardware.category_id = sensor.category_id would align the data. To include parent or node.caption, check your data model for hierarchical relationships and use recursive CTEs or joins depending on your database structure. As for adding icons dynamically based on category name or ID, you can map each category to a specific icon using a CASE statement or reference table in your UI layer. It’s like checking the Oporto Australia menu—once you know the item category (like burgers or wraps), you can match it with a representative image or icon for a visually intuitive layout.

aswetnatex23

You can build a modern dashboard for hardware sensor statistics using tools like Chart.js or Grafana, integrating APIs for real-time updates to reflect your "manage hardware sensor" section clearly and interactively—Read more about free RBT practice exams here.