SWQL Atrithmetic

nmsrabobank.nl

How does one do atirhmetic in SWQL?

I would like to see the total number of elements mananged on a node. I can run this query:

SELECT Count(Nodes.Volumes.VolumeID) AS Volumes,
       Count(Nodes.Interfaces.InterfaceID) AS Interfaces
FROM Orion.Nodes WHERE Caption = 'the node I am looking for'

But how to actually get a sum over both these values?

SELECT ( Count(Nodes.Volumes.VolumeID) AS a
         + Count(Nodes.Interfaces.InterfaceID) AS b ) AS Total
FROM Orion.Nodes WHERE Caption = 'the node I am looking for'

Yields: mismatched input 'AS' expecting ')' in Select clause 

Any Ideas?

dunky2k

@nmsrabobank.nl 

You don't need the 'AS' if ypu are aggregating the totals.

SELECT ( Count(Nodes.Volumes.VolumeID) + Count(Nodes.Interfaces.InterfaceID) ) AS Total
FROM Orion.Nodes WHERE Caption = 'the node I am looking for'