This query should give you a list of SNMP nodes that have no interfaces or volumes attached to them.
select Nodes.Caption from Nodes
Where Nodes.ObjectSubType = 'SNMP' AND
not exists (select * from interfaces where Interfaces.NodeID = Nodes.NodeID) AND
not exists (select * from volumes where volumes.NodeID = Nodes.NodeID)
order by nodes.caption
You my friend... Gold Star :)
Thanks very much, not only did you take the time to create a perfectly working query, you also inadvertently taught me a little more about how the Orion database is laid out.
Thankyou very much.