Not a SQL person by any means so struggling here. I need to provide monthly metrics that capture the total number of Azure monitors we have in Orion. We are moving from on prem to Azure and leadership wants to see how our monitoring is changing. To do this I have added a new custom property to the apps that lets me specify Azure for easy identification. I can get a list of the Sam templates that have this property set but I would like to include the component count for each template. Example below
Application
Application Template | Location | Components |
---|---|---|
Windows 2016 Standard OS Template | Azure | 24 |
SQL Application Insight | Azure | 48 |
And so on.
So the new custom property that would provide the location info is "report" and I have allowed 4 drop down options. On Prem, Azure, AWS, and Other.
The application template field is just the application template used.
And obviously the components would be the total number of components in said template.
I imagine this is a very basic query but my SQL buddy went to another job and I am flapping in the wind without him. Any help would be much appreciated.