Grafana - Bacula

{ “annotations”: { “list”: [ { “builtIn”: 1, “datasource”: “– Grafana –”, “enable”: true, “hide”: true, “iconColor”: “rgba(0, 211, 255, 1)”, “name”: “Annotations & Alerts”, “type”: “dashboard” } ] }, “editable”: true, “gnetId”: null, “graphTooltip”: 0, “id”: 20, “links”: [], “panels”: [ { “cacheTimeout”: null, “colorBackground”: true, “colorValue”: false, “colors”: [ “#269926”, “rgba(237, 129, 40, 0.89)”, “#ff4040” ], “datasource”: “PostgreSQL”, “format”: “none”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 4, “w”: 6, “x”: 0, “y”: 0 }, “id”: 4, “interval”: null, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “nullPointMode”: “connected”, “nullText”: null, “postfix”: “”, “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “rgb(31, 120, 193)”, “show”: false }, “tableColumn”: “count”, “targets”: [ { “format”: “table”, “group”: [], “metricColumn”: “none”, “rawQuery”: true, “rawSql”: “SELECT count() FROM Job WHERE (jobstatus=’f’ OR jobstatus=’E’) AND (EXTRACT(EPOCH from now()) - EXTRACT(EPOCH from endtime)) < 86000 ;”, “refId”: “A”, “select”: [ [ { “params”: [ “value” ], “type”: “column” } ] ], “timeColumn”: “time”, “where”: [ { “name”: “$__timeFilter”, “params”: [], “type”: “macro” } ] } ], “thresholds”: “1,2”, “timeFrom”: null, “timeShift”: null, “title”: “FAILED LAST 24H”, “type”: “singlestat”, “valueFontSize”: “80%”, “valueMaps”: [ { “op”: “=”, “text”: “N/A”, “value”: “null” } ], “valueName”: “avg” }, { “cacheTimeout”: null, “datasource”: “PostgreSQL”, “gridPos”: { “h”: 4, “w”: 6, “x”: 6, “y”: 0 }, “id”: 5, “links”: [], “options”: { “maxValue”: “150”, “minValue”: 0, “showThresholdLabels”: false, “showThresholdMarkers”: true, “thresholds”: [ { “color”: “#C4162A”, “index”: 0, “value”: null }, { “color”: “#FA6400”, “index”: 1, “value”: 25 }, { “color”: “#E0B400”, “index”: 2, “value”: 50 }, { “color”: “#269926”, “index”: 3, “value”: 75 } ], “valueMappings”: [], “valueOptions”: { “decimals”: null, “prefix”: “”, “stat”: “avg”, “suffix”: “”, “unit”: “none” } }, “targets”: [ { “format”: “table”, “group”: [], “metricColumn”: “none”, “rawQuery”: true, “rawSql”: “SELECT count() FROM Job WHERE (jobstatus=’T’) AND (EXTRACT(EPOCH from now()) - EXTRACT(EPOCH from endtime)) < 86000 ;”, “refId”: “A”, “select”: [ [ { “params”: [ “value” ], “type”: “column” } ] ], “timeColumn”: “time”, “where”: [ { “name”: “$__timeFilter”, “params”: [], “type”: “macro” } ] } ], “timeFrom”: null, “timeShift”: null, “title”: “OK LAST 24H”, “type”: “gauge” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: false, “colors”: [ “#269926”, “rgba(237, 129, 40, 0.89)”, “#d44a3a” ], “datasource”: “PostgreSQL”, “format”: “none”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 4, “w”: 6, “x”: 12, “y”: 0 }, “id”: 6, “interval”: null, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “nullPointMode”: “connected”, “nullText”: null, “postfix”: “”, “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “rgb(31, 120, 193)”, “show”: false }, “tableColumn”: “count”, “targets”: [ { “format”: “table”, “group”: [], “metricColumn”: “none”, “rawQuery”: true, “rawSql”: “SELECT count() FROM Job WHERE jobstatus=’R’;”, “refId”: “A”, “select”: [ [ { “params”: [ “value” ], “type”: “column” } ] ], “timeColumn”: “time”, “where”: [ { “name”: “$__timeFilter”, “params”: [], “type”: “macro” } ] } ], “thresholds”: “”, “timeFrom”: null, “timeShift”: null, “title”: “RUNNING JOBS”, “type”: “singlestat”, “valueFontSize”: “80%”, “valueMaps”: [ { “op”: “=”, “text”: “N/A”, “value”: “null” } ], “valueName”: “avg” }, { “cacheTimeout”: null, “colorBackground”: true, “colorValue”: false, “colors”: [ “#269926”, “rgba(237, 129, 40, 0.89)”, “#d44a3a” ], “datasource”: “PostgreSQL”, “format”: “none”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 4, “w”: 6, “x”: 18, “y”: 0 }, “id”: 7, “interval”: null, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “nullPointMode”: “connected”, “nullText”: null, “postfix”: “”, “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “rgb(31, 120, 193)”, “show”: false }, “tableColumn”: “count”, “targets”: [ { “format”: “table”, “group”: [], “metricColumn”: “none”, “rawQuery”: true, “rawSql”: “SELECT count() FROM Job WHERE jobstatus=’M’ or jobstatus=’m’ or jobstatus=’C’;”, “refId”: “A”, “select”: [ [ { “params”: [ “value” ], “type”: “column” } ] ], “timeColumn”: “time”, “where”: [ { “name”: “$__timeFilter”, “params”: [], “type”: “macro” } ] } ], “thresholds”: “1,1”, “timeFrom”: null, “timeShift”: null, “title”: “WAITING TAPE/MOUNT”, “type”: “singlestat”, “valueFontSize”: “80%”, “valueMaps”: [ { “op”: “=”, “text”: “N/A”, “value”: “null” } ], “valueName”: “avg” }, { “columns”: [], “datasource”: “PostgreSQL”, “fontSize”: “90%”, “gridPos”: { “h”: 4, “w”: 24, “x”: 0, “y”: 4 }, “id”: 2, “links”: [], “pageSize”: null, “scroll”: true, “showHeader”: true, “sort”: { “col”: 0, “desc”: true }, “styles”: [ { “alias”: “Start”, “colorMode”: null, “colors”: [ “rgba(245, 54, 54, 0.9)”, “rgba(237, 129, 40, 0.89)”, “rgba(50, 172, 45, 0.97)” ], “dateFormat”: “DD-MM-YY HH:MM”, “decimals”: 2, “mappingType”: 1, “pattern”: “starttime”, “thresholds”: [], “type”: “date”, “unit”: “short” }, { “alias”: “Finish”, “colorMode”: null, “colors”: [ “rgba(245, 54, 54, 0.9)”, “rgba(237, 129, 40, 0.89)”, “rgba(50, 172, 45, 0.97)” ], “dateFormat”: “DD-MM-YY HH:MM”, “decimals”: 2, “mappingType”: 1, “pattern”: “endtime”, “thresholds”: [], “type”: “date”, “unit”: “short” }, { “alias”: “Bytes”, “colorMode”: null, “colors”: [ “rgba(245, 54, 54, 0.9)”, “rgba(237, 129, 40, 0.89)”, “rgba(50, 172, 45, 0.97)” ], “dateFormat”: “YYYY-MM-DD HH:mm:ss”, “decimals”: 2, “mappingType”: 1, “pattern”: “jobbytes”, “thresholds”: [], “type”: “number”, “unit”: “bytes” } ], “targets”: [ { “format”: “table”, “group”: [], “metricColumn”: “none”, “rawQuery”: true, “rawSql”: “select jobid, name, type, level, jobstatus, starttime, endtime, jobfiles, jobbytes from job where jobstatus=’f’ or jobstatus=’E’ order by jobid desc limit 200”, “refId”: “A”, “select”: [ [ { “params”: [ “value” ], “type”: “column” } ] ], “timeColumn”: “time”, “where”: [ { “name”: “$__timeFilter”, “params”: [], “type”: “macro” } ] } ], “timeFrom”: null, “timeShift”: null, “title”: “Recent Failed Jobs”, “transform”: “table”, “type”: “table” }, { “columns”: [], “datasource”: “PostgreSQL”, “fontSize”: “90%”, “gridPos”: { “h”: 4, “w”: 24, “x”: 0, “y”: 8 }, “id”: 3, “links”: [], “pageSize”: null, “scroll”: true, “showHeader”: true, “sort”: { “col”: null, “desc”: false }, “styles”: [ { “alias”: “Start”, “colorMode”: null, “colors”: [ “rgba(245, 54, 54, 0.9)”, “rgba(237, 129, 40, 0.89)”, “rgba(50, 172, 45, 0.97)” ], “dateFormat”: “DD-MM-YY HH:MM”, “decimals”: 2, “mappingType”: 1, “pattern”: “starttime”, “thresholds”: [], “type”: “date”, “unit”: “short” }, { “alias”: “Finish”, “colorMode”: null, “colors”: [ “rgba(245, 54, 54, 0.9)”, “rgba(237, 129, 40, 0.89)”, “rgba(50, 172, 45, 0.97)” ], “dateFormat”: “DD-MM-YY HH:MM”, “decimals”: 2, “mappingType”: 1, “pattern”: “endtime”, “thresholds”: [], “type”: “date”, “unit”: “short” }, { “alias”: “Bytes”, “colorMode”: null, “colors”: [ “rgba(245, 54, 54, 0.9)”, “rgba(237, 129, 40, 0.89)”, “rgba(50, 172, 45, 0.97)” ], “dateFormat”: “YYYY-MM-DD HH:mm:ss”, “decimals”: 2, “mappingType”: 1, “pattern”: “jobbytes”, “thresholds”: [], “type”: “number”, “unit”: “bytes” } ], “targets”: [ { “format”: “table”, “group”: [], “metricColumn”: “none”, “rawQuery”: true, “rawSql”: “select jobid, name, type, level, jobstatus, starttime, endtime, jobfiles, jobbytes from job order by jobid desc limit 200”, “refId”: “A”, “select”: [ [ { “params”: [ “value” ], “type”: “column” } ] ], “timeColumn”: “time”, “where”: [ { “name”: “$__timeFilter”, “params”: [], “type”: “macro” } ] } ], “timeFrom”: null, “timeShift”: null, “title”: “Recent Successful Jobs”, “transform”: “table”, “type”: “table” } ], “refresh”: “30s”, “schemaVersion”: 18, “style”: “dark”, “tags”: [], “templating”: { “list”: [] }, “time”: { “from”: “now-6h”, “to”: “now” }, “timepicker”: { “refresh_intervals”: [ “5s”, “10s”, “30s”, “1m”, “5m”, “15m”, “30m”, “1h”, “2h”, “1d” ], “time_options”: [ “5m”, “15m”, “1h”, “6h”, “12h”, “24h”, “2d”, “7d”, “30d” ] }, “timezone”: “”, “title”: “Bacula”, “uid”: “8AA_F8kZz”, “version”: 32 }