{ "__inputs": [], "__elements": [], "__requires": [ { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "8.5.1" }, { "type": "datasource", "id": "grafana-azure-monitor-datasource", "name": "Azure Monitor", "version": "1.0.0" }, { "type": "panel", "id": "table", "name": "Table", "version": "" }, { "type": "panel", "id": "timeseries", "name": "Time series", "version": "" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "datasource", "uid": "grafana" }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "target": { "limit": 100, "matchAny": false, "tags": [], "type": "dashboard" }, "type": "dashboard" } ] }, "editable": true, "id": null, "links": [], "liveNow": false, "panels": [ { "collapsed": false, "datasource": { "type": "datasource", "uid": "grafana" }, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 0 }, "id": 12, "panels": [], "repeat": "resfrontdoor", "title": "Front Door - ${resfrontdoor}", "type": "row" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "displayMode": "auto", "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 24, "x": 0, "y": 1 }, "id": 18, "options": { "footer": { "fields": "", "reducer": ["sum"], "show": false }, "showHeader": true }, "targets": [ { "azureMonitor": { "dimensionFilters": [], "timeGrain": "auto" }, "azureResourceGraph": { "query": "resources\r\n| where tolower(subscriptionId) == tolower(\"$sub\") and tolower(resourceGroup) == tolower(\"$rg\") and tolower(name) == tolower($resfrontdoor)\r\n| project Name=name, sku.name, location, subscriptionId\r\n| join kind=inner(\r\n resourcecontainers\r\n | where type == \"microsoft.resources/subscriptions\" and tolower(subscriptionId) == tolower(\"$sub\")\r\n | project subscriptionId, Subscription = name\r\n) on subscriptionId\r\n| project-away subscriptionId, subscriptionId1\r\n| join kind=leftouter(\r\n alertsmanagementresources\r\n | where tolower(properties.context.context.resourceName) == tolower($resfrontdoor)\r\n | summarize count() by tostring(properties.context.context.resourceName), subscriptionId\r\n | project properties_context_context_resourceName, count_, subscriptionId\r\n) on $left.Name == $right.properties_context_context_resourceName\r\n| project Name, Alerts=iff(isnull(count_), 0, count_), SKU=tostring(sku_name), Subscription, Location=location\r\n" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "queryType": "Azure Resource Graph", "refId": "A", "subscriptions": ["$sub"] } ], "type": "table" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 0, "y": 3 }, "id": 14, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Average", "dimensionFilters": [], "metricDefinition": "$frontdoor", "metricName": "OriginLatency", "metricNamespace": "$frontdoor", "resourceGroup": "$rg", "resourceName": "$resfrontdoor", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "queryType": "Azure Monitor", "refId": "A", "subscription": "$sub" } ], "title": "Origin Latency", "type": "timeseries" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 6, "y": 3 }, "id": 30, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Average", "dimensionFilters": [], "metricDefinition": "$frontdoor", "metricName": "RequestCount", "metricNamespace": "$frontdoor", "resourceGroup": "$rg", "resourceName": "$resfrontdoor", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "queryType": "Azure Monitor", "refId": "A", "subscription": "$sub" } ], "title": "Request Count", "type": "timeseries" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 12, "y": 3 }, "id": 31, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Average", "dimensionFilters": [], "metricDefinition": "$frontdoor", "metricName": "TotalLatency", "metricNamespace": "$frontdoor", "resourceGroup": "$rg", "resourceName": "$resfrontdoor", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "queryType": "Azure Monitor", "refId": "A", "subscription": "$sub" } ], "title": "Total Latency", "type": "timeseries" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 18, "y": 3 }, "id": 32, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Average", "dimensionFilters": [], "metricDefinition": "$frontdoor", "metricName": "OriginHealthPercentage", "metricNamespace": "$frontdoor", "resourceGroup": "$rg", "resourceName": "$resfrontdoor", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "queryType": "Azure Monitor", "refId": "A", "subscription": "$sub" } ], "title": "Origin Health Percentage", "type": "timeseries" }, { "collapsed": false, "datasource": { "type": "datasource", "uid": "grafana" }, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 13 }, "id": 10, "panels": [], "repeat": "restrafficmanager", "title": "Traffic Manager - ${restrafficmanager}", "type": "row" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "displayMode": "auto", "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 24, "x": 0, "y": 14 }, "id": 21, "options": { "footer": { "fields": "", "reducer": ["sum"], "show": false }, "showHeader": true }, "targets": [ { "azureMonitor": { "dimensionFilters": [], "timeGrain": "auto" }, "azureResourceGraph": { "query": "resources\r\n| where tolower(subscriptionId) == tolower(\"$sub\") and tolower(resourceGroup) == tolower(\"$rg\") and tolower(name) == tolower($restrafficmanager)\r\n| project Name=name, sku.name, location, subscriptionId\r\n| join kind=inner(\r\n resourcecontainers\r\n | where type == \"microsoft.resources/subscriptions\" and tolower(subscriptionId) == tolower(\"$sub\")\r\n | project subscriptionId, Subscription = name\r\n) on subscriptionId\r\n| project-away subscriptionId, subscriptionId1\r\n| join kind=leftouter(\r\n alertsmanagementresources\r\n | where tolower(properties.context.context.resourceName) == tolower($restrafficmanager)\r\n | summarize count() by tostring(properties.context.context.resourceName), subscriptionId\r\n | project properties_context_context_resourceName, count_, subscriptionId\r\n) on $left.Name == $right.properties_context_context_resourceName\r\n| project Name, Alerts=iff(isnull(count_), 0, count_), SKU=tostring(sku_name), Subscription, Location=location\r\n" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "queryType": "Azure Resource Graph", "refId": "A", "subscriptions": ["$sub"] } ], "type": "table" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 12, "x": 0, "y": 16 }, "id": 16, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Total", "dimensionFilters": [], "metricDefinition": "$trafficmanager", "metricName": "ProbeAgentCurrentEndpointStateByProfileResourceId", "metricNamespace": "$trafficmanager", "resourceGroup": "$rg", "resourceName": "$restrafficmanager", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "hide": false, "queryType": "Azure Monitor", "refId": "B", "subscription": "$sub" } ], "title": "Endpoint Status by Endpoint", "type": "timeseries" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 12, "x": 12, "y": 16 }, "id": 26, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Maximum", "dimensionFilters": [], "metricDefinition": "$trafficmanager", "metricName": "QpsByEndpoint", "metricNamespace": "$trafficmanager", "resourceGroup": "$rg", "resourceName": "$restrafficmanager", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "hide": false, "queryType": "Azure Monitor", "refId": "B", "subscription": "$sub" } ], "title": "Queries by Endpoint Returned", "type": "timeseries" }, { "collapsed": false, "datasource": { "type": "datasource", "uid": "grafana" }, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 26 }, "id": 6, "panels": [], "repeat": "resapplicationgateway", "title": "Application Gateways - ${resapplicationgateway}", "type": "row" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "displayMode": "auto", "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 24, "x": 0, "y": 27 }, "id": 22, "options": { "footer": { "fields": "", "reducer": ["sum"], "show": false }, "showHeader": true }, "targets": [ { "azureMonitor": { "dimensionFilters": [], "timeGrain": "auto" }, "azureResourceGraph": { "query": "resources\r\n| where tolower(subscriptionId) == tolower(\"$sub\") and tolower(resourceGroup) == tolower(\"$rg\") and tolower(name) == tolower($resapplicationgateway)\r\n| project Name=name, sku.name, location, subscriptionId\r\n| join kind=inner(\r\n resourcecontainers\r\n | where type == \"microsoft.resources/subscriptions\" and tolower(subscriptionId) == tolower(\"$sub\")\r\n | project subscriptionId, Subscription = name\r\n) on subscriptionId\r\n| project-away subscriptionId, subscriptionId1\r\n| join kind=leftouter(\r\n alertsmanagementresources\r\n | where tolower(properties.context.context.resourceName) == tolower($resapplicationgateway)\r\n | summarize count() by tostring(properties.context.context.resourceName), subscriptionId\r\n | project properties_context_context_resourceName, count_, subscriptionId\r\n) on $left.Name == $right.properties_context_context_resourceName\r\n| project Name, Alerts=iff(isnull(count_), 0, count_), SKU=tostring(sku_name), Subscription, Location=location\r\n" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "queryType": "Azure Resource Graph", "refId": "A", "subscriptions": ["$sub"] } ], "type": "table" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 0, "y": 29 }, "id": 8, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Average", "dimensionFilters": [], "metricDefinition": "$applicationgateway", "metricName": "Throughput", "metricNamespace": "$applicationgateway", "resourceGroup": "$rg", "resourceName": "$resapplicationgateway", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "hide": false, "queryType": "Azure Monitor", "refId": "A", "subscription": "$sub" } ], "title": "Throughput", "type": "timeseries" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 6, "y": 29 }, "id": 23, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Average", "dimensionFilters": [], "metricDefinition": "$applicationgateway", "metricName": "UnhealthyHostCount", "metricNamespace": "$applicationgateway", "resourceGroup": "$rg", "resourceName": "$resapplicationgateway", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "hide": false, "queryType": "Azure Monitor", "refId": "D", "subscription": "$sub" } ], "title": "Unhealthy Host Count", "type": "timeseries" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 12, "y": 29 }, "id": 24, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Total", "dimensionFilters": [], "metricDefinition": "$applicationgateway", "metricName": "FailedRequests", "metricNamespace": "$applicationgateway", "resourceGroup": "$rg", "resourceName": "$resapplicationgateway", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "hide": false, "queryType": "Azure Monitor", "refId": "C", "subscription": "$sub" } ], "title": "Failed Requests", "type": "timeseries" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 18, "y": 29 }, "id": 25, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Total", "dimensionFilters": [], "metricDefinition": "$applicationgateway", "metricName": "ResponseStatus", "metricNamespace": "$applicationgateway", "resourceGroup": "$rg", "resourceName": "$resapplicationgateway", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "hide": false, "queryType": "Azure Monitor", "refId": "B", "subscription": "$sub" } ], "title": "Response Status", "type": "timeseries" }, { "collapsed": false, "datasource": { "type": "datasource", "uid": "grafana" }, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 39 }, "id": 4, "panels": [], "repeat": "resloadbalancer", "title": "Load Balancers - ${resloadbalancer}", "type": "row" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "displayMode": "auto", "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 24, "x": 0, "y": 40 }, "id": 19, "options": { "footer": { "fields": "", "reducer": ["sum"], "show": false }, "showHeader": true }, "targets": [ { "azureMonitor": { "dimensionFilters": [], "timeGrain": "auto" }, "azureResourceGraph": { "query": "resources\r\n| where tolower(subscriptionId) == tolower(\"$sub\") and tolower(resourceGroup) == tolower(\"$rg\") and tolower(name) == tolower($resloadbalancer)\r\n| project Name=name, sku.name, location, subscriptionId\r\n| join kind=inner(\r\n resourcecontainers\r\n | where type == \"microsoft.resources/subscriptions\" and tolower(subscriptionId) == tolower(\"$sub\")\r\n | project subscriptionId, Subscription = name\r\n) on subscriptionId\r\n| project-away subscriptionId, subscriptionId1\r\n| join kind=leftouter(\r\n alertsmanagementresources\r\n | where tolower(properties.context.context.resourceName) == tolower($resloadbalancer)\r\n | summarize count() by tostring(properties.context.context.resourceName), subscriptionId\r\n | project properties_context_context_resourceName, count_, subscriptionId\r\n) on $left.Name == $right.properties_context_context_resourceName\r\n| project Name, Alerts=iff(isnull(count_), 0, count_), SKU=tostring(sku_name), Subscription, Location=location\r\n" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "queryType": "Azure Resource Graph", "refId": "A", "subscriptions": ["$sub"] } ], "type": "table" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 0, "y": 42 }, "id": 2, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Total", "dimensionFilters": [], "metricDefinition": "$loadbalancer", "metricName": "SYNCount", "metricNamespace": "$loadbalancer", "resourceGroup": "$rg", "resourceName": "$resloadbalancer", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "hide": false, "queryType": "Azure Monitor", "refId": "C", "subscription": "$sub" } ], "title": "SYN Count", "transformations": [], "type": "timeseries" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 6, "y": 42 }, "id": 29, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Total", "dimensionFilters": [], "metricDefinition": "$loadbalancer", "metricName": "SnatConnectionCount", "metricNamespace": "$loadbalancer", "resourceGroup": "$rg", "resourceName": "$resloadbalancer", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "hide": false, "queryType": "Azure Monitor", "refId": "B", "subscription": "$sub" } ], "title": "SNAT Connection Count", "transformations": [], "type": "timeseries" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 12, "y": 42 }, "id": 28, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Average", "dimensionFilters": [], "metricDefinition": "$loadbalancer", "metricName": "VipAvailability", "metricNamespace": "$loadbalancer", "resourceGroup": "$rg", "resourceName": "$resloadbalancer", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "hide": false, "queryType": "Azure Monitor", "refId": "E", "subscription": "$sub" } ], "title": "Data Path Availability", "transformations": [], "type": "timeseries" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 10, "w": 6, "x": 18, "y": 42 }, "id": 27, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "azureMonitor": { "aggregation": "Average", "dimensionFilters": [], "metricDefinition": "$loadbalancer", "metricName": "DipAvailability", "metricNamespace": "microsoft.network/loadbalancers", "resourceGroup": "$rg", "resourceName": "$resloadbalancer", "timeGrain": "auto" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "hide": false, "queryType": "Azure Monitor", "refId": "A", "subscription": "$sub" } ], "title": "Health Probe Status", "transformations": [], "type": "timeseries" } ], "refresh": false, "schemaVersion": 36, "tags": [], "templating": { "list": [ { "current": { "selected": false, "text": "Azure Monitor-Contoso", "value": "Azure Monitor-Contoso" }, "hide": 0, "includeAll": false, "label": "Datasource", "multi": false, "name": "ds", "options": [], "query": "grafana-azure-monitor-datasource", "queryValue": "", "refresh": 1, "regex": "", "skipUrlSync": false, "type": "datasource" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "", "hide": 0, "includeAll": false, "label": "Subscription", "multi": false, "name": "sub", "options": [], "query": { "grafanaTemplateVariableFn": { "kind": "SubscriptionsQuery", "rawQuery": "subscriptions()" }, "queryType": "Grafana Template Variable Function", "refId": "A" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 5, "type": "query" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "", "hide": 0, "includeAll": false, "label": "Resource Group", "multi": false, "name": "rg", "options": [], "query": { "grafanaTemplateVariableFn": { "kind": "ResourceGroupsQuery", "rawQuery": "resourcegroups($sub)", "subscription": "$sub" }, "queryType": "Grafana Template Variable Function", "refId": "A" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 5, "type": "query" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "", "hide": 2, "includeAll": false, "label": "Namespaces", "multi": false, "name": "loadbalancer", "options": [], "query": { "grafanaTemplateVariableFn": { "kind": "MetricNamespaceQuery", "rawQuery": "namespaces($sub,$rg)", "resourceGroup": "$rg", "subscription": "$sub" }, "queryType": "Grafana Template Variable Function", "refId": "A" }, "refresh": 1, "regex": "([Mm](icrosoft)\\.[Nn](etwork)/(load)[Bb](alancers))", "skipUrlSync": false, "sort": 5, "type": "query" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "namespaces($sub,$rg)", "hide": 2, "includeAll": false, "multi": false, "name": "applicationgateway", "options": [], "query": { "grafanaTemplateVariableFn": { "kind": "MetricNamespaceQuery", "rawQuery": "namespaces($sub,$rg)", "resourceGroup": "$rg", "subscription": "$sub" }, "queryType": "Grafana Template Variable Function", "refId": "A" }, "refresh": 1, "regex": "([Mm](icrosoft)\\.[Nn](etwork)/(application)[Gg](ateways))", "skipUrlSync": false, "sort": 5, "type": "query" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "namespaces($sub,$rg)", "hide": 2, "includeAll": false, "multi": false, "name": "trafficmanager", "options": [], "query": { "grafanaTemplateVariableFn": { "kind": "MetricNamespaceQuery", "rawQuery": "namespaces($sub,$rg)", "resourceGroup": "$rg", "subscription": "$sub" }, "queryType": "Grafana Template Variable Function", "refId": "A" }, "refresh": 1, "regex": "([Mm](icrosoft)\\.[Nn](etwork)/(traffic)[Mm](anager)[Pp](rofiles))", "skipUrlSync": false, "sort": 5, "type": "query" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "namespaces($sub,$rg)", "hide": 2, "includeAll": false, "multi": false, "name": "frontdoor", "options": [], "query": { "grafanaTemplateVariableFn": { "kind": "MetricNamespaceQuery", "rawQuery": "namespaces($sub,$rg)", "resourceGroup": "$rg", "subscription": "$sub" }, "queryType": "Grafana Template Variable Function", "refId": "A" }, "refresh": 1, "regex": "([Mm](icrosoft)\\.[Cc](dn)/[Pp](rofiles))", "skipUrlSync": false, "sort": 5, "type": "query" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "", "description": "", "hide": 0, "includeAll": false, "label": "Load Balancers", "multi": true, "name": "resloadbalancer", "options": [], "query": { "grafanaTemplateVariableFn": { "kind": "ResourceNamesQuery", "metricDefinition": "$loadbalancer", "rawQuery": "resourcenames($sub,$rg,$loadbalancer)", "resourceGroup": "$rg", "subscription": "$sub" }, "queryType": "Grafana Template Variable Function", "refId": "A" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 5, "type": "query" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "", "description": "", "hide": 0, "includeAll": false, "label": "Application Gateways", "multi": true, "name": "resapplicationgateway", "options": [], "query": { "grafanaTemplateVariableFn": { "kind": "ResourceNamesQuery", "metricDefinition": "$applicationgateway", "rawQuery": "resourcenames($sub,$rg,$applicationgateway)", "resourceGroup": "$rg", "subscription": "$sub" }, "queryType": "Grafana Template Variable Function", "refId": "A" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 5, "type": "query" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "", "description": "", "hide": 0, "includeAll": false, "label": "Traffic Managers", "multi": true, "name": "restrafficmanager", "options": [], "query": { "grafanaTemplateVariableFn": { "kind": "ResourceNamesQuery", "metricDefinition": "$trafficmanager", "rawQuery": "resourcenames($sub,$rg,$trafficmanager)", "resourceGroup": "$rg", "subscription": "$sub" }, "queryType": "Grafana Template Variable Function", "refId": "A" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 5, "type": "query" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "", "description": "", "hide": 0, "includeAll": false, "label": "Front doors", "multi": true, "name": "resfrontdoor", "options": [], "query": { "grafanaTemplateVariableFn": { "kind": "ResourceNamesQuery", "metricDefinition": "$frontdoor", "rawQuery": "resourcenames($sub,$rg,$frontdoor)", "resourceGroup": "$rg", "subscription": "$sub" }, "queryType": "Grafana Template Variable Function", "refId": "A" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 5, "type": "query" } ] }, "time": { "from": "now-6h", "to": "now" }, "timepicker": {}, "timezone": "", "title": "Azure / Insights / Networks", "uid": "HnOq_Xunk", "version": 39 }