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?