{ "__inputs": [], "__elements": {}, "__requires": [ { "type": "panel", "id": "bargauge", "name": "Bar gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "10.4.1" }, { "type": "datasource", "id": "grafana-azure-monitor-datasource", "name": "Azure Monitor", "version": "1.0.0" }, { "type": "datasource", "id": "marcusolsson-json-datasource", "name": "JSON API", "version": "1.3.12" }, { "type": "panel", "id": "stat", "name": "Stat", "version": "" }, { "type": "panel", "id": "text", "name": "Text", "version": "" } ], "description": "This dashboard displays traffic-light indicators to show the health of your Azure infrastructure resources based on key performance indicators and thresholds defined for each infrastructure resource type. The KPIs and thresholds come from Azure Monitor Baseline Alerts (https://azure.github.io/azure-monitor-baseline-alerts/). \n\nPrerequisites:\nThe queries used in the dashboard require that you have resource metrics being sent to a Log Analytics Workspace. The AzureMetrics and AzureDiagnostics tables are required. This can be achieved through a resource’s diagnostic settings. For detailed instructions, refer to Azure Monitor Essentials: Diagnostic Settings: https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/diagnostic-settings#metrics\n\nInstallation and Configuration:\nThis dashboard requires the JSON API Grafana plugin and a configured data source for Azure Monitor Baseline Alerts. Follow these steps to install and configure the JSON API plugin:\n\n1. Navigate to Connections->Connect Data.\n2. Search for “JSON API” and then select the JSON API data source.\n3. Install the plugin if it is not already installed.\n4. On the JSON API plugin page, click “Create a JSON API data source\".\n5. On the create JSON API page, give it the name “AMBA” and for the URL, give it the value: https://raw.githubusercontent.com/Azure/azure-monitor-baseline-alerts/main/visualizations/grafana/infra-monitoring-amba-thresholds.json \n6. Click the Save & test button. You should see a green checkbox and Success message if configured correctly.\n\nThis is one of a collection of dashboards linked together via dashboard links and the \"azure-infra-monitor\" tag. Other dashboards in the collection include:\nAzure / Infrastructure / Network Monitoring\nAzure / Infrastructure / Apps Monitoring\nAzure / Infrastructure / Compute Monitoring\nAzure / Infrastructure / Data Monitoring\n\nThe other dashboards in this collection can be found in the Azure Monitor Team Grafana library here: https://grafana.com/orgs/azuremonitorteam/dashboards. Once imported, you will be able to access these dashboards using the Azure Infra Monitoring Dashboards tab. ", "editable": true, "id": null, "links": [ { "asDropdown": true, "icon": "external link", "includeVars": false, "keepTime": false, "tags": ["azure-infra-monitor"], "targetBlank": false, "title": "Azure Infra Monitoring Dashboards", "tooltip": "", "type": "dashboards", "url": "" } ], "liveNow": true, "panels": [ { "datasource": { "type": "datasource", "uid": "grafana" }, "gridPos": { "h": 5, "w": 12, "x": 0, "y": 0 }, "id": 1, "options": { "code": { "language": "plaintext", "showLineNumbers": false, "showMiniMap": false }, "content": "<p style=\"font-size:24px;color:rgb(87, 148, 242);\">Azure Infrastructure Monitoring Dashboard (Storage\\Vaults)</p>\r\n\r\nSelect a data source, workspace scope, workspace(s) and resource scope. \r\nExamine the key performance indicators for your resources by expanding the row for a resource type. \r\nRecommended KPIs and thresholds used in this dashboard come from [Azure Monitor Baseline Alerts](https://azure.github.io/azure-monitor-baseline-alerts/). \r\nSee dashboard description for more details on linking to other Infrastructure Monitor dashboards.", "mode": "markdown" }, "transparent": true, "type": "text" }, { "datasource": { "type": "datasource", "uid": "grafana" }, "gridPos": { "h": 5, "w": 12, "x": 12, "y": 0 }, "id": 90, "options": { "code": { "language": "plaintext", "showLineNumbers": false, "showMiniMap": false }, "content": "<br>\r\n\r\nKey:\r\n- Green\\Healthy &nbsp;- None of the resources of that resource type have KPIs that are exceeding thresholds.\r\n- Yellow\\Warning - At least one resource of that resource type has one KPI exceeding a threshold.\r\n- Red\\Unhealthy &nbsp;- At least one resource of that resource type has two or more KPIs exceeding a threshold.", "mode": "markdown" }, "transparent": true, "type": "text" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "links": [], "mappings": [ { "options": { "0": { "index": 0, "text": "Healthy" }, "1": { "index": 1, "text": "Warning" } }, "type": "value" }, { "options": { "from": 2, "result": { "index": 2, "text": "Unhealthy" }, "to": 4 }, "type": "range" } ], "max": 4, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "#808080", "value": null } ] } }, "overrides": [] }, "gridPos": { "h": 3, "w": 3, "x": 0, "y": 5 }, "id": 27, "options": { "colorMode": "background_solid", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": ["max"], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "targets": [ { "azureLogAnalytics": { "dashboardTime": true, "query": "AzureMetrics\r\n| where _ResourceId has '/microsoft.storage/'\r\n| where SubscriptionId has_any ($subsRESScope)\r\n| where MetricName in('SuccessE2ELatency', 'SuccessServerLatency', 'UsedCapacity', 'Availability')\r\n| extend ResourceName = tostring(split(_ResourceId,'/')[8])\r\n| extend _ResourceId = trim('/blobservices/default', _ResourceId)\r\n| extend _ResourceId = trim('/queueservices/default', _ResourceId)\r\n| extend _ResourceId = trim('/tableservices/default', _ResourceId)\r\n| extend _ResourceId = trim('/fileservices/default', _ResourceId)\r\n| project ResourceName, _ResourceId, MetricName, Average, Total\r\n| summarize\r\n kpi1 = avgif(Average, MetricName == 'SuccessE2ELatency'),\r\n kpi2 = avgif(Average, MetricName == 'SuccessServerLatency'),\r\n kpi3 = avgif(Average, MetricName == 'UsedCapacity'),\r\n kpi4 = avgif(Average, MetricName == 'Availability') by _ResourceId, ResourceName\r\n|extend kpi1 = iff(isnan(kpi1), 0.0, kpi1)\r\n|extend kpi2 = iff(isnan(kpi2), 0.0, kpi2) \r\n|extend kpi3 = iff(isnan(kpi3), 0.0, kpi3) \r\n|extend kpi4 = iff(isnan(kpi4), 0.0, kpi4) \r\n|extend health1 = iff(kpi1>$amba_storage_SuccessE2ELatency, 1, 0)\r\n|extend health2 = iff(kpi2>$amba_storage_SuccessServerLatency, 1, 0)\r\n|extend health3 = iff(kpi3>$amba_storage_UsedCapacity, 1, 0)\r\n|extend health4 = iff(kpi4<$amba_storage_Availability, 1, 0)\r\n|extend h1color = iff(tobool(health1), $unhealthy_color, $healthy_color)\r\n|extend h2color = iff(tobool(health2), $unhealthy_color, $healthy_color)\r\n|extend h3color = iff(tobool(health3), $unhealthy_color, $healthy_color)\r\n|extend h4color = iff(tobool(health4), $unhealthy_color, $healthy_color)\r\n|extend health = health1 + health2 + health3 + health4\r\n|extend hcolor = iff(health>1, $unhealthy_color, iff(health==1, $warning_color, $healthy_color))\r\n| order by health desc", "resources": ["$laws"], "resultFormat": "logs", "timeColumn": "TimeGenerated" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "queryType": "Azure Log Analytics", "refId": "A", "subscriptions": ["ebb79bc0-aa86-44a7-8111-cabbe0c43993"] } ], "title": "Storage", "transformations": [ { "id": "organize", "options": { "excludeByName": { "A": false, "Resource": true, "ResourceName": true, "_ResourceId": true, "h1color": true, "h2color": true, "h3color": true, "h4color": true, "health1": true, "health2": true, "health3": true, "health4": true, "kpi1": true, "kpi2": true, "kpi3": true, "kpi4": true }, "indexByName": {}, "renameByName": { "A": " ", "health": " " } } }, { "id": "configFromData", "options": { "configRefId": "A", "mappings": [ { "fieldName": "hcolor", "handlerKey": "color", "reducerId": "firstNotNull" } ] } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "links": [], "mappings": [ { "options": { "0": { "index": 0, "text": "Healthy" }, "1": { "index": 1, "text": "Warning" } }, "type": "value" }, { "options": { "from": 2, "result": { "index": 2, "text": "Unhealthy" }, "to": 3 }, "type": "range" } ], "max": 3, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "#808080", "value": null } ] } }, "overrides": [] }, "gridPos": { "h": 3, "w": 3, "x": 3, "y": 5 }, "id": 28, "options": { "colorMode": "background_solid", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": ["max"], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "targets": [ { "azureLogAnalytics": { "dashboardTime": true, "query": "let diagnostic_table = AzureDiagnostics\r\n | where _ResourceId has '/microsoft.keyvault/vaults/'\r\n | where SubscriptionId has_any ($subsRESScope)\r\n | where ResultSignature !='OK'\r\n | extend ErrorCounter = 1\r\n | project TimeGenerated, Resource, ErrorCounter, _ResourceId;\r\nAzureMetrics\r\n| where _ResourceId has '/microsoft.keyvault/vaults/'\r\n| where SubscriptionId has_any ($subsRESScope)\r\n| where MetricName in('ServiceApiLatency', 'Availability')\r\n| project Resource, _ResourceId, MetricName, Average, Total\r\n| union kind=outer diagnostic_table\r\n| summarize\r\n kpi1 = avgif(Average, MetricName == 'ServiceApiLatency'),\r\n kpi2 = sumif(ErrorCounter, isnotnull(ErrorCounter)),\r\n kpi3 = avgif(Average*100, MetricName == 'Availability') by _ResourceId, Resource\r\n|extend kpi1 = iff(isnan(kpi1), 0.0, kpi1)\r\n|extend kpi2 = iff(isnan(toreal(kpi2)), 0.0, toreal(kpi2)) \r\n|extend kpi3 = iff(isnan(kpi3), 0.0, kpi3) \r\n|extend health1 = iff(kpi1>$amba_kv_ServiceApiLatency, 1, 0)\r\n|extend health2 = iff(kpi2>$amba_kv_FailingServiceApiResult, 1, 0)\r\n|extend health3 = iff(kpi3<$amba_kv_Availability, 1, 0)\r\n|extend h1color = iff(tobool(health1), $unhealthy_color, $healthy_color)\r\n|extend h2color = iff(tobool(health2), $unhealthy_color, $healthy_color)\r\n|extend h3color = iff(tobool(health3), $unhealthy_color, $healthy_color)\r\n|extend health = health1 + health2 + health3\r\n|extend hcolor = iff(health>1, $unhealthy_color, iff(health==1, $warning_color, $healthy_color))\r\n| order by health desc", "resources": ["$laws"], "resultFormat": "logs", "timeColumn": "TimeGenerated" }, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "queryType": "Azure Log Analytics", "refId": "A", "subscriptions": ["ebb79bc0-aa86-44a7-8111-cabbe0c43993"] } ], "title": "Key Vaults", "transformations": [ { "id": "organize", "options": { "excludeByName": { "A": false, "Resource": true, "_ResourceId": true, "h1color": true, "h2color": true, "h3color": true, "health1": true, "health2": true, "health3": true, "kpi1": true, "kpi2": true, "kpi3": true, "kpi4": true }, "includeByName": {}, "indexByName": {}, "renameByName": { "A": " ", "health": " " } } }, { "id": "configFromData", "options": { "configRefId": "A", "mappings": [ { "fieldName": "hcolor", "handlerKey": "color", "reducerId": "firstNotNull" } ] } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "grafana" }, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 8 }, "id": 25, "options": { "code": { "language": "plaintext", "showLineNumbers": false, "showMiniMap": false }, "content": "", "mode": "markdown" }, "transparent": true, "type": "text" }, { "collapsed": true, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 9 }, "id": 23, "panels": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "mode": "fixed" }, "displayName": "${__field.displayName}", "mappings": [], "max": 1200, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "#808080" } ] } }, "overrides": [] }, "gridPos": { "h": 12, "w": 6, "x": 0, "y": 9 }, "id": 29, "options": { "displayMode": "gradient", "maxVizHeight": 300, "minVizHeight": 10, "minVizWidth": 0, "namePlacement": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": ["lastNotNull"], "fields": "", "values": true }, "showUnfilled": true, "sizing": "auto", "valueMode": "color" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 27, "refId": "A" } ], "title": "Storage Success End to End Latency", "transformations": [ { "id": "organize", "options": { "excludeByName": { "_ResourceId": true, "h1color": false, "h2color": true, "h3color": true, "h4color": true, "hcolor": true, "health": true, "health1": true, "health2": true, "health3": true, "health4": true, "kpi2": true, "kpi3": true, "kpi4": true }, "includeByName": {}, "indexByName": {}, "renameByName": {} } }, { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": true, "field": "kpi1" } ] } }, { "id": "rowsToFields", "options": { "mappings": [ { "fieldName": "ResourceName", "handlerKey": "field.name" }, { "fieldName": "kpi1", "handlerKey": "field.value" }, { "fieldName": "h1color", "handlerKey": "color" } ] } } ], "type": "bargauge" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "mode": "fixed" }, "displayName": "${__field.displayName}", "mappings": [], "max": 1200, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "#808080" } ] } }, "overrides": [] }, "gridPos": { "h": 12, "w": 6, "x": 6, "y": 9 }, "id": 30, "options": { "displayMode": "gradient", "maxVizHeight": 300, "minVizHeight": 10, "minVizWidth": 0, "namePlacement": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": ["lastNotNull"], "fields": "", "values": true }, "showUnfilled": true, "sizing": "auto", "valueMode": "color" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 27, "refId": "A" } ], "title": "Storage Success Server Latency", "transformations": [ { "id": "organize", "options": { "excludeByName": { "_ResourceId": true, "h1color": true, "h2color": false, "h3color": true, "h4color": true, "hcolor": true, "health": true, "health1": true, "health2": true, "health3": true, "health4": true, "kpi1": true, "kpi2": false, "kpi3": true, "kpi4": true }, "includeByName": {}, "indexByName": {}, "renameByName": {} } }, { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": true, "field": "kpi2" } ] } }, { "id": "rowsToFields", "options": { "mappings": [ { "fieldName": "ResourceName", "handlerKey": "field.name" }, { "fieldName": "kpi2", "handlerKey": "field.value" }, { "fieldName": "h2color", "handlerKey": "color" } ] } } ], "type": "bargauge" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "mode": "fixed" }, "displayName": "${__field.displayName}", "mappings": [], "max": 4000000000000000, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "#808080" } ] } }, "overrides": [] }, "gridPos": { "h": 12, "w": 6, "x": 12, "y": 9 }, "id": 94, "options": { "displayMode": "gradient", "maxVizHeight": 300, "minVizHeight": 10, "minVizWidth": 0, "namePlacement": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": ["lastNotNull"], "fields": "", "values": true }, "showUnfilled": true, "sizing": "auto", "valueMode": "color" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 27, "refId": "A" } ], "title": "Storage Used Capacity", "transformations": [ { "id": "organize", "options": { "excludeByName": { "_ResourceId": true, "h1color": true, "h2color": true, "h3color": false, "h4color": true, "hcolor": true, "health": true, "health1": true, "health2": true, "health3": true, "health4": true, "kpi1": true, "kpi2": true, "kpi3": false, "kpi4": true }, "includeByName": {}, "indexByName": {}, "renameByName": {} } }, { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "regex", "options": { "value": ".*NaN" } }, "fieldName": "kpi3" } ], "match": "any", "type": "exclude" } }, { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": true, "field": "kpi3" } ] } }, { "id": "rowsToFields", "options": { "mappings": [ { "fieldName": "ResourceName", "handlerKey": "field.name" }, { "fieldName": "kpi3", "handlerKey": "field.value" }, { "fieldName": "h3color", "handlerKey": "color" } ] } } ], "type": "bargauge" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "mode": "fixed" }, "displayName": "${__field.displayName}", "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "#808080" } ] } }, "overrides": [] }, "gridPos": { "h": 12, "w": 6, "x": 18, "y": 9 }, "id": 31, "options": { "displayMode": "gradient", "maxVizHeight": 300, "minVizHeight": 10, "minVizWidth": 0, "namePlacement": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": ["lastNotNull"], "fields": "", "values": true }, "showUnfilled": true, "sizing": "auto", "valueMode": "color" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 27, "refId": "A" } ], "title": "Storage Availability", "transformations": [ { "id": "organize", "options": { "excludeByName": { "_ResourceId": true, "h1color": true, "h2color": true, "h3color": true, "h4color": false, "hcolor": true, "health": true, "health1": true, "health2": true, "health3": true, "health4": true, "kpi1": true, "kpi2": true, "kpi3": true }, "includeByName": {}, "indexByName": {}, "renameByName": {} } }, { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": false, "field": "kpi4" } ] } }, { "id": "rowsToFields", "options": { "mappings": [ { "fieldName": "ResourceName", "handlerKey": "field.name" }, { "fieldName": "kpi4", "handlerKey": "field.value" }, { "fieldName": "h4color", "handlerKey": "color" } ] } } ], "type": "bargauge" } ], "title": "Storage", "type": "row" }, { "collapsed": true, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 10 }, "id": 24, "panels": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "mode": "fixed" }, "displayName": "${__field.displayName}", "mappings": [], "max": 2000, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "#808080" } ] } }, "overrides": [] }, "gridPos": { "h": 12, "w": 6, "x": 0, "y": 10 }, "id": 32, "options": { "displayMode": "gradient", "maxVizHeight": 300, "minVizHeight": 10, "minVizWidth": 0, "namePlacement": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": ["lastNotNull"], "fields": "", "values": true }, "showUnfilled": true, "sizing": "auto", "valueMode": "color" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 28, "refId": "A" } ], "title": "Key Vault Service API Latency", "transformations": [ { "id": "organize", "options": { "excludeByName": { "_ResourceId": true, "h2color": true, "h3color": true, "hcolor": true, "health": true, "health1": true, "health2": true, "health3": true, "kpi2": true, "kpi3": true }, "includeByName": {}, "indexByName": {}, "renameByName": {} } }, { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": true, "field": "kpi1" } ] } }, { "id": "rowsToFields", "options": { "mappings": [ { "fieldName": "Resource", "handlerKey": "field.name" }, { "fieldName": "kpi1", "handlerKey": "field.value" }, { "fieldName": "h1color", "handlerKey": "color" } ] } } ], "type": "bargauge" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "mode": "fixed" }, "displayName": "${__field.displayName}", "mappings": [], "max": 1000, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "#808080" } ] } }, "overrides": [] }, "gridPos": { "h": 12, "w": 6, "x": 6, "y": 10 }, "id": 33, "options": { "displayMode": "gradient", "maxVizHeight": 300, "minVizHeight": 10, "minVizWidth": 0, "namePlacement": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": ["lastNotNull"], "fields": "", "values": true }, "showUnfilled": true, "sizing": "auto", "valueMode": "color" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 28, "refId": "A" } ], "title": "Key Vault Failing Transactions", "transformations": [ { "id": "organize", "options": { "excludeByName": { "_ResourceId": true, "h1color": true, "h3color": true, "hcolor": true, "health": true, "health1": true, "health2": true, "health3": true, "kpi1": true, "kpi2": false, "kpi3": true }, "includeByName": {}, "indexByName": {}, "renameByName": {} } }, { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": true, "field": "kpi1" } ] } }, { "id": "rowsToFields", "options": { "mappings": [ { "fieldName": "Resource", "handlerKey": "field.name" }, { "fieldName": "kpi2", "handlerKey": "field.value" }, { "fieldName": "h2color", "handlerKey": "color" } ] } } ], "type": "bargauge" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "mode": "fixed" }, "displayName": "${__field.displayName}", "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "#808080" } ] } }, "overrides": [] }, "gridPos": { "h": 12, "w": 6, "x": 12, "y": 10 }, "id": 51, "options": { "displayMode": "gradient", "maxVizHeight": 300, "minVizHeight": 10, "minVizWidth": 0, "namePlacement": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": ["lastNotNull"], "fields": "", "values": true }, "showUnfilled": true, "sizing": "auto", "valueMode": "color" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 28, "refId": "A" } ], "title": "Key Vault Availability", "transformations": [ { "id": "organize", "options": { "excludeByName": { "_ResourceId": true, "h1color": true, "h2color": true, "hcolor": true, "health": true, "health1": true, "health2": true, "health3": true, "kpi1": true, "kpi2": true, "kpi3": false }, "includeByName": {}, "indexByName": {}, "renameByName": {} } }, { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": false, "field": "kpi3" } ] } }, { "id": "rowsToFields", "options": { "mappings": [ { "fieldName": "Resource", "handlerKey": "field.name" }, { "fieldName": "kpi3", "handlerKey": "field.value" }, { "fieldName": "h3color", "handlerKey": "color" } ] } } ], "type": "bargauge" } ], "title": "Key Vaults", "type": "row" } ], "refresh": "", "schemaVersion": 39, "tags": ["azure-infra-monitor"], "templating": { "list": [ { "current": {}, "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": {}, "hide": 2, "includeAll": false, "label": "Azure Monitor Baseline Alerts", "multi": false, "name": "amba", "options": [], "query": "marcusolsson-json-datasource", "refresh": 1, "regex": "", "skipUrlSync": false, "type": "datasource" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "", "description": "Subscriptions used to filter Log Analytics Workspaces variable.", "hide": 0, "includeAll": false, "label": "Workspace Scope", "multi": true, "name": "subsWSScope", "options": [], "query": { "azureLogAnalytics": { "query": "", "resources": [] }, "queryType": "Azure Subscriptions", "refId": "A" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 5, "type": "query" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "", "description": "Log Analytics Workspaces in scope.", "hide": 0, "includeAll": false, "label": "Workspaces", "multi": true, "name": "laws", "options": [], "query": { "azureLogAnalytics": { "query": "", "resources": [] }, "azureResourceGraph": { "query": "resources\r\n| where type == \"microsoft.operationalinsights/workspaces\"\r\n| project value=['id'], text=['name']" }, "queryType": "Azure Resource Graph", "refId": "A", "subscriptions": ["$subsWSScope"] }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "type": "query" }, { "current": {}, "datasource": { "type": "grafana-azure-monitor-datasource", "uid": "${ds}" }, "definition": "", "description": "Subscriptions used to filter resources returned from queries.", "hide": 0, "includeAll": false, "label": "Resource Scope", "multi": true, "name": "subsRESScope", "options": [], "query": { "azureLogAnalytics": { "query": "", "resources": [] }, "queryType": "Azure Subscriptions", "refId": "A" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 5, "type": "query" }, { "current": { "selected": false, "text": "\"rgb(45,161,55)\"", "value": "\"rgb(45,161,55)\"" }, "description": "Color used when KPIs are below thresholds.", "hide": 2, "includeAll": false, "multi": false, "name": "healthy_color", "options": [ { "selected": true, "text": "\"rgb(45,161,55)\"", "value": "\"rgb(45,161,55)\"" } ], "query": "\"rgb(45\\,161\\,55)\"", "skipUrlSync": false, "type": "custom" }, { "current": { "selected": false, "text": "\"rgb(222,210,38)\"", "value": "\"rgb(222,210,38)\"" }, "description": "Color used when one KPI exceeds threshold", "hide": 2, "includeAll": false, "multi": false, "name": "warning_color", "options": [ { "selected": true, "text": "\"rgb(222,210,38)\"", "value": "\"rgb(222,210,38)\"" } ], "query": "\"rgb(222\\,210\\,38)\"", "skipUrlSync": false, "type": "custom" }, { "current": { "selected": false, "text": "\"rgb(255,31,46)\"", "value": "\"rgb(255,31,46)\"" }, "description": "Color used when KPIs exceed thresholds", "hide": 2, "includeAll": false, "multi": false, "name": "unhealthy_color", "options": [ { "selected": true, "text": "\"rgb(255,31,46)\"", "value": "\"rgb(255,31,46)\"" } ], "query": "\"rgb(255\\,31\\,46)\"", "skipUrlSync": false, "type": "custom" }, { "current": {}, "datasource": { "type": "marcusolsson-json-datasource", "uid": "${amba}" }, "definition": "\"Microsoft.Storage/storageAccounts\".\"Availability\"", "hide": 2, "includeAll": false, "multi": false, "name": "amba_storage_Availability", "options": [], "query": { "cacheDurationSeconds": 300, "fields": [ { "jsonPath": "\"Microsoft.Storage/storageAccounts\".\"Availability\"", "language": "jsonata" } ], "method": "GET", "queryParams": "", "urlPath": "" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "type": "query" }, { "current": {}, "datasource": { "type": "marcusolsson-json-datasource", "uid": "${amba}" }, "definition": "\"Microsoft.Storage/storageAccounts\".\"UsedCapacity\"", "hide": 2, "includeAll": false, "multi": false, "name": "amba_storage_UsedCapacity", "options": [], "query": { "cacheDurationSeconds": 300, "fields": [ { "jsonPath": "\"Microsoft.Storage/storageAccounts\".\"UsedCapacity\"", "language": "jsonata" } ], "method": "GET", "queryParams": "", "urlPath": "" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "type": "query" }, { "current": {}, "datasource": { "type": "marcusolsson-json-datasource", "uid": "${amba}" }, "definition": "\"Microsoft.Storage/storageAccounts\".\"SuccessE2ELatency\"", "hide": 2, "includeAll": false, "multi": false, "name": "amba_storage_SuccessE2ELatency", "options": [], "query": { "cacheDurationSeconds": 300, "fields": [ { "jsonPath": "\"Microsoft.Storage/storageAccounts\".\"SuccessE2ELatency\"", "language": "jsonata" } ], "method": "GET", "queryParams": "", "urlPath": "" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "type": "query" }, { "current": {}, "datasource": { "type": "marcusolsson-json-datasource", "uid": "${amba}" }, "definition": "\"Microsoft.Storage/storageAccounts\".\"SuccessServerLatency\"", "hide": 2, "includeAll": false, "multi": false, "name": "amba_storage_SuccessServerLatency", "options": [], "query": { "cacheDurationSeconds": 300, "fields": [ { "jsonPath": "\"Microsoft.Storage/storageAccounts\".\"SuccessServerLatency\"", "language": "jsonata" } ], "method": "GET", "queryParams": "", "urlPath": "" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "type": "query" }, { "current": {}, "datasource": { "type": "marcusolsson-json-datasource", "uid": "${amba}" }, "definition": "\"Microsoft.KeyVault/vaults\".\"Availability\"", "hide": 2, "includeAll": false, "multi": false, "name": "amba_kv_Availability", "options": [], "query": { "cacheDurationSeconds": 300, "fields": [ { "jsonPath": "\"Microsoft.KeyVault/vaults\".\"Availability\"", "language": "jsonata" } ], "method": "GET", "queryParams": "", "urlPath": "" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "type": "query" }, { "current": {}, "datasource": { "type": "marcusolsson-json-datasource", "uid": "${amba}" }, "definition": "\"Microsoft.KeyVault/vaults\".\"ServiceApiLatency\"", "hide": 2, "includeAll": false, "multi": false, "name": "amba_kv_ServiceApiLatency", "options": [], "query": { "cacheDurationSeconds": 300, "fields": [ { "jsonPath": "\"Microsoft.KeyVault/vaults\".\"ServiceApiLatency\"", "language": "jsonata" } ], "method": "GET", "queryParams": "", "urlPath": "" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "type": "query" }, { "current": {}, "datasource": { "type": "marcusolsson-json-datasource", "uid": "${amba}" }, "definition": "\"Microsoft.KeyVault/vaults\".\"FailingServiceApiResult\"", "hide": 2, "includeAll": false, "multi": false, "name": "amba_kv_FailingServiceApiResult", "options": [], "query": { "cacheDurationSeconds": 300, "fields": [ { "jsonPath": "\"Microsoft.KeyVault/vaults\".\"FailingServiceApiResult\"", "language": "jsonata" } ], "method": "GET", "queryParams": "", "urlPath": "" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "type": "query" } ] }, "time": { "from": "now-6h", "to": "now" }, "timepicker": {}, "timezone": "", "title": "Azure / Infrastructure / Storage and Key Vaults Monitoring", "version": 25 }