Component Count by App per Node

Here is a query to get the component count per App Monitor per Server

SELECT  [C].Application.Node.Caption as Node
    , [C].Application.Name As Application
    , [C].Application.Template.Name As Template
    , Count(*) as Components
From Orion.APM.Component [C]
Group by [C].Application.Name, [C].Application.Template.Name, [C].Application.Node.Caption
Order by Components Desc