Firewall_Monitor
SNMP dashboard for InfluxDB and Telegraf Plugin
This dashboard is prepared to monitor an FW60 Fortigate Firewall:
Amongst the items monitorized we can find the bit rate of every interface, ping status and overall bandwith of the device.
Change the IP item inside the json for the IP address that suites to your systems.
Change the hostname item inside the json for the hostname that suites to your systems.
SNMP dashboard for InfluxDB
{
  "__inputs": [
    {
      "name": "DS_SNMP",
      "label": "snmp",
      "description": "",
      "type": "datasource",
      "pluginId": "influxdb",
      "pluginName": "InfluxDB"
    }
  ],
  "__elements": {},
  "__requires": [
    {
      "type": "panel",
      "id": "barchart",
      "name": "Bar chart",
      "version": ""
    },
    {
      "type": "grafana",
      "id": "grafana",
      "name": "Grafana",
      "version": "9.3.2"
    },
    {
      "type": "datasource",
      "id": "influxdb",
      "name": "InfluxDB",
      "version": "1.0.0"
    },
    {
      "type": "panel",
      "id": "logs",
      "name": "Logs",
      "version": ""
    },
    {
      "type": "panel",
      "id": "stat",
      "name": "Stat",
      "version": ""
    },
    {
      "type": "panel",
      "id": "timeseries",
      "name": "Time series",
      "version": ""
    }
  ],
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": {
          "type": "datasource",
          "uid": "grafana"
        },
        "enable": true,
        "hide": true,
        "iconColor": "rgba(0, 211, 255, 1)",
        "name": "Annotations & Alerts",
        "target": {
          "limit": 100,
          "matchAny": false,
          "tags": [],
          "type": "dashboard"
        },
        "type": "dashboard"
      }
    ]
  },
  "description": "SNMP dashboard for InfluxDB and Telegraf Plugin",
  "editable": true,
  "fiscalYearStartMonth": 0,
  "gnetId": 17884,
  "graphTooltip": 0,
  "id": null,
  "links": [],
  "liveNow": false,
  "panels": [
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "gridPos": {
        "h": 4,
        "w": 4,
        "x": 0,
        "y": 0
      },
      "id": 16,
      "options": {
        "dedupStrategy": "none",
        "enableLogDetails": false,
        "prettifyLogMessage": false,
        "showCommonLabels": false,
        "showLabels": false,
        "showTime": false,
        "sortOrder": "Descending",
        "wrapLogMessage": false
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "alias": "Dispositiu",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [],
          "limit": "1",
          "measurement": "Fortinet_FW60",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT \"Dispositiu\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP')  LIMIT 1\n",
          "rawQuery": false,
          "refId": "A",
          "resultFormat": "table",
          "select": [
            [
              {
                "params": [
                  "Dispositiu"
                ],
                "type": "field"
              }
            ]
          ],
          "slimit": "1",
          "tags": [
            {
              "key": "agent_host",
              "operator": "=",
              "value": "IP"
            }
          ]
        }
      ],
      "title": "Dispositiu",
      "type": "logs"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "links": [],
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "short"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "Datagrames_Rebutjats"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "dark-red",
                  "mode": "fixed"
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 4,
        "w": 3,
        "x": 4,
        "y": 0
      },
      "id": 7,
      "options": {
        "colorMode": "value",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "alias": "Datagrames_Rebutjats",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "hostname"
              ],
              "type": "tag"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Fortinet_FW60",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT mean(ifInErrors) as \"in\", mean(ifOutErrors) as \"out\" FROM \"interface\" WHERE  $timeFilter GROUP BY time(1m), \"hostname\" fill(null)",
          "rawQuery": false,
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "Errors"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "agent_host",
              "operator": "=",
              "value": "IP"
            }
          ]
        }
      ],
      "title": "Discards",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [
            {
              "options": {
                "0": {
                  "color": "dark-green",
                  "index": 0,
                  "text": "OK"
                }
              },
              "type": "value"
            },
            {
              "options": {
                "from": 1,
                "result": {
                  "color": "dark-red",
                  "index": 1,
                  "text": "Error"
                },
                "to": 2
              },
              "type": "range"
            }
          ],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 4,
        "w": 3,
        "x": 7,
        "y": 0
      },
      "id": 26,
      "options": {
        "colorMode": "value",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "ping",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "result_code"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "host",
              "operator": "=",
              "value": "hostname"
            }
          ]
        }
      ],
      "title": "Connexió FW60",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [
            {
              "options": {
                "0": {
                  "color": "dark-green",
                  "index": 0,
                  "text": "OK"
                }
              },
              "type": "value"
            },
            {
              "options": {
                "from": 1,
                "result": {
                  "color": "dark-red",
                  "index": 1
                },
                "to": 2
              },
              "type": "range"
            }
          ],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 4,
        "w": 3,
        "x": 10,
        "y": 0
      },
      "id": 28,
      "options": {
        "colorMode": "value",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "ping",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "result_code"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "url",
              "operator": "=",
              "value": "IP"
            }
          ]
        }
      ],
      "title": "PC_Abel",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": 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
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 6,
        "w": 24,
        "x": 0,
        "y": 4
      },
      "id": 22,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "$$hashKey": "object:178",
          "aggregation": "Last",
          "alias": "avg",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "decimals": 2,
          "displayAliasType": "Warning / Critical",
          "displayType": "Regular",
          "displayValueWithAlias": "Never",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "ping",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "maximum_response_ms"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "host",
              "operator": "=",
              "value": "hostname"
            },
            {
              "condition": "AND",
              "key": "url",
              "operator": "=",
              "value": "IP"
            }
          ],
          "units": "none",
          "valueHandler": "Number Threshold"
        },
        {
          "alias": "lost",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "ping",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "percent_packet_loss"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "host",
              "operator": "=",
              "value": "hostname"
            },
            {
              "condition": "AND",
              "key": "url",
              "operator": "=",
              "value": "IP"
            }
          ]
        }
      ],
      "title": "ping",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 10,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "never",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "links": [],
          "mappings": [],
          "max": 100,
          "min": 0,
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "percent"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 6,
        "w": 10,
        "x": 0,
        "y": 10
      },
      "id": 4,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "pluginVersion": "9.3.2",
      "repeatDirection": "h",
      "targets": [
        {
          "alias": "Memory",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [
            {
              "params": [
                "1m"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Fortinet_FW60",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT mean(\"memory\") FROM \"snmp\" WHERE  $timeFilter GROUP BY time(1m),  \"hostname\" fill(null)",
          "rawQuery": false,
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "Mem Usage"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "agent_host",
              "operator": "=",
              "value": "IP"
            }
          ]
        }
      ],
      "title": "Memory",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 10,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "never",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "links": [],
          "mappings": [],
          "max": 100,
          "min": 0,
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "percent"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 6,
        "w": 8,
        "x": 10,
        "y": 10
      },
      "id": 5,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "alias": "CPU",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Fortinet_FW60",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT mean(\"sw_cpu\") FROM \"snmp\" WHERE  $timeFilter GROUP BY time(1m), \"hostname\" fill(null)",
          "rawQuery": false,
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "CPU Usage"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              },
              {
                "params": [
                  "10s"
                ],
                "type": "non_negative_derivative"
              }
            ]
          ],
          "tags": [
            {
              "key": "agent_host",
              "operator": "=",
              "value": "IP"
            }
          ]
        }
      ],
      "title": "CPU",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [
            {
              "id": 0,
              "op": "=",
              "text": "N/A",
              "type": 1,
              "value": "null"
            }
          ],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "#6ED0E0",
                "value": 2500000
              },
              {
                "color": "#EAB839",
                "value": 10000000
              },
              {
                "color": "red",
                "value": 20000000
              }
            ]
          },
          "unit": "s"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 6,
        "w": 5,
        "x": 18,
        "y": 10
      },
      "id": 9,
      "links": [],
      "options": {
        "colorMode": "value",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "horizontal",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "alias": "$tag_hostname",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "hostname"
              ],
              "type": "tag"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Fortinet_FW60",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT last(\"uptime\") FROM \"snmp\" WHERE (\"host\" = 'telegraf') AND $timeFilter GROUP BY time(1m), \"hostname\" fill(null)",
          "rawQuery": false,
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "Uptime"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              },
              {
                "params": [
                  " / 100"
                ],
                "type": "math"
              }
            ]
          ],
          "tags": [
            {
              "key": "agent_host",
              "operator": "=",
              "value": "IP"
            }
          ]
        }
      ],
      "title": "Uptime",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": 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": "bytes"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 7,
        "w": 23,
        "x": 0,
        "y": 16
      },
      "id": 20,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "alias": "if6",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Fortinet_FW60",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada6\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "LAN - Entrada6"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              },
              {
                "params": [
                  "1s"
                ],
                "type": "non_negative_derivative"
              },
              {
                "params": [
                  "*8"
                ],
                "type": "math"
              },
              {
                "params": [
                  "in"
                ],
                "type": "alias"
              }
            ]
          ],
          "tags": [
            {
              "key": "agent_host",
              "operator": "=",
              "value": "IP"
            }
          ]
        },
        {
          "alias": "if7",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada7\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "C",
          "resultFormat": "time_series"
        },
        {
          "alias": "if8",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada8\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "D",
          "resultFormat": "time_series"
        },
        {
          "alias": "if9",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada9\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "E",
          "resultFormat": "time_series"
        },
        {
          "alias": "if10",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada10\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "F",
          "resultFormat": "time_series"
        },
        {
          "alias": "if11",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada11\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "G",
          "resultFormat": "time_series"
        },
        {
          "alias": "if12",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada12\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "H",
          "resultFormat": "time_series"
        },
        {
          "alias": "if13",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada13\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "I",
          "resultFormat": "time_series"
        },
        {
          "alias": "if14",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada14\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "J",
          "resultFormat": "time_series"
        },
        {
          "alias": "if15",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada15\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "K",
          "resultFormat": "time_series"
        },
        {
          "alias": "if16",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada16\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "L",
          "resultFormat": "time_series"
        },
        {
          "alias": "if17",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada17\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "M",
          "resultFormat": "time_series"
        },
        {
          "alias": "if18",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada18\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "N",
          "resultFormat": "time_series"
        },
        {
          "alias": "if19",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada19\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "O",
          "resultFormat": "time_series"
        },
        {
          "alias": "if20",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada20\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "P",
          "resultFormat": "time_series"
        }
      ],
      "title": "LAN In",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": 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"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "bytes"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 7,
        "w": 23,
        "x": 0,
        "y": 23
      },
      "id": 18,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "alias": "if6",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Fortinet_FW60",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida6\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "LAN - Sortida6"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "agent_host",
              "operator": "=",
              "value": "IP"
            }
          ]
        },
        {
          "alias": "if7",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida7\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "C",
          "resultFormat": "time_series"
        },
        {
          "alias": "if8",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida8\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "D",
          "resultFormat": "time_series"
        },
        {
          "alias": "if9",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida9\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "E",
          "resultFormat": "time_series"
        },
        {
          "alias": "if10",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida10\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "F",
          "resultFormat": "time_series"
        },
        {
          "alias": "if11",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida11\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "G",
          "resultFormat": "time_series"
        },
        {
          "alias": "if12",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida12\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "H",
          "resultFormat": "time_series"
        },
        {
          "alias": "if13",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida13\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "I",
          "resultFormat": "time_series"
        },
        {
          "alias": "if14",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida14\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "J",
          "resultFormat": "time_series"
        },
        {
          "alias": "if15",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida15\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "K",
          "resultFormat": "time_series"
        },
        {
          "alias": "if16",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida16\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "L",
          "resultFormat": "time_series"
        },
        {
          "alias": "if17",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida17\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "M",
          "resultFormat": "time_series"
        },
        {
          "alias": "if18",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida18\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "N",
          "resultFormat": "time_series"
        },
        {
          "alias": "if19",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida19\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "O",
          "resultFormat": "time_series"
        },
        {
          "alias": "if20",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "Fortinet_FW60",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida20\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "P",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": []
        }
      ],
      "title": "LAN Out",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": 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"
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "bytes"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 4,
        "w": 24,
        "x": 0,
        "y": 30
      },
      "id": 24,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "alias": "VPN in",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "query": "SELECT non_negative_derivative(mean(\"LAN - Entrada5\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "A",
          "resultFormat": "time_series"
        },
        {
          "alias": "VPN out",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "hide": false,
          "query": "SELECT non_negative_derivative(mean(\"LAN - Sortida5\"), 1s) *8 AS \"in\" FROM \"Fortinet_FW60\" WHERE (\"agent_host\" = 'IP') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": true,
          "refId": "B",
          "resultFormat": "time_series"
        }
      ],
      "title": "VPN",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_SNMP}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "fillOpacity": 80,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineWidth": 1,
            "scaleDistribution": {
              "type": "linear"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "links": [],
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "bps"
        },
        "overrides": [
          {
            "__systemRef": "hideSeriesFrom",
            "matcher": {
              "id": "byNames",
              "options": {
                "mode": "exclude",
                "names": [
                  "LAN in"
                ],
                "prefix": "All except:",
                "readOnly": true
              }
            },
            "properties": [
              {
                "id": "custom.hideFrom",
                "value": {
                  "legend": false,
                  "tooltip": false,
                  "viz": true
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 6,
        "w": 24,
        "x": 0,
        "y": 34
      },
      "id": 11,
      "options": {
        "barRadius": 0,
        "barWidth": 0.97,
        "groupWidth": 0.7,
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "orientation": "auto",
        "showValue": "auto",
        "stacking": "none",
        "tooltip": {
          "mode": "single",
          "sort": "none"
        },
        "xTickLabelRotation": 0,
        "xTickLabelSpacing": 0
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "alias": "LAN in",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_SNMP}"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "Fortinet_FW60",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT  8*non_negative_derivative(mean(\"ifInOctets\"),1m) as \"in\",  8*non_negative_derivative(mean(\"ifOutOctets\"),1m) as \"out\" FROM \"interface\" WHERE $timeFilter GROUP BY time(1m), \"hostname\" fill(null)",
          "rawQuery": false,
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "Net"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "agent_host",
              "operator": "=",
              "value": "IP"
            }
          ]
        }
      ],
      "title": "Bandwidth",
      "type": "barchart"
    }
  ],
  "refresh": "10s",
  "schemaVersion": 37,
  "style": "dark",
  "tags": [],
  "templating": {
    "list": []
  },
  "time": {
    "from": "now-1h",
    "to": "now"
  },
  "timepicker": {
    "refresh_intervals": [
      "5s",
      "10s",
      "30s",
      "1m",
      "5m",
      "15m",
      "30m",
      "1h",
      "2h",
      "1d"
    ]
  },
  "timezone": "",
  "title": "Firewall_Monitor",
  "uid": "uAJoV_gGzy",
  "version": 45,
  "weekStart": ""
}