swql query sum of Nodes and Interfaces

jvanderbeken

I have 2 query's where i count the number of nodes and interfaces  with CustomProperties like 'FIN-P' and status <>1

Query for nodes :

SELECT count(1) as Number_of_Nodes
FROM Orion.Nodes n
Where n.CustomProperties.Node_Type like 'FIN-P' and n.status <>1

Query for Interfaces : 

SELECT count(1) as Number_of_interfaces
FROM Orion.NPM.Interfaces i
Where i.CustomProperties.Interface_Type like 'FIN-P' and i.status <>1

The result :  Number_of_Nodes = 60   Number_of_Interfaces = 160

How can i make a query who gives me as result the sum of Number_of_Nodes and Number_of_Interfaces  ( should be 220) to implemet this in a modern dashboard.

KMSigma.SWI

This is probably not the "best" way to do it, but I think it shows you the numbers you want.

SELECT SUM([NodeCount]) AS [TotalThings]
FROM (
      SELECT COUNT([Nodes].NodeID) AS [NodeCount]
      FROM Orion.Nodes AS [Nodes]
      WHERE [Nodes].Status <> 1
      --  AND [Nodes].CustomProperties.Node_Type = 'FIN-P'

      UNION ALL

      (
            SELECT COUNT([Interfaces].InterfaceID) AS [IntCount]
            FROM Orion.NPM.Interfaces AS [Interfaces]
            WHERE [Interfaces].Status <> 1
                  --  AND [Interfaces].CustomProperties.Interface_Type = 'FIN-P'
            )
      )