{
  "version": "Notebook/1.0",
  "items": [
    {
      "type": 9,
      "content": {
        "version": "KqlParameterItem/1.0",
        "parameters": [
          {
            "id": "eeb172d0-61e7-4767-a7f4-d24d34252dc2",
            "version": "KqlParameterItem/1.0",
            "name": "Time",
            "type": 4,
            "isRequired": true,
            "isGlobal": true,
            "typeSettings": {
              "selectableValues": [
                {
                  "durationMs": 300000
                },
                {
                  "durationMs": 900000
                },
                {
                  "durationMs": 1800000
                },
                {
                  "durationMs": 3600000
                },
                {
                  "durationMs": 14400000
                },
                {
                  "durationMs": 43200000
                },
                {
                  "durationMs": 86400000
                },
                {
                  "durationMs": 172800000
                },
                {
                  "durationMs": 259200000
                },
                {
                  "durationMs": 604800000
                },
                {
                  "durationMs": 1209600000
                },
                {
                  "durationMs": 2419200000
                },
                {
                  "durationMs": 2592000000
                },
                {
                  "durationMs": 5184000000
                },
                {
                  "durationMs": 7776000000
                }
              ],
              "allowCustom": true
            },
            "timeContext": {
              "durationMs": 86400000
            },
            "value": {
              "durationMs": 86400000
            }
          },
          {
            "id": "c2568f64-dcbb-4665-bd08-75bec20accfc",
            "version": "KqlParameterItem/1.0",
            "name": "Subscription",
            "type": 2,
            "multiSelect": true,
            "quote": "'",
            "delimiter": ",",
            "query": "ApimRequests\r\n| distinct subscription\r\n| sort by subscription asc",
            "typeSettings": {
              "additionalResourceOptions": []
            },
            "timeContext": {
              "durationMs": 0
            },
            "timeContextFromParameter": "Time",
            "queryType": 0,
            "resourceType": "microsoft.insights/components",
            "value": []
          },
          {
            "id": "67538a51-4450-4733-a6ae-529723dd1c6d",
            "version": "KqlParameterItem/1.0",
            "name": "Api",
            "type": 2,
            "multiSelect": true,
            "quote": "'",
            "delimiter": ",",
            "query": "let subscriptionFilter = dynamic([{Subscription}]);\r\n\r\nApimRequests\r\n| where array_length(subscriptionFilter) == 0 or subscription in (subscriptionFilter)\r\n| distinct api\r\n| sort by api asc",
            "typeSettings": {
              "additionalResourceOptions": []
            },
            "timeContext": {
              "durationMs": 0
            },
            "timeContextFromParameter": "Time",
            "queryType": 0,
            "resourceType": "microsoft.insights/components",
            "value": null
          },
          {
            "id": "3068ae8e-e520-4551-b471-8c804ac4de56",
            "version": "KqlParameterItem/1.0",
            "name": "Success",
            "type": 2,
            "typeSettings": {
              "additionalResourceOptions": []
            },
            "jsonData": "[\r\n    { \"value\": \"true\", \"label\": \"yes\"},\r\n    { \"value\": \"false\", \"label\": \"no\"}\r\n]",
            "value": null
          }
        ],
        "style": "pills",
        "queryType": 0,
        "resourceType": "microsoft.insights/components"
      },
      "name": "parameters - 0"
    },
    {
      "type": 3,
      "content": {
        "version": "KqlItem/1.0",
        "query": "let subscriptionFilter = dynamic([{Subscription}]);\r\nlet apiFilter = dynamic([{Api}]);\r\nlet successFilter = '{Success}';\r\n\r\nApimRequests\r\n| where array_length(subscriptionFilter) == 0 or subscription in (subscriptionFilter)\r\n| where array_length(apiFilter) == 0 or api in (apiFilter)\r\n| where isempty(successFilter) or success == tobool(successFilter)\r\n| make-series numberOfRequests=count() default=0 on timestamp from todatetime(\"{Time:startISO}\") to todatetime(\"{Time:endISO}\") step {Time:grain} by success",
        "size": 1,
        "showAnalytics": true,
        "title": "Number of requests",
        "timeContextFromParameter": "Time",
        "timeBrushParameterName": "Time",
        "timeBrushExportOnlyWhenBrushed": true,
        "showRefreshButton": true,
        "showExportToExcel": true,
        "queryType": 0,
        "resourceType": "microsoft.insights/components",
        "visualization": "barchart",
        "chartSettings": {
          "seriesLabelSettings": [
            {
              "seriesName": "True",
              "label": "Success",
              "color": "green"
            },
            {
              "seriesName": "False",
              "label": "Error",
              "color": "redBright"
            }
          ]
        }
      },
      "name": "query - 4"
    },
    {
      "type": 3,
      "content": {
        "version": "KqlItem/1.0",
        "query": "let subscriptionFilter = dynamic([{Subscription}]);\r\nlet apiFilter = dynamic([{Api}]);\r\nlet successFilter = '{Success}';\r\n\r\nApimRequests\r\n| where array_length(subscriptionFilter) == 0 or subscription in (subscriptionFilter)\r\n| where array_length(apiFilter) == 0 or api in (apiFilter)\r\n| where isempty(successFilter) or success == tobool(successFilter)\r\n| project status = iif(success==true, \"success\", \"error\")\r\n    , timestamp\r\n    , subscription\r\n    , api\r\n    , name\r\n    , resultCode\r\n    , duration\r\n    , details = itemId\r\n    , transaction = itemId\r\n    , operation_Id\r\n| order by timestamp desc",
        "size": 1,
        "showAnalytics": true,
        "title": "Requests",
        "timeContextFromParameter": "Time",
        "showRefreshButton": true,
        "exportFieldName": "operation_Id",
        "exportParameterName": "SelectedOperationId",
        "showExportToExcel": true,
        "queryType": 0,
        "resourceType": "microsoft.insights/components",
        "visualization": "table",
        "gridSettings": {
          "formatters": [
            {
              "columnMatch": "status",
              "formatter": 11,
              "formatOptions": {
                "customColumnWidthSetting": "12ch"
              }
            },
            {
              "columnMatch": "timestamp",
              "formatter": 0,
              "formatOptions": {
                "customColumnWidthSetting": "23ch"
              }
            },
            {
              "columnMatch": "subscription",
              "formatter": 0,
              "formatOptions": {
                "customColumnWidthSetting": "16ch"
              }
            },
            {
              "columnMatch": "resultCode",
              "formatter": 0,
              "formatOptions": {
                "customColumnWidthSetting": "11.5ch"
              }
            },
            {
              "columnMatch": "duration",
              "formatter": 4,
              "formatOptions": {
                "palette": "blue"
              },
              "numberFormat": {
                "unit": 23,
                "options": {
                  "style": "decimal"
                }
              }
            },
            {
              "columnMatch": "details",
              "formatter": 7,
              "formatOptions": {
                "linkTarget": "RequestDetails",
                "linkLabel": "details",
                "linkIsContextBlade": true,
                "appInsightsContext": {
                  "resourceIdSource": "workbook",
                  "secondaryIdSource": "default"
                },
                "customColumnWidthSetting": "11ch"
              }
            },
            {
              "columnMatch": "transaction",
              "formatter": 7,
              "formatOptions": {
                "linkTarget": "RequestDetails",
                "linkLabel": "transaction",
                "linkIsContextBlade": false,
                "appInsightsContext": {
                  "resourceIdSource": "workbook",
                  "secondaryIdSource": "default"
                },
                "customColumnWidthSetting": "15ch"
              }
            },
            {
              "columnMatch": "operation_Id",
              "formatter": 5
            }
          ],
          "filter": true,
          "labelSettings": [
            {
              "columnId": "status",
              "label": "Status"
            },
            {
              "columnId": "timestamp",
              "label": "Timestamp"
            },
            {
              "columnId": "subscription",
              "label": "Subscription"
            },
            {
              "columnId": "api",
              "label": "API"
            },
            {
              "columnId": "name",
              "label": "Name"
            },
            {
              "columnId": "resultCode",
              "label": "Result Code"
            },
            {
              "columnId": "duration",
              "label": "Duration"
            },
            {
              "columnId": "details",
              "label": "Details"
            },
            {
              "columnId": "transaction",
              "label": "Transaction"
            }
          ]
        }
      },
      "name": "query - 1"
    },
    {
      "type": 3,
      "content": {
        "version": "KqlItem/1.0",
        "query": "dependencies\r\n| where operation_Id == '{SelectedOperationId}'\r\n| project status = iif(success==true, \"success\", \"error\")\r\n    , timestamp\r\n    , target\r\n    , name\r\n    , type\r\n    , resultCode\r\n    , duration\r\n    , details = itemId\r\n    , transaction = itemId\r\n| order by timestamp desc",
        "size": 1,
        "showAnalytics": true,
        "title": "Dependencies of operation: {SelectedOperationId}",
        "timeContextFromParameter": "Time",
        "showRefreshButton": true,
        "showExportToExcel": true,
        "queryType": 0,
        "resourceType": "microsoft.insights/components",
        "visualization": "table",
        "gridSettings": {
          "formatters": [
            {
              "columnMatch": "status",
              "formatter": 11,
              "formatOptions": {
                "customColumnWidthSetting": "12ch"
              }
            },
            {
              "columnMatch": "timestamp",
              "formatter": 0,
              "formatOptions": {
                "customColumnWidthSetting": "23ch"
              }
            },
            {
              "columnMatch": "resultCode",
              "formatter": 0,
              "formatOptions": {
                "customColumnWidthSetting": "11.5ch"
              }
            },
            {
              "columnMatch": "duration",
              "formatter": 4,
              "formatOptions": {
                "palette": "blue"
              },
              "numberFormat": {
                "unit": 23,
                "options": {
                  "style": "decimal"
                }
              }
            },
            {
              "columnMatch": "details",
              "formatter": 7,
              "formatOptions": {
                "linkTarget": "RequestDetails",
                "linkLabel": "details",
                "linkIsContextBlade": true,
                "appInsightsContext": {
                  "resourceIdSource": "workbook",
                  "secondaryIdSource": "default"
                },
                "customColumnWidthSetting": "11ch"
              }
            },
            {
              "columnMatch": "transaction",
              "formatter": 7,
              "formatOptions": {
                "linkTarget": "RequestDetails",
                "linkLabel": "transaction",
                "appInsightsContext": {
                  "resourceIdSource": "workbook",
                  "secondaryIdSource": "default"
                },
                "customColumnWidthSetting": "15ch"
              }
            }
          ],
          "labelSettings": [
            {
              "columnId": "status",
              "label": "Status"
            },
            {
              "columnId": "timestamp",
              "label": "Timestamp"
            },
            {
              "columnId": "target",
              "label": "Target"
            },
            {
              "columnId": "name",
              "label": "Name"
            },
            {
              "columnId": "type",
              "label": "Type"
            },
            {
              "columnId": "resultCode",
              "label": "Result Code"
            },
            {
              "columnId": "duration",
              "label": "Duration"
            },
            {
              "columnId": "details",
              "label": "Details"
            },
            {
              "columnId": "transaction",
              "label": "Transaction"
            }
          ]
        }
      },
      "conditionalVisibility": {
        "parameterName": "SelectedOperationId",
        "comparison": "isNotEqualTo"
      },
      "name": "query - 3"
    }
  ],
  "fallbackResourceIds": [
    "##applicationInsightsId##"
  ],
  "$schema": "https://github.com/Microsoft/Application-Insights-Workbooks/blob/master/schema/workbook.json"
}