GETNG Ramp Dashboard
Ramp
{
  "__inputs": [
    {
      "name": "DS_GETNG_AZURE MONITOR",
      "label": "GETNG Azure Monitor",
      "description": "",
      "type": "datasource",
      "pluginId": "grafana-azure-monitor-datasource",
      "pluginName": "Azure Monitor"
    }
  ],
  "__requires": [
    {
      "type": "grafana",
      "id": "grafana",
      "name": "Grafana",
      "version": "6.7.2"
    },
    {
      "type": "datasource",
      "id": "grafana-azure-monitor-datasource",
      "name": "Azure Monitor",
      "version": "0.3.0"
    },
    {
      "type": "panel",
      "id": "table",
      "name": "Table",
      "version": ""
    }
  ],
  "annotations": {
    "list": [
      {
        "$$hashKey": "object:2992",
        "builtIn": 1,
        "datasource": "-- Grafana --",
        "enable": true,
        "hide": true,
        "iconColor": "rgba(0, 211, 255, 1)",
        "name": "Annotations & Alerts",
        "type": "dashboard"
      }
    ]
  },
  "editable": true,
  "gnetId": 12191,
  "graphTooltip": 0,
  "id": null,
  "links": [],
  "panels": [
    {
      "columns": [],
      "datasource": "${DS_GETNG_AZURE MONITOR}",
      "fontSize": "80%",
      "gridPos": {
        "h": 8,
        "w": 18,
        "x": 0,
        "y": 0
      },
      "id": 2,
      "pageSize": null,
      "showHeader": true,
      "sort": {
        "col": 0,
        "desc": true
      },
      "styles": [
        {
          "$$hashKey": "object:3098",
          "alias": "Time",
          "align": "auto",
          "dateFormat": "YYYY-MM-DD HH:mm:ss",
          "pattern": "Time",
          "type": "date"
        },
        {
          "$$hashKey": "object:3099",
          "alias": "",
          "align": "right",
          "colorMode": null,
          "colors": [
            "rgba(245, 54, 54, 0.9)",
            "rgba(237, 129, 40, 0.89)",
            "rgba(50, 172, 45, 0.97)"
          ],
          "decimals": 2,
          "pattern": "/.*/",
          "thresholds": [],
          "type": "number",
          "unit": "short"
        }
      ],
      "targets": [
        {
          "appInsights": {
            "dimension": "none",
            "metricName": "select",
            "rawQuery": false,
            "rawQueryString": "",
            "timeColumn": "timestamp",
            "timeGrain": "auto",
            "valueColumn": ""
          },
          "azureLogAnalytics": {
            "query": "//  GETNG Ramp Dashboard - Ramp requests received\r\nContainerLog\r\n| where LogEntry contains \"sendRampMsg\" and LogEntry contains \"RampMsgController\"\r\n| parse LogEntry with * \"RampMsgController\" * \"- \" TransactionId \" sendRampMsg\" * \":\" rawjson\r\n| extend transactionJson=parse_json(rawjson)\r\n| extend Station = tostring(transactionJson.station), Response = tostring(transactionJson.response), RampRequest = tostring(transactionJson.rampMsg), RampTime = tostring(transactionJson.startTimeInGMT), YellowStatus = tostring(transactionJson.yellowRampMsg), YellowStartTime = tostring(transactionJson.yellowStartTimeInLocal), YellowEndTime = tostring(transactionJson.yellowEndTimeInLocal)\r\n| where isnotempty(Station)\r\n| project TransactionId , Station , RampRequest , Response, RampTime , YellowStatus , YellowStartTime  , YellowEndTime \r\n| summarize Station=makeset(Station), RampRequest = makeset(RampRequest), Response=makeset(Response), RampTime=makeset(RampTime), YellowStatus = makeset(YellowStatus), YellowStartTime = makeset(YellowStartTime), YellowEndTime = makeset(YellowEndTime) by TransactionId\r\n",
            "resultFormat": "table",
            "workspace": "13c933e4-b797-43ee-9390-5b2ce4e3be89"
          },
          "azureMonitor": {
            "aggOptions": [],
            "dimensionFilter": "*",
            "metricDefinition": "select",
            "metricName": "select",
            "metricNamespace": "select",
            "resourceGroup": "select",
            "resourceName": "select",
            "timeGrain": "auto",
            "timeGrains": [],
            "top": "10"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "0bc507f3-ad14-4edd-8f76-a91458390da2"
        }
      ],
      "timeFrom": null,
      "timeShift": null,
      "title": "Ramp Requests Received",
      "transform": "table",
      "type": "table"
    },
    {
      "columns": [],
      "datasource": "${DS_GETNG_AZURE MONITOR}",
      "fontSize": "80%",
      "gridPos": {
        "h": 8,
        "w": 18,
        "x": 0,
        "y": 8
      },
      "id": 4,
      "pageSize": null,
      "showHeader": true,
      "sort": {
        "col": 0,
        "desc": true
      },
      "styles": [
        {
          "$$hashKey": "object:3969",
          "alias": "Time",
          "align": "auto",
          "dateFormat": "YYYY-MM-DD HH:mm:ss",
          "pattern": "Time",
          "type": "date"
        },
        {
          "$$hashKey": "object:3970",
          "alias": "",
          "align": "right",
          "colorMode": null,
          "colors": [
            "rgba(245, 54, 54, 0.9)",
            "rgba(237, 129, 40, 0.89)",
            "rgba(50, 172, 45, 0.97)"
          ],
          "decimals": 2,
          "pattern": "/.*/",
          "thresholds": [],
          "type": "number",
          "unit": "short"
        }
      ],
      "targets": [
        {
          "appInsights": {
            "dimension": "none",
            "metricName": "select",
            "rawQuery": false,
            "rawQueryString": "",
            "timeColumn": "timestamp",
            "timeGrain": "auto",
            "valueColumn": ""
          },
          "azureLogAnalytics": {
            "query": "ContainerLog\r\n| where LogEntry contains \"Request to printer ::::\" \r\n| parse LogEntry with * \"Request to printer ::::\" rawJson\r\n| extend RequestJson = parse_json(rawJson)\r\n| extend Request = tostring(RequestJson.request.data), Address = tostring(RequestJson.request.address)\r\n| project TimeOfCommand, Request , Address \r\n| join (\r\n    ContainerLog\r\n    | where LogEntry contains \"Printer response ::::\" \r\n    | parse LogEntry with * \"Printer response ::::\" Response\r\n    | project TimeOfCommand , Response \r\n) on TimeOfCommand \r\n| project _time=TimeOfCommand, Request , Address , Response\r\n| order by _time",
            "resultFormat": "table",
            "workspace": "13c933e4-b797-43ee-9390-5b2ce4e3be89"
          },
          "azureMonitor": {
            "aggOptions": [],
            "dimensionFilter": "*",
            "metricDefinition": "select",
            "metricName": "select",
            "metricNamespace": "select",
            "resourceGroup": "select",
            "resourceName": "select",
            "timeGrain": "auto",
            "timeGrains": [],
            "top": "10"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "0bc507f3-ad14-4edd-8f76-a91458390da2"
        }
      ],
      "timeFrom": null,
      "timeShift": null,
      "title": "Ramp Messages Sent to Printer",
      "transform": "table",
      "type": "table"
    },
    {
      "columns": [],
      "datasource": "${DS_GETNG_AZURE MONITOR}",
      "fontSize": "80%",
      "gridPos": {
        "h": 8,
        "w": 18,
        "x": 0,
        "y": 16
      },
      "id": 6,
      "pageSize": null,
      "showHeader": true,
      "sort": {
        "col": 0,
        "desc": true
      },
      "styles": [
        {
          "$$hashKey": "object:4251",
          "alias": "Time",
          "align": "auto",
          "dateFormat": "YYYY-MM-DD HH:mm:ss",
          "pattern": "Time",
          "type": "date"
        },
        {
          "$$hashKey": "object:4252",
          "alias": "",
          "align": "right",
          "colorMode": null,
          "colors": [
            "rgba(245, 54, 54, 0.9)",
            "rgba(237, 129, 40, 0.89)",
            "rgba(50, 172, 45, 0.97)"
          ],
          "decimals": 2,
          "pattern": "/.*/",
          "thresholds": [],
          "type": "number",
          "unit": "short"
        }
      ],
      "targets": [
        {
          "appInsights": {
            "dimension": "none",
            "metricName": "select",
            "rawQuery": false,
            "rawQueryString": "",
            "timeColumn": "timestamp",
            "timeGrain": "auto",
            "valueColumn": ""
          },
          "azureLogAnalytics": {
            "query": "ContainerLog\r\n| where LogEntry contains \"Ramp message pushed to FHUB queue\"\r\n| project TimeOfCommand \r\n| join (\r\n    ContainerLog\r\n    | where LogEntry contains \"RampMsgServiceImpl:104\"\r\n    | parse LogEntry with * \"save u0026 push \" rawJson\r\n    | extend messageJson = parse_json(rawJson)\r\n    | project TimeOfCommand, rampMsg = tostring(messageJson.rampMsg), sourceTime = tostring(messageJson.createdAt), staOffset = toreal(messageJson.staOffset),   startTime = todatetime(messageJson.startTime), station = tostring(messageJson.station)\r\n) on TimeOfCommand\r\n| project _time = TimeOfCommand, rampMsg , sourceTime , staOffset , startTime , station \r\n| sort by _time asc",
            "resultFormat": "table",
            "workspace": "13c933e4-b797-43ee-9390-5b2ce4e3be89"
          },
          "azureMonitor": {
            "aggOptions": [],
            "dimensionFilter": "*",
            "metricDefinition": "select",
            "metricName": "select",
            "metricNamespace": "select",
            "resourceGroup": "select",
            "resourceName": "select",
            "timeGrain": "auto",
            "timeGrains": [],
            "top": "10"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "0bc507f3-ad14-4edd-8f76-a91458390da2"
        }
      ],
      "timeFrom": null,
      "timeShift": null,
      "title": "Ramp Messages Sent to FlightHub Queue",
      "transform": "table",
      "type": "table"
    }
  ],
  "schemaVersion": 22,
  "style": "dark",
  "tags": [],
  "templating": {
    "list": []
  },
  "time": {
    "from": "now-6h",
    "to": "now"
  },
  "timepicker": {},
  "timezone": "",
  "title": "GETNG Ramp Dashboard",
  "uid": "MRaUy0jZk",
  "variables": {
    "list": []
  },
  "version": 5,
  "description": "Ramp"
}