arm-based-workbook-template.json

{
  "version": "Notebook/1.0",
  "items": [
    {
      "type": 1,
      "content": {
        "json": "# Dashboard for checking DCR and DCE which attaches to VM\r\n\r\nClick the VM which you want to check DCR and DCE in the following table\r\n"
      },
      "name": "title"
    },
    {
      "type": 3,
      "content": {
        "version": "KqlItem/1.0",
        "query": "resources\r\n| where type == \"microsoft.hybridcompute/machines\" or type == \"microsoft.compute/virtualmachines\"\r\n| project id, name ,resourceGroup, location\r\n| sort by name asc",
        "size": 1,
        "exportFieldName": "id",
        "exportParameterName": "id",
        "queryType": 1,
        "resourceType": "microsoft.resourcegraph/resources",
        "crossComponentResources": [
          "value::all"
        ]
      },
      "name": "VM list",
      "styleSettings": {
        "margin": "0px 0px 50px 0px"
      }
    },
    {
      "type": 12,
      "content": {
        "version": "NotebookGroup/1.0",
        "groupType": "editable",
        "items": [
          {
            "type": 3,
            "content": {
              "version": "KqlItem/1.0",
              "query": "{\"version\":\"ARMEndpoint/1.0\",\"data\":null,\"headers\":[],\"method\":\"GET\",\"path\":\"{id}/providers/Microsoft.Insights/dataCollectionRuleAssociations?api-version=2021-09-01-preview\",\"urlParams\":[],\"batchDisabled\":false,\"transformers\":[{\"type\":\"jsonpath\",\"settings\":{\"tablePath\":\"$.value[*].properties.dataCollectionRuleId\",\"columns\":[]}}]}",
              "size": 4,
              "title": "Data Collection Endpoint",
              "noDataMessage": "There are no DCR attaches to this VM",
              "queryType": 12,
              "sortBy": []
            },
            "customWidth": "50",
            "name": "dcr"
          },
          {
            "type": 3,
            "content": {
              "version": "KqlItem/1.0",
              "query": "{\"version\":\"ARMEndpoint/1.0\",\"data\":null,\"headers\":[],\"method\":\"GET\",\"path\":\"{id}/providers/Microsoft.Insights/dataCollectionRuleAssociations?api-version=2021-09-01-preview\",\"urlParams\":[],\"batchDisabled\":false,\"transformers\":[{\"type\":\"jsonpath\",\"settings\":{\"tablePath\":\"$.value[*].properties.dataCollectionEndpointId\",\"columns\":[]}}]}",
              "size": 4,
              "title": "Data Collection Endpoint",
              "noDataMessage": "There are no DCE attaches to this VM",
              "queryType": 12,
              "sortBy": []
            },
            "customWidth": "50",
            "name": "dce",
            "styleSettings": {
              "maxWidth": "50"
            }
          }
        ]
      },
      "name": "result"
    }
  ],
  "fallbackResourceIds": [
    "azure monitor"
  ],
  "$schema": "https://github.com/Microsoft/Application-Insights-Workbooks/blob/master/schema/workbook.json"
}