This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

KPI view for down nodes per group or custom property

Hi All,

 

I need some help with creating KPI view in modern dashboard showing the down nodes for each group or custom property.

 

I’m using the  following query for all nodes but I need it to  be filtered on groups and custom property.

SELECT COUNT(1) AS KPI_Numbe from Orion.Nodes WHERE Status=2

 

I would appreciate if someone can help

Parents Reply Children
  • SELECT
    DISTINCT [N].CustomProperties.Team AS [Team] --Update with the CustomProperty Name of your choice.
    ,COUNT ([N].NodeID) AS [Quantity]
    FROM Orion.Nodes AS [N]
    WHERE [N].Status = '2' --Update with the Status you require 1 for Up, 2 for Down etc
    GROUP BY [N].CustomProperties.Team --Update to match the CP used above.