I'd like to create a query to find all nodes that do no have any application monitoring templates assigned to them. I often find nodes have been added and application windows services missed on the monitoring front.
@shockoSomething like below should be able to get you started. It basically looks at all nodes where the applicationID is NULL (or doesnt have an app assigned) I already added in a where statement to only look at Windows, but you could add/modify this to fit your needs however you see fit.
SELECt n.CaptionFrom Orion.Nodes nwhere n.Applications.applicationID is null and n.MachineType like '%Windows%'
Worked like a charm! Thanks for taking the time out to reply.
