"variables": { "workbookContent": { "version": "Notebook/1.0", "items": [ { "type": 9, "content": { "version": "KqlParameterItem/1.0", "parameters": [ { "version": "KqlParameterItem/1.0", "name": "SelectedCloudRole", "type": 1, "isRequired": true, "value": "[parameters('roleName')]", "isHiddenWhenLocked": true } ] } }, { "type": 9, "content": { "version": "KqlParameterItem/1.0", "parameters": [ { "version": "KqlParameterItem/1.0", "name": "Apps", "type": 5, "isRequired": true, "multiSelect": true, "quote": "'", "delimiter": ",", "typeSettings": { "resourceTypeFilter": { "microsoft.insights/components": true }, "additionalResourceOptions": [ "value::all", "value::3" ] }, "value": [ "value::3" ] }, { "version": "KqlParameterItem/1.0", "name": "TimeRange", "type": 4, "typeSettings": { "selectableValues": [ { "durationMs": 300000, "createdTime": "2018-08-06T23:52:38.870Z", "isInitialTime": false, "grain": 1, "useDashboardTimeRange": false }, { "durationMs": 900000, "createdTime": "2018-08-06T23:52:38.871Z", "isInitialTime": false, "grain": 1, "useDashboardTimeRange": false }, { "durationMs": 1800000, "createdTime": "2018-08-06T23:52:38.871Z", "isInitialTime": false, "grain": 1, "useDashboardTimeRange": false }, { "durationMs": 3600000, "createdTime": "2018-08-06T23:52:38.871Z", "isInitialTime": false, "grain": 1, "useDashboardTimeRange": false }, { "durationMs": 14400000, "createdTime": "2018-08-06T23:52:38.871Z", "isInitialTime": false, "grain": 1, "useDashboardTimeRange": false }, { "durationMs": 43200000, "createdTime": "2018-08-06T23:52:38.871Z", "isInitialTime": false, "grain": 1, "useDashboardTimeRange": false }, { "durationMs": 86400000, "createdTime": "2018-08-06T23:52:38.871Z", "isInitialTime": false, "grain": 1, "useDashboardTimeRange": false }, { "durationMs": 172800000, "createdTime": "2018-08-06T23:52:38.871Z", "isInitialTime": false, "grain": 1, "useDashboardTimeRange": false }, { "durationMs": 259200000, "createdTime": "2018-08-06T23:52:38.871Z", "isInitialTime": false, "grain": 1, "useDashboardTimeRange": false }, { "durationMs": 604800000, "createdTime": "2018-08-06T23:52:38.871Z", "isInitialTime": false, "grain": 1, "useDashboardTimeRange": false } ], "allowCustom": null }, "value": { "durationMs": 14400000 } }, { "version": "KqlParameterItem/1.0", "name": "Operation", "type": 1, "isHiddenWhenLocked": true, "value": "{\"App\":\"\",\"Operation\":\"\"}" }, { "version": "KqlParameterItem/1.0", "name": "Columns", "type": 2, "isRequired": true, "multiSelect": true, "quote": "", "delimiter": ",", "jsonData": "[[\"Mean\", \"Median\", \"p80\", \"p95\", \"p99\", \"Count\", \"Users\"]", "value": [ "Mean", "Median", "p95", "Count" ] }, { "version": "KqlParameterItem/1.0", "name": "In", "type": 2, "multiSelect": true, "quote": "'", "delimiter": ",", "query": "let selectedCloud_RoleName = \"{SelectedCloudRole}\";requests\r\n| where timestamp >= ago(7d)\r\n| where cloud_RoleName == selectedCloud_RoleName\r\n| summarize Count = count() by operation_Name\r\n| order by Count desc\r\n| project v = operation_Name, t = operation_Name, s = false\r\n| union (datatable(v:string, t:string, s:boolean)[\r\n'*', 'All Operations', true\r\n])", "typeSettings": { "additionalResourceOptions": [] }, "queryType": 0, "resourceType": "microsoft.insights/components" } ], "style": "pills", "queryType": 0, "resourceType": "microsoft.insights/components" }, "name": "parameters - 1" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "let selectedCloud_RoleName = \"{SelectedCloudRole}\";\nlet data = requests\n| where timestamp {TimeRange}\n| where cloud_RoleName == selectedCloud_RoleName\n| where operation_Name in ({In}) or '*' in ({In}) ;\ndata\n| summarize Mean = avg(duration), (Median, p80, p95, p99) = percentiles(duration, 50, 80, 95, 99), Count = count(), Users = dcount(user_Id) by name, appName\n| project App = appName, Operation = name, Mean, Median, p80, p95, p99, Count, Users, rank = 2\n| union (data\n | summarize Mean = avg(duration), (Median, p80, p95, p99) = percentiles(duration, 50, 80, 95, 99), Count = count(), Users = dcount(user_Id)\n | project App = '🔸 All Apps', Operation = '🔸 All operations', Mean, Median, p80, p95, p99, Count, Users, rank = 1)\n| extend Relevance = Mean * Count\n| order by rank asc, Relevance desc\n| project-away Relevance, rank\n| extend Mean = round(Mean, 2), Median = round(Median, 1), p80 = round(p80, 2), p95 = round(p95, 2), p99 = round(p99, 2)\n| project App, Operation, {Columns}\n", "size": 0, "title": "Request Details", "exportParameterName": "Operation", "queryType": 0, "resourceType": "microsoft.insights/components", "crossComponentResources": [ "{Apps}" ], "gridSettings": { "formatters": [ { "columnMatch": "Mean|Median|p80|p95|p99", "formatter": 8, "formatOptions": { "min": 0, "max": null, "palette": "red" } }, { "columnMatch": "Count", "formatter": 8, "formatOptions": { "min": 0, "max": null, "palette": "blue" } }, { "columnMatch": "Users", "formatter": 8, "formatOptions": { "min": 0, "max": null, "palette": "blueDark" } } ] } }, "name": "query - 2" } ] } }