Enable deploying shared queries via ARM
We have multiple application insights instances (test, acc, prod) and want to configure them as Infrastructure as Code using ARM templates. It seems to be possible to add alerts to the templates, however I'm not able to add our share queries from our insights analytics to an ARM template. To be able to redeploy and keep track of our queries we want be able to add the developed queries in our ARM templates and deploy them as IAC.
Peter Groenewegen
shared this idea
Save queries and shared saved queries support in ARM template is now planned.
This should enable programmatic update of saved queries.
3 comments
-
Amine KONDI
commented
this template allow you to create an app insight alerte basing on the inserted query in the Template
=====================================================================
{
"$schema": "http://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json",
"contentVersion": "1.0.0.0",
"parameters": {
"existingApplicationInsightsName": {
"type": "string"
}
},
"variables": {},
"resources": [
{
"apiVersion": "2018-04-16",
"type": "Microsoft.Insights/scheduledQueryRules",
"name": "Alert1",
"location": "[resourceGroup().location]",
"tags": {
"[concat('hidden-link:', resourceId('microsoft.insights/components', parameters('existingApplicationInsightsName')))]": "Resource"
},
"properties": {
"description": "Description1",
"Enabled": "True",
"source": {
"query": "customMetrics | summarize AggregatedValue = count() by bin(timestamp, 15m),client_StateOrProvince",
"dataSourceId": "[resourceId('microsoft.insights/components', parameters('existingApplicationInsightsName'))]",
"queryType": "ResultCount"
},
"schedule": {
"frequencyInMinutes": 40,
"timeWindowInMinutes": 40
},
"action": {
"odata.type": "Microsoft.WindowsAzure.Management.Monitoring.Alerts.Models.Microsoft.AppInsights.Nexus.DataContracts.Resources.ScheduledQueryRules.AlertingAction",
"severity": "3",
"aznsAction": {
"actionGroup": [
"/subscriptions/131c713e-23e2-4eec-b592-61e975f28e6b/resourceGroups/Alerts/providers/microsoft.insights/actiongroups/Me"
],
"emailSubject": null,
"customWebhookPayload": null
},
"throttlingInMin": 30,
"throttleConsecutiveWindowCount": 0,
"trigger": {
"thresholdOperator": "GreaterThan",
"threshold": 0
}
}
}
},
{
"apiVersion": "2018-04-16",
"type": "Microsoft.Insights/scheduledQueryRules",
"name": "Alert2",
"location": "[resourceGroup().location]",
"tags": {
"[concat('hidden-link:', resourceId('microsoft.insights/components', parameters('existingApplicationInsightsName')))]": "Resource"
},
"properties": {
"description": "Description1",
"Enabled": "True",
"source": {
"query": "customMetrics | summarize AggregatedValue = count() by bin(timestamp, 15m),client_StateOrProvince",
"dataSourceId": "[resourceId('microsoft.insights/components', parameters('existingApplicationInsightsName'))]",
"queryType": "ResultCount"
},
"schedule": {
"frequencyInMinutes": 40,
"timeWindowInMinutes": 40
},
"action": {
"odata.type": "Microsoft.WindowsAzure.Management.Monitoring.Alerts.Models.Microsoft.AppInsights.Nexus.DataContracts.Resources.ScheduledQueryRules.AlertingAction",
"severity": "3",
"aznsAction": {
"actionGroup": [
"/subscriptions/131c713e-23e2-4eec-b592-61e975f28e6b/resourceGroups/Alerts/providers/microsoft.insights/actiongroups/Me"
],
"emailSubject": null,
"customWebhookPayload": null
},
"throttlingInMin": 30,
"throttleConsecutiveWindowCount": 0,
"trigger": {
"thresholdOperator": "GreaterThan",
"threshold": 0
}
}
}
}
]
}
=================================================================== -
Simpson, Daniel
commented
Considering the fact that we can't use comments or multi-line ARM templates, this is incredibly important to keep dashboard reports easily readable and understandable.
Will be a huge productivity boost if and when we get this!
-
Rob Jellinghaus
commented
Our team desperately wants this as well -- we have a lot of reporting we do on our dashboard, and we want to be able to deploy and code review our dashboard, with all its queries. Please implement this, if possible in a way that enables code review of changes to queries in checked-in ARM templates.