SQL Convert into SWQL

Please convert SQL query into SWQL

Select Count(1) From Nodes a Inner Join NodesCustomProperties b on a.NodeID = b.NodeID
Where b.Department = 'IT Division DataCenter'

Find more posts tagged with

orion

sql

SWQL

npm

Unless I'm missing something, you are probably looking for something like:

Select Count(1) as CountItems
From Orion.Nodes [N]
Where [N].CustomProperties.Department = 'IT Division DataCenter'

select count(1) as countnodes from orion.nodes where status<>1

select count(1) as countnodes from orion.nodes where status<>1