{ "version": "Notebook/1.0", "items": [ { "type": 9, "content": { "version": "KqlParameterItem/1.0", "crossComponentResources": [ "{Subscription}" ], "parameters": [ { "id": "206dbaeb-5e70-46b0-a4be-6a2c478d573a", "version": "KqlParameterItem/1.0", "name": "Subscription", "type": 6, "isRequired": true, "value": "/subscriptions/91b6f239-023c-442d-a060-b12136cb705a", "typeSettings": { "additionalResourceOptions": [], "includeAll": true }, "timeContext": { "durationMs": 86400000 } }, { "id": "0c9f2a80-bafd-4be3-af49-27262f23b10c", "version": "KqlParameterItem/1.0", "name": "Service", "type": 2, "isRequired": true, "query": "Resources\r\n| extend service = tostring(tags.Service)\r\n| project service\r\n| where service != \"\"\r\n| distinct service\r\n", "crossComponentResources": [ "{Subscription}" ], "value": "SAP", "typeSettings": { "additionalResourceOptions": [], "showDefault": false }, "timeContext": { "durationMs": 86400000 }, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources" }, { "id": "f981f7e2-0419-4cbe-8eea-ca75e3e679b4", "version": "KqlParameterItem/1.0", "name": "Timeframe", "type": 4, "isRequired": true, "value": { "durationMs": 604800000 }, "typeSettings": { "selectableValues": [ { "durationMs": 604800000 }, { "durationMs": 2592000000 }, { "durationMs": 7776000000 } ] }, "timeContext": { "durationMs": 86400000 } }, { "id": "a7d9da7f-1dad-46f2-a2a1-f1201f738e41", "version": "KqlParameterItem/1.0", "name": "VirtualMachines", "type": 2, "isRequired": true, "multiSelect": true, "quote": "'", "delimiter": ",", "query": "Resources\r\n| extend Service = tags.Service\r\n| where Service == \"{Service}\" and type == \"microsoft.compute/virtualmachines\"\r\n| project name", "crossComponentResources": [ "{Subscription}" ], "value": [ "value::all" ], "typeSettings": { "additionalResourceOptions": [ "value::all" ] }, "timeContext": { "durationMs": 86400000 }, "defaultValue": "value::all", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources" }, { "id": "cd15a9a9-9248-42bb-8f64-40ad3ed0de0b", "version": "KqlParameterItem/1.0", "name": "Workspace", "label": "Log Analytic Workspace", "type": 5, "isRequired": true, "query": "resources\r\n| where type == 'microsoft.operationalinsights/workspaces'\r\n| project id", "crossComponentResources": [ "{Subscription}" ], "value": "/subscriptions/91b6f239-023c-442d-a060-b12136cb705a/resourceGroups/blt-management/providers/Microsoft.OperationalInsights/workspaces/BLT-Workspace001", "typeSettings": { "additionalResourceOptions": [], "showDefault": false }, "timeContext": { "durationMs": 86400000 }, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources" } ], "style": "above", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources" }, "name": "Subscription" }, { "type": 1, "content": { "json": "# % Processor Time\r\n### Windows and Linux." }, "name": "text - 1" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Perf\r\n| where Computer in ({VirtualMachines})\r\n| where TimeGenerated between (ago({Timeframe:grain}) .. now() )\r\n| where CounterName == \"% Processor Time\"\r\n| summarize avg(CounterValue) by bin(TimeGenerated, 5minutes), Computer\r\n| sort by TimeGenerated desc \r\n| render timechart", "size": 0, "title": "% Processor Time last {Timeframe:grain}", "timeContext": { "durationMs": 86400000 }, "queryType": 0, "resourceType": "microsoft.operationalinsights/workspaces", "crossComponentResources": [ "{Workspace}" ], "visualization": "linechart", "chartSettings": { "ySettings": { "min": 1, "max": 100 } } }, "showPin": true, "name": "query - 2" }, { "type": 1, "content": { "json": "# % Free Space\r\n\r\n### Windows" }, "name": "text - 3" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Perf\r\n| where TimeGenerated between (ago({Timeframe:grain}) .. now() )\r\n| where Computer in ({VirtualMachines})\r\n| where CounterName in (\"% Free Space\") \r\n| summarize avg(CounterValue) by bin(TimeGenerated, 5minutes), Computer\r\n| sort by TimeGenerated desc ", "size": 0, "aggregation": 3, "title": "% Free Space last {Timeframe:grain}", "timeContext": { "durationMs": 86400000 }, "queryType": 0, "resourceType": "microsoft.operationalinsights/workspaces", "crossComponentResources": [ "{Workspace}" ], "visualization": "linechart", "chartSettings": { "ySettings": { "min": 1, "max": 100 } } }, "name": "query - 4" }, { "type": 1, "content": { "json": "# % Used Space\r\n### Linux" }, "name": "text - 5" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Perf\r\n| where TimeGenerated between (ago({Timeframe:grain}) .. now() )\r\n| where Computer in ({VirtualMachines})\r\n| where CounterName in (\"% Used Space\") \r\n| summarize avg(CounterValue) by bin(TimeGenerated, 5minutes), Computer\r\n| sort by TimeGenerated desc ", "size": 0, "title": "% Used Space last {Timeframe:grain}", "timeContext": { "durationMs": 86400000 }, "queryType": 0, "resourceType": "microsoft.operationalinsights/workspaces", "crossComponentResources": [ "{Workspace}" ], "visualization": "linechart", "chartSettings": { "ySettings": { "min": 1, "max": 100 } } }, "name": "query - 6" } ], "fallbackResourceIds": [ "Azure Monitor" ], "$schema": "https://github.com/Microsoft/Application-Insights-Workbooks/blob/master/schema/workbook.json" }