Nodes Missing SAM Template

Question

Hello Everyone,

Does anyone have a SQL query that finds the following scenario:

Nodes missing a particular SAM template

There are times the admins forget to apply certain SAM templates to nodes and I was wondering if there's a way to search for the ones missing the template.

mesverrum · Accepted Answer

Your query would have to know what the conditions are where a particular template should be applied.

The starting point would be

select n.caption, a.name

from nodes n

left join apm_application a on a.nodeid=n.nodeid

--where a.name is null

You would need to place addition conditions on the join line to say which nodes should have what templates applied, and then you remove the comment from that last line to only show you nodes where the described template is not assigned.