A quick starting point would probably be something like this
from orion.Nodes n
left join orion.AssetInventory.Software ai on ai.NodeID=n.nodeid
where ai.uri is null
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.