Categories:

WLAN-Dashboard mit Grafana und Cisco WLC

Veröffentlicht von empy
Lesezeit: 17 Minuten

Ich habe mir ein WLAN-Dashboard gebaut. Fokus liegt diesmal nicht auf der Intrusion Detection und Alarmierung per eMail, vielmehr möchte ich mir den generellen Zustand meines WLANs in einer Art Cockpit anzeigen lassen.

Dazu verwende ich Grafana. Installiert einfach Debian (bei mir Version 12 in einer VM) Dann folgt ihr dieser Einleitung für die Installation von Grafana, influxdb und Telegraf.

Konfiguration des Grafana-Dashboards

Wenn ihr Grafana installiert habt, könnt ihr meine Konfiguration für das Dashboard nutzen. Das Dashboard zeigt euch folgende Parameter pro Client an:

  • Signalqualität
  • Transmission Infos
  • Datenrate
  • Clientverlauf online / offline
  • WLAN-Kanal
  • AP-Mobility-History
  • Aktuelle Datenrate, RSSI, SNR
  • Spatial Streams
  • Protected Management Frames
  • Verbundene SSID sowie verwendete Policy

Darunter findet ihr den gesamten WLAN-Status mit folgenden Informationen:

  • Kanalauslastung pro AP
  • Gesamtauslastung WLAN-Interfaces über alle APs konsolidiert
  • Anzahl Endgeräte pro SSID
  • WLAN-Angriffsvektoren
  • AP online / offline
{
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": {
          "type": "grafana",
          "uid": "-- Grafana --"
        },
        "enable": true,
        "hide": true,
        "iconColor": "rgba(0, 211, 255, 1)",
        "name": "Annotations & Alerts",
        "type": "dashboard"
      }
    ]
  },
  "description": "test",
  "editable": true,
  "fiscalYearStartMonth": 0,
  "graphTooltip": 2,
  "id": 1,
  "links": [],
  "liveNow": false,
  "panels": [
    {
      "collapsed": false,
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 0
      },
      "id": 4,
      "panels": [],
      "title": "Client Details",
      "type": "row"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisBorderShow": false,
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 10,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "insertNulls": false,
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "RSSI"
            },
            "properties": [
              {
                "id": "unit",
                "value": "dBm"
              },
              {
                "id": "custom.axisLabel",
                "value": "RSSI"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "SNR"
            },
            "properties": [
              {
                "id": "unit",
                "value": "dB"
              },
              {
                "id": "custom.axisLabel",
                "value": "SNR"
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 6,
        "x": 0,
        "y": 1
      },
      "id": 5,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "targets": [
        {
          "alias": "RSSI",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/traffic-stats",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "most_recent_rssi"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "distinct"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        },
        {
          "alias": "SNR",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/traffic-stats",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "most_recent_snr"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "distinct"
              },
              {
                "params": [
                  10
                ],
                "type": "moving_average"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "Signal Quality",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "description": "WLAN-Controller resets bytes counted after 30 minutes. Thus values are rolling cumulative during that period.",
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisBorderShow": false,
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 10,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "insertNulls": false,
            "lineInterpolation": "smooth",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "bytes"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "Retries"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "dark-red",
                  "mode": "shades"
                }
              },
              {
                "id": "custom.scaleDistribution",
                "value": {
                  "linearThreshold": 100000,
                  "type": "linear"
                }
              },
              {
                "id": "unit",
                "value": "none"
              },
              {
                "id": "custom.axisPlacement",
                "value": "hidden"
              },
              {
                "id": "custom.stacking",
                "value": {
                  "group": "B",
                  "mode": "normal"
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 6,
        "x": 6,
        "y": 1
      },
      "id": 10,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "targets": [
        {
          "alias": "Received Bytes (Rx)",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/traffic-stats",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "bytes_rx"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              },
              {
                "params": [
                  "2"
                ],
                "type": "moving_average"
              },
              {
                "params": [
                  "* -1"
                ],
                "type": "math"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        },
        {
          "alias": "Transmitted Bytes (Tx)",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/traffic-stats",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "bytes_tx"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              },
              {
                "params": [
                  "2"
                ],
                "type": "moving_average"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        },
        {
          "alias": "Retries",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/traffic-stats",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "C",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "data_retries"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "distinct"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "Transmission Information",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisBorderShow": false,
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 10,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "insertNulls": false,
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "fieldMinMax": false,
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 8,
        "w": 6,
        "x": 12,
        "y": 1
      },
      "id": 8,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "10.2.2",
      "targets": [
        {
          "alias": "Data Rate",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [],
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/traffic-stats",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "speed"
                ],
                "type": "field"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "Data Rate",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "continuous-GrYlRd"
          },
          "custom": {
            "fillOpacity": 70,
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "insertNulls": false,
            "lineWidth": 0,
            "spanNulls": false
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": " "
            },
            "properties": [
              {
                "id": "mappings",
                "value": [
                  {
                    "options": {
                      "client-status-authenticating": {
                        "color": "orange",
                        "index": 2
                      },
                      "client-status-idle": {
                        "color": "orange",
                        "index": 0
                      },
                      "client-status-ip-learning": {
                        "color": "red",
                        "index": 1
                      }
                    },
                    "type": "value"
                  }
                ]
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 6,
        "x": 18,
        "y": 1
      },
      "id": 7,
      "options": {
        "alignValue": "left",
        "legend": {
          "displayMode": "table",
          "placement": "bottom",
          "showLegend": false
        },
        "mergeValues": true,
        "rowHeight": 0.9,
        "showValue": "auto",
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "10.2.2",
      "targets": [
        {
          "alias": " ",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [],
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/common-oper-data",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "co_state"
                ],
                "type": "field"
              }
            ]
          ],
          "tags": [
            {
              "key": "client_mac::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "Connection Status",
      "type": "state-timeline"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "none"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 6,
        "w": 2,
        "x": 0,
        "y": 9
      },
      "id": 19,
      "options": {
        "colorMode": "value",
        "graphMode": "none",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto",
        "wideLayout": true
      },
      "pluginVersion": "10.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/dot11-oper-data",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "current_channel"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "Current Channel",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "gridPos": {
        "h": 6,
        "w": 2,
        "x": 2,
        "y": 9
      },
      "id": 18,
      "options": {
        "dedupStrategy": "numbers",
        "enableLogDetails": false,
        "prettifyLogMessage": false,
        "showCommonLabels": false,
        "showLabels": false,
        "showTime": false,
        "sortOrder": "Descending",
        "wrapLogMessage": false
      },
      "pluginVersion": "10.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [],
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/common-oper-data",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "ap_name"
                ],
                "type": "field"
              }
            ]
          ],
          "tags": [
            {
              "key": "client_mac::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "Current AP",
      "type": "logs"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              }
            ]
          },
          "unit": "Mbits"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 6,
        "w": 2,
        "x": 4,
        "y": 9
      },
      "id": 13,
      "options": {
        "colorMode": "value",
        "graphMode": "none",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto",
        "wideLayout": true
      },
      "pluginVersion": "10.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/traffic-stats",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "speed"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "Data Rate",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "dBm"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 3,
        "w": 2,
        "x": 6,
        "y": 9
      },
      "id": 16,
      "options": {
        "colorMode": "value",
        "graphMode": "none",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto",
        "wideLayout": true
      },
      "pluginVersion": "10.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/traffic-stats",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "most_recent_rssi"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "RSSI",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "none"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 3,
        "w": 2,
        "x": 8,
        "y": 9
      },
      "id": 14,
      "options": {
        "colorMode": "value",
        "graphMode": "none",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto",
        "wideLayout": true
      },
      "pluginVersion": "10.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/traffic-stats",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "spatial_stream"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "Spatial Streams",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "custom": {
            "align": "auto",
            "cellOptions": {
              "type": "auto"
            },
            "filterable": true,
            "inspect": false
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "Time"
            },
            "properties": [
              {
                "id": "custom.hidden",
                "value": true
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 3,
        "w": 4,
        "x": 10,
        "y": 9
      },
      "id": 24,
      "options": {
        "cellHeight": "sm",
        "footer": {
          "countRows": false,
          "fields": "",
          "reducer": [
            "sum"
          ],
          "show": false
        },
        "showHeader": false
      },
      "pluginVersion": "10.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [],
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/dot11-oper-data",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "table",
          "select": [
            [
              {
                "params": [
                  "vap_ssid"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ],
            [
              {
                "params": [
                  "policy_profile"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "SSID",
      "transformations": [],
      "type": "table"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "dB"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 3,
        "w": 2,
        "x": 6,
        "y": 12
      },
      "id": 12,
      "options": {
        "colorMode": "value",
        "graphMode": "none",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto",
        "wideLayout": true
      },
      "pluginVersion": "10.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/traffic-stats",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "most_recent_snr"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "SNR",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "custom": {
            "align": "auto",
            "cellOptions": {
              "type": "auto"
            },
            "filterable": true,
            "inspect": false
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "Time"
            },
            "properties": [
              {
                "id": "custom.hidden",
                "value": true
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 3,
        "w": 2,
        "x": 8,
        "y": 12
      },
      "id": 20,
      "options": {
        "cellHeight": "lg",
        "footer": {
          "countRows": false,
          "fields": "",
          "reducer": [
            "sum"
          ],
          "show": false
        },
        "showHeader": false
      },
      "pluginVersion": "10.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [],
          "measurement": "Cisco-IOS-XE-wireless-client-oper:client-oper-data/dot11-oper-data",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "table",
          "select": [
            [
              {
                "params": [
                  "dot11w_enabled"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "ms_mac_address::tag",
              "operator": "=~",
              "value": "/^$Client$/"
            }
          ]
        }
      ],
      "title": "PMF 802.11w",
      "transformations": [],
      "type": "table"
    },
    {
      "collapsed": false,
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 15
      },
      "id": 3,
      "panels": [],
      "title": "Access Point Summary",
      "type": "row"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisBorderShow": false,
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 10,
            "gradientMode": "opacity",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "insertNulls": false,
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": true,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "dashed"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "orange",
                "value": 60
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 9,
        "w": 8,
        "x": 0,
        "y": 16
      },
      "id": 2,
      "options": {
        "legend": {
          "calcs": [
            "min",
            "max",
            "mean"
          ],
          "displayMode": "table",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "alias": "AP1_EG",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Cisco-IOS-XE-wireless-rrm-oper:rrm-oper-data/rrm-measurement",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "load/cca_util_percentage"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "wtp_mac::tag",
              "operator": "=",
              "value": "xx:xx:xx:xx:xx:xx"
            },
            {
              "condition": "AND",
              "key": "radio_slot_id::tag",
              "operator": "=",
              "value": "0"
            }
          ]
        },
        {
          "alias": "AP2_OG",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Cisco-IOS-XE-wireless-rrm-oper:rrm-oper-data/rrm-measurement",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "load/cca_util_percentage"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "wtp_mac::tag",
              "operator": "=",
              "value": "yy:yy:yy:yy:yy:yy"
            },
            {
              "condition": "AND",
              "key": "radio_slot_id::tag",
              "operator": "=",
              "value": "0"
            }
          ]
        },
        {
          "alias": "AP3_UG",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Cisco-IOS-XE-wireless-rrm-oper:rrm-oper-data/rrm-measurement",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "C",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "load/cca_util_percentage"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "wtp_mac::tag",
              "operator": "=",
              "value": "zz:zz:zz:zz:zz:zz"
            },
            {
              "condition": "AND",
              "key": "radio_slot_id::tag",
              "operator": "=",
              "value": "0"
            }
          ]
        }
      ],
      "title": "2,4 GHz Channel Utilization %",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "description": "30sec average on interface of the WLC. All WLANs centrally switched.\nint g1\nload-interval 30\n",
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisBorderShow": false,
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 10,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "insertNulls": false,
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": true,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "KBs"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 9,
        "w": 5,
        "x": 8,
        "y": 16
      },
      "id": 22,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "targets": [
        {
          "alias": "Rx",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Cisco-IOS-XE-interfaces-oper:interfaces/interface/statistics",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "rx_kbps"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "name::tag",
              "operator": "=",
              "value": "GigabitEthernet1"
            }
          ]
        },
        {
          "alias": "Tx",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Cisco-IOS-XE-interfaces-oper:interfaces/interface/statistics",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "tx_kbps"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "name::tag",
              "operator": "=",
              "value": "GigabitEthernet1"
            }
          ]
        }
      ],
      "title": "Total Wireless Throughput",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisBorderShow": false,
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "axisSoftMin": 0,
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 10,
            "gradientMode": "opacity",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "insertNulls": false,
            "lineInterpolation": "linear",
            "lineStyle": {
              "fill": "solid"
            },
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": true,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "fieldMinMax": false,
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "none"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 9,
        "w": 4,
        "x": 13,
        "y": 16
      },
      "id": 1,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "targets": [
        {
          "alias": "WLAN1 (private)",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Cisco-IOS-XE-wireless-mobility-oper:mobility-oper-data/wlan-client-limit",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "curr_clients_count"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "wlan_profile::tag",
              "operator": "=",
              "value": "WLAN 1"
            }
          ]
        },
        {
          "alias": "WLAN 2 (guest)",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Cisco-IOS-XE-wireless-mobility-oper:mobility-oper-data/wlan-client-limit",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "curr_clients_count"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "wlan_profile::tag",
              "operator": "=",
              "value": "WLAN 2"
            }
          ]
        },
        {
          "alias": "WLAN 3 (voice)",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Cisco-IOS-XE-wireless-mobility-oper:mobility-oper-data/wlan-client-limit",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "C",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "curr_clients_count"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "wlan_profile::tag",
              "operator": "=",
              "value": "WLAN 3"
            }
          ]
        }
      ],
      "title": "# Clients pro SSID",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "gridPos": {
        "h": 9,
        "w": 3,
        "x": 17,
        "y": 16
      },
      "id": 23,
      "options": {
        "dedupStrategy": "numbers",
        "enableLogDetails": false,
        "prettifyLogMessage": false,
        "showCommonLabels": false,
        "showLabels": false,
        "showTime": false,
        "sortOrder": "Descending",
        "wrapLogMessage": false
      },
      "pluginVersion": "10.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "alarm_string::field"
              ],
              "type": "tag"
            }
          ],
          "measurement": "Cisco-IOS-XE-wireless-awips-oper:awips-oper-data/awips-alarm",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "alarm_string"
                ],
                "type": "field"
              }
            ]
          ],
          "tags": []
        }
      ],
      "title": "Wireless Attacks (aWIPS)",
      "type": "logs"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "continuous-GrYlRd"
          },
          "custom": {
            "fillOpacity": 70,
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "insertNulls": false,
            "lineWidth": 0,
            "spanNulls": false
          },
          "mappings": [
            {
              "options": {
                "adminstate-disabled": {
                  "color": "red",
                  "index": 0
                }
              },
              "type": "value"
            }
          ],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 9,
        "w": 4,
        "x": 20,
        "y": 16
      },
      "id": 6,
      "options": {
        "alignValue": "left",
        "legend": {
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "mergeValues": true,
        "rowHeight": 0.9,
        "showValue": "auto",
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "alias": "AP1_EG",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Cisco-IOS-XE-wireless-access-point-oper:access-point-oper-data/capwap-data",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "a",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "ap_state/ap_admin_state"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "wtp_mac::tag",
              "operator": "=",
              "value": "xx:xx:xx:xx:xx:xx"
            }
          ]
        },
        {
          "alias": "AP2_OG",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Cisco-IOS-XE-wireless-access-point-oper:access-point-oper-data/capwap-data",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "b",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "ap_state/ap_admin_state"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "wtp_mac::tag",
              "operator": "=",
              "value": "yy:yy:yy:yy:yy:yy"
            }
          ]
        },
        {
          "alias": "AP3_UG",
          "datasource": {
            "type": "influxdb",
            "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Cisco-IOS-XE-wireless-access-point-oper:access-point-oper-data/capwap-data",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "c",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "ap_state/ap_admin_state"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "wtp_mac::tag",
              "operator": "=",
              "value": "zz:zz:zz:zz:zz:zz"
            }
          ]
        }
      ],
      "title": "AP Admin status",
      "type": "state-timeline"
    }
  ],
  "refresh": "5s",
  "schemaVersion": 38,
  "tags": [],
  "templating": {
    "list": [
      {
        "current": {
          "selected": false,
          "text": "aa:bb:cc:dd:ee:ff",
          "value": "aa:bb:cc:dd:ee:ff"
        },
        "datasource": {
          "type": "influxdb",
          "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
        },
        "definition": "SHOW TAG VALUES WITH KEY = \"ms_mac_address\"",
        "hide": 0,
        "includeAll": false,
        "multi": false,
        "name": "Client",
        "options": [],
        "query": "SHOW TAG VALUES WITH KEY = \"ms_mac_address\"",
        "refresh": 1,
        "regex": "",
        "skipUrlSync": false,
        "sort": 0,
        "type": "query"
      },
      {
        "current": {
          "selected": false,
          "text": "192.168.1.4",
          "value": "192.168.1.4"
        },
        "datasource": {
          "type": "influxdb",
          "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
        },
        "definition": "SELECT distinct(\"ipv4_binding/ip_key/ip_addr\") FROM \"Cisco-IOS-XE-wireless-client-oper:client-oper-data/sisf-db-mac\" WHERE (\"mac_addr\" =~ /^$Client$/)",
        "hide": 0,
        "includeAll": false,
        "multi": false,
        "name": "Client_IP",
        "options": [],
        "query": "SELECT distinct(\"ipv4_binding/ip_key/ip_addr\") FROM \"Cisco-IOS-XE-wireless-client-oper:client-oper-data/sisf-db-mac\" WHERE (\"mac_addr\" =~ /^$Client$/)",
        "refresh": 1,
        "regex": "",
        "skipUrlSync": false,
        "sort": 0,
        "type": "query"
      },
      {
        "current": {
          "isNone": true,
          "selected": false,
          "text": "None",
          "value": ""
        },
        "datasource": {
          "type": "influxdb",
          "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
        },
        "definition": "SELECT distinct(\"username\") FROM \"Cisco-IOS-XE-wireless-client-oper:client-oper-data/common-oper-data\" WHERE (\"client_mac\" =~ /^$Client$/)",
        "hide": 0,
        "includeAll": false,
        "multi": false,
        "name": "User",
        "options": [],
        "query": "SELECT distinct(\"username\") FROM \"Cisco-IOS-XE-wireless-client-oper:client-oper-data/common-oper-data\" WHERE (\"client_mac\" =~ /^$Client$/)",
        "refresh": 1,
        "regex": "",
        "skipUrlSync": false,
        "sort": 0,
        "type": "query"
      },
      {
        "current": {
          "selected": false,
          "text": "Client1",
          "value": "Client1"
        },
        "datasource": {
          "type": "influxdb",
          "uid": "ee83eb46-c7f2-4fdf-ac82-54c9764be187"
        },
        "definition": "SELECT distinct(\"device_name\") FROM \"Cisco-IOS-XE-wireless-client-oper:client-oper-data/dc-info\" WHERE (\"client_mac\" =~ /^$Client$/)",
        "hide": 0,
        "includeAll": false,
        "multi": false,
        "name": "Model",
        "options": [],
        "query": "SELECT distinct(\"device_name\") FROM \"Cisco-IOS-XE-wireless-client-oper:client-oper-data/dc-info\" WHERE (\"client_mac\" =~ /^$Client$/)",
        "refresh": 1,
        "regex": "",
        "skipUrlSync": false,
        "sort": 0,
        "type": "query"
      }
    ]
  },
  "time": {
    "from": "now-6h",
    "to": "now"
  },
  "timepicker": {},
  "timezone": "",
  "title": "WLAN Summary",
  "uid": "a29fff7e-3281-43fc-b18e-06a302bc72dc",
  "version": 39,
  "weekStart": ""
}

