Looking to create a query to show nodes where application inventory is not being displayed.
A quick starting point would probably be something like this
select n.captionfrom orion.Nodes nleft join orion.AssetInventory.Software ai on ai.NodeID=n.nodeidwhere ai.uri is null