Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 12

Find Nodes where Asset Inventory is not being collected

Looking to create a query to show nodes where application inventory is not being displayed. 

0 Kudos
1 Reply

A quick starting point would probably be something like this

select n.caption
from orion.Nodes n
left join orion.AssetInventory.Software ai on ai.NodeID=n.nodeid
where ai.uri is null

- Marc Netterfield, Github
0 Kudos