This content has been marked as final. Show 2 replies
2 of 2 people found this helpful
Try this SWQL and see how it does.
SELECT N.Caption, N.NodeID
FROM Orion.Nodes N
Full Join Orion.Volumes V on V.NodeID = N.NodeID
Where V.Caption is Null
Thank you everyone for your help.
Work pretty well for what i need.