Konfiguration des Cisco 9800 WLC

Folgende Konfiguration aktiviert die Telemetry des 9800 WLC und schickt sie an Grafana. Ihr müsst sowohl die Source-IP des WLAN-Controllers sowie die Receiver-IP von Grafana anpassen. Ansonsten liefern euch die Telemetrie-Subscription alle Infos, die ihr für mein Dashboard oben benötigt.

Achtung: Die Nummerierung der IETF-Subscriptions auf dem Controller muss eindeutig sein.

int g1
load-interval 30


netconf ssh
netconf-yang

telemetry ietf subscription 1
 encoding encode-kvgpb
 filter xpath /wireless-client-oper:client-oper-data/traffic-stats
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 2
 encoding encode-kvgpb
 filter xpath /wireless-client-oper:client-oper-data/dc-info
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 3
 encoding encode-kvgpb
 filter xpath /wireless-client-oper:client-oper-data/sisf-db-mac
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 4
 encoding encode-kvgpb
 filter xpath /wireless-client-oper:client-oper-data/client-wsa-info
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 5
 encoding encode-kvgpb
 filter xpath /wireless-access-point-oper:access-point-oper-data/radio-oper-stats
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 6
 encoding encode-kvgpb
 filter xpath /wireless-access-point-oper:access-point-oper-data/ap-name-mac-map
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 7
 encoding encode-kvgpb
 filter xpath /wireless-access-point-oper:access-point-oper-data/capwap-data
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 8
 encoding encode-kvgpb
 filter xpath /wireless-access-point-oper:access-point-oper-data/radio-oper-data
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 9
 encoding encode-kvgpb
 filter xpath /wireless-access-point-oper:access-point-oper-data/ssid-counters
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 10
 encoding encode-kvgpb
 filter xpath /wireless-client-oper:client-oper-data/common-oper-data
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 11
 encoding encode-kvgpb
 filter xpath /wireless-rrm-oper:rrm-oper-data/rrm-measurement
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 12
 encoding encode-kvgpb
 filter xpath /wireless-mobility-oper:mobility-oper-data/mobility-node-data
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 13
 encoding encode-kvgpb
 filter xpath /wireless-mobility-oper:mobility-oper-data/wlan-client-limit
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 14
 encoding encode-kvgpb
 filter xpath /wireless-client-oper:client-oper-data/dot11-oper-data
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 15
 encoding encode-kvgpb
 filter xpath /interfaces-ios-xe-oper:interfaces/interfaces-ios-xe-oper:interface/interfaces-ios-xe-oper:statistics
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp
telemetry ietf subscription 16
 encoding encode-kvgpb
 filter xpath /wireless-oper-awips:awips-oper-data/wireless-oper-awips:awips-alarm
 source-address 192.168.1.3
 stream yang-push
 update-policy periodic 1000
 receiver ip address 192.168.1.2 57000 protocol grpc-tcp