ptherond

Thank you very much, that’s the answer I was concerned I’d get

Thanks Steven This is good In the meantime I also came across the APM_application and came up with a query that does the same but joins the nodes table (which is a bit useless because I am simply doing a count): select count(b.dns), a.name from APM_Application a inner join nodes b on a.nodeid = b.NodeID group by a.name; So…