Windows Servers Status Summary
Windows Server Status using Prometheus and windows_exporter
This dashboard for Windows Server Summary using Prometheus and windows_exporter
{
  "__inputs": [
    {
      "name": "DS_PROMETHEUS",
      "label": "Prometheus",
      "description": "",
      "type": "datasource",
      "pluginId": "prometheus",
      "pluginName": "Prometheus"
    }
  ],
  "__elements": {},
  "__requires": [
    {
      "type": "grafana",
      "id": "grafana",
      "name": "Grafana",
      "version": "9.5.1"
    },
    {
      "type": "panel",
      "id": "mxswat-separator-panel",
      "name": "Separator",
      "version": "1.0.1"
    },
    {
      "type": "panel",
      "id": "piechart",
      "name": "Pie chart",
      "version": ""
    },
    {
      "type": "datasource",
      "id": "prometheus",
      "name": "Prometheus",
      "version": "1.0.0"
    },
    {
      "type": "panel",
      "id": "stat",
      "name": "Stat",
      "version": ""
    },
    {
      "type": "panel",
      "id": "table",
      "name": "Table",
      "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"
      }
    ]
  },
  "editable": true,
  "fiscalYearStartMonth": 0,
  "graphTooltip": 0,
  "id": null,
  "links": [],
  "liveNow": false,
  "panels": [
    {
      "datasource": {
        "type": "prometheus",
        "uid": "${DS_PROMETHEUS}"
      },
      "fieldConfig": {
        "defaults": {
          "displayName": "Total Machines",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "semi-dark-blue",
                "value": null
              }
            ]
          },
          "unit": "short"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 3,
        "w": 7,
        "x": 0,
        "y": 0
      },
      "hideTimeOverride": true,
      "id": 30,
      "interval": "10m",
      "links": [],
      "options": {
        "colorMode": "background",
        "graphMode": "none",
        "justifyMode": "auto",
        "orientation": "horizontal",
        "reduceOptions": {
          "calcs": [
            "max"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.5.1",
      "targets": [
        {
          "bucketAggs": [
            {
              "$$hashKey": "object:59",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "auto",
                "min_doc_count": 0,
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "count(up{job=~\"job_.*\"})",
          "legendFormat": "{{instance}}",
          "metrics": [
            {
              "$$hashKey": "object:57",
              "field": "host.hostname",
              "id": "1",
              "meta": {},
              "settings": {
                "precision_threshold": "50"
              },
              "type": "cardinality"
            }
          ],
          "query": "host.hostname: * AND NOT host.hostname: \"www.ferizy.com\"",
          "range": true,
          "refId": "A",
          "timeField": "@timestamp"
        }
      ],
      "type": "stat"
    },
    {
      "datasource": {
        "type": "prometheus",
        "uid": "${DS_PROMETHEUS}"
      },
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 3
      },
      "id": 38,
      "pluginVersion": "7.3.2",
      "targets": [
        {
          "bucketAggs": [
            {
              "$$hashKey": "object:8084",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "auto",
                "min_doc_count": 0,
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "metrics": [
            {
              "$$hashKey": "object:8082",
              "field": "select field",
              "id": "1",
              "type": "count"
            }
          ],
          "refId": "A",
          "timeField": "@timestamp"
        }
      ],
      "type": "mxswat-separator-panel"
    },
    {
      "datasource": {
        "type": "prometheus",
        "uid": "${DS_PROMETHEUS}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 5,
        "x": 0,
        "y": 4
      },
      "hideTimeOverride": false,
      "id": 14,
      "interval": "1h",
      "links": [],
      "maxDataPoints": 1,
      "options": {
        "displayLabels": [
          "value"
        ],
        "legend": {
          "displayMode": "table",
          "placement": "right",
          "showLegend": true,
          "values": [
            "value"
          ]
        },
        "pieType": "donut",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "6.7.1",
      "targets": [
        {
          "bucketAggs": [
            {
              "$$hashKey": "object:113",
              "fake": true,
              "field": "monitor.status",
              "id": "7",
              "settings": {
                "min_doc_count": "1",
                "order": "desc",
                "orderBy": "_count",
                "size": "0"
              },
              "type": "terms"
            },
            {
              "$$hashKey": "object:114",
              "fake": true,
              "field": "@timestamp",
              "id": "6",
              "settings": {
                "interval": "1h",
                "min_doc_count": 0,
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "count(up{job=~\"Job_.*\"} == 1)",
          "legendFormat": "UP",
          "metrics": [
            {
              "$$hashKey": "object:111",
              "field": "url.domain",
              "id": "3",
              "meta": {},
              "settings": {
                "precision_threshold": "50"
              },
              "type": "cardinality"
            }
          ],
          "query": "monitor.type:icmp AND NOT monitor.name: pelabuhan",
          "range": true,
          "refId": "A",
          "timeField": "@timestamp"
        },
        {
          "bucketAggs": [
            {
              "$$hashKey": "object:113",
              "fake": true,
              "field": "monitor.status",
              "id": "7",
              "settings": {
                "min_doc_count": "1",
                "order": "desc",
                "orderBy": "_count",
                "size": "0"
              },
              "type": "terms"
            },
            {
              "$$hashKey": "object:114",
              "fake": true,
              "field": "@timestamp",
              "id": "6",
              "settings": {
                "interval": "1h",
                "min_doc_count": 0,
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "count(up{job=~\"Job.*\"} == 0)",
          "hide": false,
          "legendFormat": "DOWN",
          "metrics": [
            {
              "$$hashKey": "object:111",
              "field": "url.domain",
              "id": "3",
              "meta": {},
              "settings": {
                "precision_threshold": "50"
              },
              "type": "cardinality"
            }
          ],
          "query": "monitor.type:icmp AND NOT monitor.name: pelabuhan",
          "range": true,
          "refId": "B",
          "timeField": "@timestamp"
        }
      ],
      "timeFrom": "1h",
      "title": "Summary Status",
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "prometheus",
        "uid": "${DS_PROMETHEUS}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "decimals": 0,
          "mappings": [],
          "unit": "short"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "Critical"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "#E02F44",
                  "mode": "fixed"
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 5,
        "w": 5,
        "x": 5,
        "y": 4
      },
      "hideTimeOverride": false,
      "id": 18,
      "interval": "5m",
      "links": [],
      "options": {
        "displayLabels": [
          "value"
        ],
        "legend": {
          "calcs": [],
          "displayMode": "table",
          "placement": "right",
          "showLegend": true,
          "values": [
            "value"
          ]
        },
        "pieType": "donut",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "6.7.1",
      "targets": [
        {
          "alias": "Normal",
          "bucketAggs": [
            {
              "$$hashKey": "object:528",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "auto",
                "min_doc_count": "0",
                "trimEdges": "0"
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "exemplar": false,
          "expr": "count(100 - (avg by (instance) (irate(windows_cpu_time_total{mode=\"idle\"}[2m])) * 100) < 70) ",
          "instant": false,
          "legendFormat": "Normal",
          "metrics": [
            {
              "$$hashKey": "object:526",
              "field": "agent.name",
              "id": "1",
              "meta": {},
              "settings": {
                "missing": 0,
                "precision_threshold": 0
              },
              "type": "cardinality"
            }
          ],
          "query": "system.cpu.total.norm.pct:[0 TO 0.70]",
          "range": true,
          "refId": "A",
          "timeField": "@timestamp"
        },
        {
          "alias": "Normal",
          "bucketAggs": [
            {
              "$$hashKey": "object:528",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "auto",
                "min_doc_count": "0",
                "trimEdges": "0"
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "exemplar": false,
          "expr": "count(100 - (avg by (instance) (irate(windows_cpu_time_total{mode=\"idle\"}[2m])) * 100) < 95 > 70) ",
          "hide": false,
          "instant": false,
          "legendFormat": "Warning",
          "metrics": [
            {
              "$$hashKey": "object:526",
              "field": "agent.name",
              "id": "1",
              "meta": {},
              "settings": {
                "missing": 0,
                "precision_threshold": 0
              },
              "type": "cardinality"
            }
          ],
          "query": "system.cpu.total.norm.pct:[0 TO 0.70]",
          "range": true,
          "refId": "B",
          "timeField": "@timestamp"
        },
        {
          "alias": "Normal",
          "bucketAggs": [
            {
              "$$hashKey": "object:528",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "auto",
                "min_doc_count": "0",
                "trimEdges": "0"
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "exemplar": false,
          "expr": "count(100 - (avg by (instance) (irate(windows_cpu_time_total{mode=\"idle\"}[2m])) * 100) > 95) ",
          "hide": false,
          "instant": false,
          "legendFormat": "Critical",
          "metrics": [
            {
              "$$hashKey": "object:526",
              "field": "agent.name",
              "id": "1",
              "meta": {},
              "settings": {
                "missing": 0,
                "precision_threshold": 0
              },
              "type": "cardinality"
            }
          ],
          "query": "system.cpu.total.norm.pct:[0 TO 0.70]",
          "range": true,
          "refId": "C",
          "timeField": "@timestamp"
        }
      ],
      "timeFrom": "1h",
      "title": "Summary CPU Load",
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "prometheus",
        "uid": "${DS_PROMETHEUS}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": [],
          "unit": "none"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 4,
        "x": 10,
        "y": 4
      },
      "hideTimeOverride": false,
      "id": 19,
      "interval": "5m",
      "links": [],
      "options": {
        "displayLabels": [
          "value"
        ],
        "legend": {
          "displayMode": "table",
          "placement": "right",
          "showLegend": true,
          "values": [
            "value"
          ]
        },
        "pieType": "donut",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "6.7.1",
      "targets": [
        {
          "alias": "Normal",
          "bucketAggs": [
            {
              "$$hashKey": "object:171",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "1h",
                "min_doc_count": "0",
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "exemplar": false,
          "expr": "count(((windows_cs_physical_memory_bytes - windows_os_physical_memory_free_bytes) / windows_cs_physical_memory_bytes) < 0.7)",
          "instant": false,
          "legendFormat": "Normal",
          "metrics": [
            {
              "$$hashKey": "object:169",
              "field": "agent.name",
              "id": "1",
              "meta": {},
              "settings": {
                "missing": 0,
                "precision_threshold": 0
              },
              "type": "cardinality"
            }
          ],
          "query": "system.memory.actual.used.pct:[0 TO 0.701]",
          "range": true,
          "refId": "A",
          "timeField": "@timestamp"
        },
        {
          "alias": "Warning",
          "bucketAggs": [
            {
              "$$hashKey": "object:175",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "1h",
                "min_doc_count": "0",
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "exemplar": false,
          "expr": "count(((windows_cs_physical_memory_bytes - windows_os_physical_memory_free_bytes) / windows_cs_physical_memory_bytes) < 0.9 > 0.7)",
          "hide": true,
          "instant": false,
          "legendFormat": "Warning",
          "metrics": [
            {
              "$$hashKey": "object:173",
              "field": "host.hostname",
              "id": "1",
              "meta": {},
              "settings": {
                "missing": 0,
                "precision_threshold": 0
              },
              "type": "cardinality"
            }
          ],
          "query": "system.memory.actual.used.pct:[0.701 TO 0.901]",
          "range": true,
          "refId": "B",
          "timeField": "@timestamp"
        },
        {
          "alias": "Critical",
          "bucketAggs": [
            {
              "$$hashKey": "object:179",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "1h",
                "min_doc_count": "0",
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "exemplar": false,
          "expr": "count(((windows_cs_physical_memory_bytes - windows_os_physical_memory_free_bytes) / windows_cs_physical_memory_bytes) > 0.95)",
          "hide": true,
          "instant": false,
          "legendFormat": "Critical",
          "metrics": [
            {
              "$$hashKey": "object:177",
              "field": "agent.name",
              "id": "1",
              "meta": {},
              "settings": {
                "missing": 0,
                "precision_threshold": 0
              },
              "type": "cardinality"
            }
          ],
          "query": "system.memory.actual.used.pct:[0.901 TO 1]",
          "range": true,
          "refId": "C",
          "timeField": "@timestamp"
        }
      ],
      "timeFrom": "1h",
      "title": "Summary RAM Usage",
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "prometheus",
        "uid": "${DS_PROMETHEUS}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 5,
        "x": 14,
        "y": 4
      },
      "hideTimeOverride": true,
      "id": 26,
      "interval": "30m",
      "links": [],
      "maxDataPoints": 1,
      "options": {
        "displayLabels": [
          "value"
        ],
        "legend": {
          "displayMode": "table",
          "placement": "right",
          "showLegend": true,
          "values": [
            "value"
          ]
        },
        "pieType": "donut",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "alias": "Normal",
          "bucketAggs": [
            {
              "$$hashKey": "object:694",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "auto",
                "min_doc_count": 0,
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "count(100 - ((windows_logical_disk_free_bytes{volume=\"C:\"} / windows_logical_disk_size_bytes{volume=\"C:\"})*100) < 70)",
          "legendFormat": "Normal",
          "metrics": [
            {
              "$$hashKey": "object:692",
              "field": "host.hostname",
              "id": "1",
              "meta": {},
              "settings": {
                "precision_threshold": 50
              },
              "type": "cardinality"
            }
          ],
          "query": "metricset.name:\"filesystem\" AND system.filesystem.used.pct: [0 TO 0.7]",
          "range": true,
          "refId": "A",
          "timeField": "@timestamp"
        },
        {
          "alias": "Warning",
          "bucketAggs": [
            {
              "$$hashKey": "object:698",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "auto",
                "min_doc_count": 0,
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "count(100 - ((windows_logical_disk_free_bytes{volume=\"C:\"} / windows_logical_disk_size_bytes{volume=\"C:\"})*100) < 90 > 70)",
          "legendFormat": "Warning",
          "metrics": [
            {
              "$$hashKey": "object:696",
              "field": "host.hostname",
              "id": "1",
              "meta": {},
              "settings": {
                "precision_threshold": 50
              },
              "type": "cardinality"
            }
          ],
          "query": "metricset.name:\"filesystem\" AND  system.filesystem.used.pct: [0.701 TO 0.900]",
          "range": true,
          "refId": "B",
          "timeField": "@timestamp"
        },
        {
          "alias": "Critical",
          "bucketAggs": [
            {
              "$$hashKey": "object:702",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "auto",
                "min_doc_count": 0,
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "count(100 - ((windows_logical_disk_free_bytes{volume=\"C:\"} / windows_logical_disk_size_bytes{volume=\"C:\"})*100) > 90)",
          "legendFormat": "Critical",
          "metrics": [
            {
              "$$hashKey": "object:700",
              "field": "host.hostname",
              "id": "1",
              "meta": {},
              "settings": {
                "precision_threshold": 50
              },
              "type": "cardinality"
            }
          ],
          "query": "metricset.name:\"filesystem\"  AND system.filesystem.used.pct: [0.901 TO 1]",
          "range": true,
          "refId": "C",
          "timeField": "@timestamp"
        }
      ],
      "timeFrom": "10m",
      "title": "Summary File System Disk Usage C:",
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "prometheus",
        "uid": "${DS_PROMETHEUS}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 5,
        "x": 19,
        "y": 4
      },
      "hideTimeOverride": true,
      "id": 39,
      "interval": "30m",
      "links": [],
      "maxDataPoints": 1,
      "options": {
        "displayLabels": [
          "value"
        ],
        "legend": {
          "displayMode": "table",
          "placement": "right",
          "showLegend": true,
          "values": [
            "value"
          ]
        },
        "pieType": "donut",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "alias": "Normal",
          "bucketAggs": [
            {
              "$$hashKey": "object:694",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "auto",
                "min_doc_count": 0,
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "count(100 - ((windows_logical_disk_free_bytes{volume=\"D:\"} / windows_logical_disk_size_bytes{volume=\"D:\"})*100) < 70)",
          "legendFormat": "Normal",
          "metrics": [
            {
              "$$hashKey": "object:692",
              "field": "host.hostname",
              "id": "1",
              "meta": {},
              "settings": {
                "precision_threshold": 50
              },
              "type": "cardinality"
            }
          ],
          "query": "metricset.name:\"filesystem\" AND system.filesystem.used.pct: [0 TO 0.7]",
          "range": true,
          "refId": "A",
          "timeField": "@timestamp"
        },
        {
          "alias": "Warning",
          "bucketAggs": [
            {
              "$$hashKey": "object:698",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "auto",
                "min_doc_count": 0,
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "count(100 - ((windows_logical_disk_free_bytes{volume=\"D:\"} / windows_logical_disk_size_bytes{volume=\"D:\"})*100) < 90 > 70)",
          "legendFormat": "Warning",
          "metrics": [
            {
              "$$hashKey": "object:696",
              "field": "host.hostname",
              "id": "1",
              "meta": {},
              "settings": {
                "precision_threshold": 50
              },
              "type": "cardinality"
            }
          ],
          "query": "metricset.name:\"filesystem\" AND  system.filesystem.used.pct: [0.701 TO 0.900]",
          "range": true,
          "refId": "B",
          "timeField": "@timestamp"
        },
        {
          "alias": "Critical",
          "bucketAggs": [
            {
              "$$hashKey": "object:702",
              "field": "@timestamp",
              "id": "2",
              "settings": {
                "interval": "auto",
                "min_doc_count": 0,
                "trimEdges": 0
              },
              "type": "date_histogram"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "count(100 - ((windows_logical_disk_free_bytes{volume=\"D:\"} / windows_logical_disk_size_bytes{volume=\"D:\"})*100) > 90)",
          "legendFormat": "Critical",
          "metrics": [
            {
              "$$hashKey": "object:700",
              "field": "host.hostname",
              "id": "1",
              "meta": {},
              "settings": {
                "precision_threshold": 50
              },
              "type": "cardinality"
            }
          ],
          "query": "metricset.name:\"filesystem\"  AND system.filesystem.used.pct: [0.901 TO 1]",
          "range": true,
          "refId": "C",
          "timeField": "@timestamp"
        }
      ],
      "timeFrom": "10m",
      "title": "Summary File System Disk Usage D:",
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "prometheus",
        "uid": "${DS_PROMETHEUS}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "align": "auto",
            "cellOptions": {
              "type": "auto"
            },
            "inspect": false
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "Node"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Hostname"
              },
              {
                "id": "custom.align"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "Up (lastNotNull)"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "State"
              },
              {
                "id": "unit",
                "value": "short"
              },
              {
                "id": "decimals"
              },
              {
                "id": "custom.align",
                "value": "right"
              },
              {
                "id": "thresholds",
                "value": {
                  "mode": "absolute",
                  "steps": [
                    {
                      "color": "rgba(245, 54, 54, 0.9)",
                      "value": null
                    },
                    {
                      "color": "rgba(50, 172, 45, 0.97)",
                      "value": 1
                    }
                  ]
                }
              },
              {
                "id": "color",
                "value": {
                  "mode": "thresholds"
                }
              },
              {
                "id": "custom.cellOptions",
                "value": {
                  "mode": "basic",
                  "type": "color-background"
                }
              },
              {
                "id": "mappings",
                "value": [
                  {
                    "options": {
                      "0": {
                        "index": 1,
                        "text": "DOWN"
                      },
                      "1": {
                        "index": 0,
                        "text": "UP"
                      }
                    },
                    "type": "value"
                  }
                ]
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "Percentage (mean)"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "UP Percentage"
              },
              {
                "id": "unit",
                "value": "percentunit"
              },
              {
                "id": "custom.cellOptions",
                "value": {
                  "mode": "gradient",
                  "type": "color-background"
                }
              },
              {
                "id": "thresholds",
                "value": {
                  "mode": "absolute",
                  "steps": [
                    {
                      "color": "red",
                      "value": null
                    },
                    {
                      "color": "#EAB839",
                      "value": 0.8
                    },
                    {
                      "color": "green",
                      "value": 1
                    }
                  ]
                }
              },
              {
                "id": "custom.align",
                "value": "left"
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 14,
        "w": 9,
        "x": 0,
        "y": 9
      },
      "hideTimeOverride": false,
      "id": 4,
      "interval": "",
      "options": {
        "cellHeight": "sm",
        "footer": {
          "countRows": false,
          "enablePagination": false,
          "fields": [],
          "reducer": [
            "mean"
          ],
          "show": false
        },
        "showHeader": true,
        "sortBy": [
          {
            "desc": false,
            "displayName": "UP Percentage"
          }
        ]
      },
      "pluginVersion": "9.5.1",
      "targets": [
        {
          "bucketAggs": [
            {
              "$$hashKey": "object:251",
              "fake": true,
              "field": "url.domain",
              "id": "6",
              "settings": {
                "min_doc_count": "1",
                "order": "desc",
                "orderBy": "_term",
                "size": "0"
              },
              "type": "terms"
            },
            {
              "$$hashKey": "object:252",
              "fake": true,
              "field": "resolve.ip",
              "id": "3",
              "settings": {
                "min_doc_count": "1",
                "order": "desc",
                "orderBy": "_term",
                "size": "1"
              },
              "type": "terms"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "((up{job=~\"Job.*\"}))",
          "legendFormat": "{{instance}}",
          "metrics": [
            {
              "$$hashKey": "object:247",
              "field": "summary.up",
              "id": "1",
              "meta": {},
              "pipelineAgg": "select metric",
              "settings": {
                "missing": 0
              },
              "type": "avg"
            },
            {
              "$$hashKey": "object:248",
              "field": "summary.down",
              "id": "5",
              "meta": {},
              "settings": {
                "missing": 0
              },
              "type": "avg"
            }
          ],
          "query": "monitor.type:icmp AND NOT monitor.name: pelabuhan",
          "range": true,
          "refId": "A",
          "timeField": "@timestamp"
        },
        {
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "count by (instance) ((up{job=~\"Job.*\"}) == 1)",
          "hide": true,
          "legendFormat": "__auto",
          "range": true,
          "refId": "B"
        }
      ],
      "title": "Server State",
      "transformations": [
        {
          "id": "seriesToRows",
          "options": {}
        },
        {
          "id": "organize",
          "options": {
            "excludeByName": {
              "Time": true
            },
            "indexByName": {},
            "renameByName": {
              "Metric": "Node",
              "Value": "Up"
            }
          }
        },
        {
          "id": "calculateField",
          "options": {
            "alias": "Percentage",
            "mode": "reduceRow",
            "reduce": {
              "include": [
                "Up"
              ],
              "reducer": "mean"
            }
          }
        },
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "Node": {
                "aggregations": [],
                "operation": "groupby"
              },
              "Percentage": {
                "aggregations": [
                  "mean"
                ],
                "operation": "aggregate"
              },
              "Up": {
                "aggregations": [
                  "lastNotNull"
                ],
                "operation": "aggregate"
              }
            }
          }
        }
      ],
      "type": "table"
    },
    {
      "datasource": {
        "type": "prometheus",
        "uid": "${DS_PROMETHEUS}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "align": "auto",
            "cellOptions": {
              "type": "auto"
            },
            "inspect": false
          },
          "mappings": [],
          "max": 100,
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "instance"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Host"
              },
              {
                "id": "custom.align",
                "value": "left"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "Cores (lastNotNull)"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "CPU Cores"
              },
              {
                "id": "unit",
                "value": "short"
              },
              {
                "id": "custom.align",
                "value": "center"
              },
              {
                "id": "thresholds",
                "value": {
                  "mode": "absolute",
                  "steps": [
                    {
                      "color": "rgba(245, 54, 54, 0.9)",
                      "value": null
                    },
                    {
                      "color": "#1F60C4",
                      "value": 1
                    }
                  ]
                }
              },
              {
                "id": "custom.cellOptions",
                "value": {
                  "mode": "gradient",
                  "type": "color-background"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "RAM Usage (mean)"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "RAM"
              },
              {
                "id": "unit",
                "value": "percent"
              },
              {
                "id": "decimals",
                "value": 2
              },
              {
                "id": "custom.align"
              },
              {
                "id": "thresholds",
                "value": {
                  "mode": "absolute",
                  "steps": [
                    {
                      "color": "rgba(50, 172, 45, 0.97)",
                      "value": null
                    },
                    {
                      "color": "rgba(237, 129, 40, 0.89)",
                      "value": 70
                    },
                    {
                      "color": "rgba(245, 54, 54, 0.9)",
                      "value": 90
                    }
                  ]
                }
              },
              {
                "id": "custom.cellOptions",
                "value": {
                  "mode": "lcd",
                  "type": "gauge"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "CPU (mean)"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "CPU Load"
              },
              {
                "id": "unit",
                "value": "percent"
              },
              {
                "id": "decimals",
                "value": 2
              },
              {
                "id": "custom.align"
              },
              {
                "id": "thresholds",
                "value": {
                  "mode": "absolute",
                  "steps": [
                    {
                      "color": "rgba(50, 172, 45, 0.97)",
                      "value": null
                    },
                    {
                      "color": "rgba(237, 129, 40, 0.89)",
                      "value": 70
                    },
                    {
                      "color": "rgba(245, 54, 54, 0.9)",
                      "value": 90
                    }
                  ]
                }
              },
              {
                "id": "custom.cellOptions",
                "value": {
                  "mode": "lcd",
                  "type": "gauge"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "C: (mean)"
            },
            "properties": [
              {
                "id": "unit",
                "value": "percent"
              },
              {
                "id": "decimals",
                "value": 2
              },
              {
                "id": "custom.align"
              },
              {
                "id": "custom.cellOptions",
                "value": {
                  "mode": "lcd",
                  "type": "gauge"
                }
              },
              {
                "id": "thresholds",
                "value": {
                  "mode": "absolute",
                  "steps": [
                    {
                      "color": "green",
                      "value": null
                    },
                    {
                      "color": "#EAB839",
                      "value": 70
                    },
                    {
                      "color": "red",
                      "value": 90
                    }
                  ]
                }
              },
              {
                "id": "displayName",
                "value": "C:"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "D: (mean)"
            },
            "properties": [
              {
                "id": "unit",
                "value": "percent"
              },
              {
                "id": "decimals",
                "value": 2
              },
              {
                "id": "custom.align"
              },
              {
                "id": "custom.cellOptions",
                "value": {
                  "mode": "lcd",
                  "type": "gauge"
                }
              },
              {
                "id": "thresholds",
                "value": {
                  "mode": "absolute",
                  "steps": [
                    {
                      "color": "green",
                      "value": null
                    },
                    {
                      "color": "#EAB839",
                      "value": 70
                    },
                    {
                      "color": "red",
                      "value": 90
                    }
                  ]
                }
              },
              {
                "id": "displayName",
                "value": "D:"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "CPU Cores"
            },
            "properties": [
              {
                "id": "custom.width",
                "value": 114
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 14,
        "w": 15,
        "x": 9,
        "y": 9
      },
      "id": 2,
      "interval": "1m",
      "links": [],
      "options": {
        "cellHeight": "sm",
        "footer": {
          "countRows": false,
          "fields": [],
          "reducer": [
            "sum"
          ],
          "show": false
        },
        "showHeader": true,
        "sortBy": [
          {
            "desc": true,
            "displayName": "CPU Load"
          }
        ]
      },
      "pluginVersion": "9.5.1",
      "targets": [
        {
          "aggregation": "Last",
          "alias": "",
          "bucketAggs": [
            {
              "$$hashKey": "object:862",
              "fake": true,
              "field": "host.hostname",
              "id": "3",
              "settings": {
                "min_doc_count": 1,
                "order": "asc",
                "orderBy": "_term",
                "size": "0"
              },
              "type": "terms"
            }
          ],
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "decimals": 2,
          "displayAliasType": "Warning / Critical",
          "displayType": "Regular",
          "displayValueWithAlias": "Never",
          "editorMode": "code",
          "expr": "avg by (instance) (windows_cs_logical_processors)",
          "format": "table",
          "group": {
            "alias": "",
            "name": "Status Checks",
            "url": ""
          },
          "hide": false,
          "legendFormat": "{{instance}}",
          "metrics": [
            {
              "$$hashKey": "object:850",
              "field": "system.cpu.cores",
              "id": "1",
              "meta": {},
              "settings": {},
              "type": "avg"
            },
            {
              "$$hashKey": "object:851",
              "field": "system.cpu.total.norm.pct",
              "id": "4",
              "meta": {},
              "pipelineVariables": [
                {
                  "name": "user",
                  "pipelineAgg": "10"
                },
                {
                  "name": "system",
                  "pipelineAgg": "9"
                }
              ],
              "settings": {},
              "type": "avg"
            },
            {
              "$$hashKey": "object:852",
              "field": "system.memory.actual.used.pct",
              "id": "5",
              "meta": {},
              "settings": {},
              "type": "avg"
            },
            {
              "$$hashKey": "object:853",
              "field": "system.fsstat.total_size.used",
              "hide": true,
              "id": "6",
              "meta": {},
              "settings": {},
              "type": "avg"
            },
            {
              "$$hashKey": "object:854",
              "field": "system.fsstat.total_size.total",
              "hide": true,
              "id": "7",
              "meta": {},
              "settings": {},
              "type": "avg"
            },
            {
              "$$hashKey": "object:855",
              "field": "select field",
              "id": "8",
              "meta": {},
              "pipelineVariables": [
                {
                  "name": "disk_used",
                  "pipelineAgg": "6"
                },
                {
                  "name": "disk_cap",
                  "pipelineAgg": "7"
                }
              ],
              "settings": {
                "script": "params.disk_used/params.disk_cap"
              },
              "type": "bucket_script"
            }
          ],
          "query": "",
          "range": true,
          "refId": "A",
          "timeField": "@timestamp",
          "units": "none",
          "valueHandler": "Number Threshold"
        },
        {
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "100 - (avg by (instance) (irate(windows_cpu_time_total{mode=\"idle\"}[2m])) * 100)",
          "format": "table",
          "hide": false,
          "legendFormat": "{{instance}}",
          "range": true,
          "refId": "B"
        },
        {
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "(((windows_cs_physical_memory_bytes - windows_os_physical_memory_free_bytes) / windows_cs_physical_memory_bytes) * 100)",
          "format": "table",
          "hide": false,
          "legendFormat": "{{instance}}",
          "range": true,
          "refId": "C"
        },
        {
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "100 - ((windows_logical_disk_free_bytes{volume=\"C:\"} / windows_logical_disk_size_bytes{volume=\"C:\"})*100)",
          "format": "table",
          "hide": false,
          "legendFormat": "{{instance}}",
          "range": true,
          "refId": "D"
        },
        {
          "datasource": {
            "type": "prometheus",
            "uid": "${DS_PROMETHEUS}"
          },
          "editorMode": "code",
          "expr": "100 - ((windows_logical_disk_free_bytes{volume=\"D:\"} / windows_logical_disk_size_bytes{volume=\"D:\"})*100)",
          "format": "table",
          "hide": false,
          "legendFormat": "{{instance}}",
          "range": true,
          "refId": "E"
        }
      ],
      "title": "Server Capacity",
      "transformations": [
        {
          "id": "merge",
          "options": {}
        },
        {
          "id": "organize",
          "options": {
            "excludeByName": {
              "Time": true,
              "job": true
            },
            "indexByName": {},
            "renameByName": {
              "Value #A": "Cores",
              "Value #B": "CPU",
              "Value #C": "RAM Usage",
              "Value #D": "C:",
              "Value #E": "D:"
            }
          }
        },
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "C:": {
                "aggregations": [
                  "mean"
                ],
                "operation": "aggregate"
              },
              "CPU": {
                "aggregations": [
                  "mean"
                ],
                "operation": "aggregate"
              },
              "Cores": {
                "aggregations": [
                  "lastNotNull"
                ],
                "operation": "aggregate"
              },
              "D:": {
                "aggregations": [
                  "mean"
                ],
                "operation": "aggregate"
              },
              "RAM Usage": {
                "aggregations": [
                  "mean"
                ],
                "operation": "aggregate"
              },
              "Value #A": {
                "aggregations": [
                  "lastNotNull"
                ],
                "operation": "aggregate"
              },
              "Value #B": {
                "aggregations": [
                  "mean"
                ],
                "operation": "aggregate"
              },
              "Value #C": {
                "aggregations": [
                  "mean"
                ],
                "operation": "aggregate"
              },
              "Value #D": {
                "aggregations": [
                  "mean"
                ],
                "operation": "aggregate"
              },
              "instance": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "table"
    }
  ],
  "refresh": "10s",
  "revision": 1,
  "schemaVersion": 38,
  "style": "dark",
  "tags": [],
  "templating": {
    "list": []
  },
  "time": {
    "from": "now-6h",
    "to": "now"
  },
  "timepicker": {
    "refresh_intervals": [
      "5s",
      "10s",
      "30s",
      "1m",
      "5m",
      "15m",
      "30m",
      "1h",
      "2h",
      "1d"
    ]
  },
  "timezone": "",
  "title": "Windows Servers Status Summary",
  "uid": "ravmV6rZk",
  "version": 15,
  "weekStart": "",
  "gnetId": 18658,
  "description": "Windows Server Status using Prometheus and windows_exporter"
}