Report on Nodes that do not have any Application Monitor Assigned

Question

Hi All,

So there might be a quick answer to this, but I cannot seem to find the answer anywhere.

I need to create a report for all nodes that do not have any application monitor assigned to them.

I have tried both the WebGUI and the Report Writer to try and find a solution, but so far it has not been successful.

Any ideas?

Thanks in advance,

Adam

mharvey · Accepted Answer

Using an Advanced SQL report, this might be able to get you started:

Select Nodes.Caption, Nodes.IP_Address, Nodes.Vendor from Nodes

Where Nodes.NodeID NOT IN (Select NodeID from APM_Application)