Jump to content

Wupsje

Members
  • Content Count

    59
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by Wupsje

  1. Wupsje

    Grafana and Labtech

    { "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, "hideControls": true, "id": 12, "links": [], "refresh": false, "rows": [ { "collapse": false, "height": "25px", "panels": [ { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "labtech", "editable": true, "error": false, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "id": 1, "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" } ], "span": 4, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "count(*)", "targets": [ { "alias": "", "dsType": "sqldb", "format": "table", "groupBy": [], "hide": false, "query": "SELECT count(*) FROM labtech.computers", "rawQuery": true, "rawSql": "SELECT count(*) FROM labtech.computers", "refId": "A", "resultFormat": "time_series", "schema": "labtech", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" } ], "thresholds": "", "title": "Agents", "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "null" } ], "valueName": "avg" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "labtech", "editable": true, "error": false, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "id": 9, "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" } ], "span": 4, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "COUNT(*)", "targets": [ { "alias": "", "dsType": "sqldb", "format": "table", "groupBy": [], "hide": false, "query": "SELECT COUNT(*) FROM computers WHERE $timeFilter", "rawQuery": true, "rawSql": "SELECT COUNT(*) FROM computers\r\nWHERE $__timeFilter(DateAdded)", "refId": "A", "resultFormat": "time_series", "schema": "labtech", "table": "Computers", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "DateAdded", "timeColDataType": "DateAdded : datetime", "timeDataType": "datetime" } ], "thresholds": "", "title": "Agents Added", "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "null" } ], "valueName": "avg" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "labtech", "editable": true, "error": false, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "id": 2, "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" } ], "span": 4, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "COUNT(*)", "targets": [ { "alias": "", "dsType": "sqldb", "format": "table", "groupBy": [], "hide": false, "query": "SELECT COUNT(*) FROM clients", "rawQuery": true, "rawSql": "SELECT COUNT(*) FROM clients", "refId": "A", "resultFormat": "time_series", "schema": "labtech", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" } ], "thresholds": "", "title": "Clients", "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "null" } ], "valueName": "avg" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "labtech", "editable": true, "error": false, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "id": 14, "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" } ], "span": 4, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "Patch Attempts", "targets": [ { "alias": "", "dsType": "sqldb", "format": "table", "groupBy": [], "hide": false, "query": "SELECT COUNT(DISTINCT computerid) AS 'Patch Attempts' FROM commands WHERE command = 100 AND `status` = 3 AND output LIKE '%downloaded and installed successfully%' AND dateupdated >=CURDATE()", "rawQuery": true, "rawSql": "SELECT COUNT(DISTINCT computerid) AS 'Patch Attempts' FROM commands WHERE command = 100 AND `status` = 3 AND output LIKE '%downloaded and installed successfully%' AND dateupdated >=CURDATE()", "refId": "A", "resultFormat": "time_series", "schema": "labtech", "table": "Computers", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "DateAdded", "timeColDataType": "DateAdded : datetime", "timeDataType": "datetime" } ], "thresholds": "", "title": "Succesful patches today", "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "null" } ], "valueName": "avg" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "labtech", "editable": true, "error": false, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "id": 13, "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" } ], "span": 4, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "Patch Attempts", "targets": [ { "alias": "", "dsType": "sqldb", "format": "table", "groupBy": [], "hide": false, "query": "SELECT COUNT(DISTINCT computerid) AS 'Patch Attempts' FROM commands WHERE command = 100 AND `status` = 3 AND dateupdated >=CURDATE()", "rawQuery": true, "rawSql": "SELECT COUNT(DISTINCT computerid) AS 'Patch Attempts' FROM commands WHERE command = 100 AND `status` = 3 AND dateupdated >=CURDATE()", "refId": "A", "resultFormat": "time_series", "schema": "labtech", "table": "Computers", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "DateAdded", "timeColDataType": "DateAdded : datetime", "timeDataType": "datetime" } ], "thresholds": "", "title": "Patch attempts today", "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "null" } ], "valueName": "avg" } ], "repeat": null, "repeatIteration": null, "repeatRowId": null, "showTitle": false, "title": "Agents & Clients", "titleSize": "h6" }, { "collapse": false, "height": "150px", "panels": [ { "aliasColors": { "Kristian": "#967302" }, "cacheTimeout": null, "combine": { "label": "Others", "threshold": 0 }, "datasource": "labtech", "editable": true, "error": false, "fontSize": "60%", "format": "short", "id": 11, "interval": null, "legend": { "percentage": true, "show": true, "sortDesc": true, "values": true }, "legendType": "Right side", "links": [], "maxDataPoints": 3, "nullPointMode": "connected", "pieType": "pie", "span": 4, "strokeWidth": "1", "targets": [ { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT count(TicketID) As 'xxx' FROM labtech.ticketdata WHERE DataType = '6' AND UserID = '4' AND $timeFilter ORDER BY count(TicketID)", "rawQuery": true, "rawSql": "SELECT \ncount(TicketID) As value,\n'xxx' as metric,\nIFNULL(UNIX_TIMESTAMP(TicketDataDate), UNIX_TIMESTAMP(NOW())) AS time_sec\nFROM labtech.ticketdata \nWHERE DataType = '6' AND UserID = '4' \nAND $__timeFilter(TicketDataDate)", "refId": "A", "resultFormat": "time_series", "schema": "labtech", "table": "ticketdata", "tags": [ { "key": "DataType", "operator": "=", "value": "6" }, { "condition": "AND", "key": "UserID", "operator": "=", "value": "4" } ], "targetLists": [ [ { "params": [ "TicketID" ], "type": "field" }, { "params": [], "type": "count" } ] ], "timeCol": "TicketDataDate", "timeColDataType": "TicketDataDate : timestamp", "timeDataType": "timestamp" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT count(TicketID) As 'xxx' FROM labtech.ticketdata WHERE DataType = '6' AND UserID = '9' AND $timeFilter ORDER BY count(TicketID)", "rawQuery": true, "rawSql": "SELECT \ncount(TicketID) As value,\n'xxx' as metric,\nIFNULL(UNIX_TIMESTAMP(TicketDataDate), UNIX_TIMESTAMP(NOW())) AS time_sec\nFROM labtech.ticketdata \nWHERE DataType = '6' AND UserID = '9' \nAND $__timeFilter(TicketDataDate)", "refId": "B", "resultFormat": "time_series", "schema": "labtech", "table": "ticketdata", "tags": [ { "key": "DataType", "operator": "=", "value": "6" }, { "condition": "AND", "key": "UserID", "operator": "=", "value": "4" } ], "targetLists": [ [ { "params": [ "TicketID" ], "type": "field" }, { "params": [], "type": "count" } ] ], "timeCol": "TicketDataDate", "timeColDataType": "TicketDataDate : timestamp", "timeDataType": "timestamp" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT count(TicketID) As 'xxx' FROM labtech.ticketdata WHERE DataType = '6' AND UserID = '10' AND $timeFilter ORDER BY count(TicketID)", "rawQuery": true, "rawSql": "SELECT \ncount(TicketID) As value,\n'xxx' as metric,\nIFNULL(UNIX_TIMESTAMP(TicketDataDate), UNIX_TIMESTAMP(NOW())) AS time_sec\nFROM labtech.ticketdata \nWHERE DataType = '6' AND UserID = '24' \nAND $__timeFilter(TicketDataDate)", "refId": "C", "resultFormat": "time_series", "schema": "labtech", "table": "ticketdata", "tags": [ { "key": "DataType", "operator": "=", "value": "6" }, { "condition": "AND", "key": "UserID", "operator": "=", "value": "4" } ], "targetLists": [ [ { "params": [ "TicketID" ], "type": "field" }, { "params": [], "type": "count" } ] ], "timeCol": "TicketDataDate", "timeColDataType": "TicketDataDate : timestamp", "timeDataType": "timestamp" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT count(TicketID) As 'xxx' FROM labtech.ticketdata WHERE DataType = '6' AND UserID = '14' AND $timeFilter ORDER BY count(TicketID)", "rawQuery": true, "rawSql": "SELECT \ncount(TicketID) As value,\n'xxx' as metric,\nIFNULL(UNIX_TIMESTAMP(TicketDataDate), UNIX_TIMESTAMP(NOW())) AS time_sec\nFROM labtech.ticketdata \nWHERE DataType = '6' AND UserID = '33' \nAND $__timeFilter(TicketDataDate)\n", "refId": "D", "resultFormat": "time_series", "schema": "labtech", "table": "ticketdata", "tags": [ { "key": "DataType", "operator": "=", "value": "6" }, { "condition": "AND", "key": "UserID", "operator": "=", "value": "4" } ], "targetLists": [ [ { "params": [ "TicketID" ], "type": "field" }, { "params": [], "type": "count" } ] ], "timeCol": "TicketDataDate", "timeColDataType": "TicketDataDate : timestamp", "timeDataType": "timestamp" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT count(TicketID) As 'xxx' FROM labtech.ticketdata WHERE DataType = '6' AND UserID = '24' AND $timeFilter ORDER BY count(TicketID)", "rawQuery": true, "rawSql": "SELECT \ncount(TicketID) As value,\n'xxx' as metric,\nIFNULL(UNIX_TIMESTAMP(TicketDataDate), UNIX_TIMESTAMP(NOW())) AS time_sec\nFROM labtech.ticketdata \nWHERE DataType = '6' AND UserID = '44' \nAND $__timeFilter(TicketDataDate)\n", "refId": "E", "resultFormat": "time_series", "schema": "labtech", "table": "ticketdata", "tags": [ { "key": "DataType", "operator": "=", "value": "6" }, { "condition": "AND", "key": "UserID", "operator": "=", "value": "4" } ], "targetLists": [ [ { "params": [ "TicketID" ], "type": "field" }, { "params": [], "type": "count" } ] ], "timeCol": "TicketDataDate", "timeColDataType": "TicketDataDate : timestamp", "timeDataType": "timestamp" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT count(TicketID) As 'xxx' FROM labtech.ticketdata WHERE DataType = '6' AND UserID = '33' AND $timeFilter ORDER BY count(TicketID)", "rawQuery": true, "rawSql": "SELECT \ncount(TicketID) As value,\n'xxx' as metric,\nIFNULL(UNIX_TIMESTAMP(TicketDataDate), UNIX_TIMESTAMP(NOW())) AS time_sec\nFROM labtech.ticketdata \nWHERE DataType = '6' AND UserID = '42' \nAND $__timeFilter(TicketDataDate)", "refId": "F", "resultFormat": "time_series", "schema": "labtech", "table": "ticketdata", "tags": [ { "key": "DataType", "operator": "=", "value": "6" }, { "condition": "AND", "key": "UserID", "operator": "=", "value": "4" } ], "targetLists": [ [ { "params": [ "TicketID" ], "type": "field" }, { "params": [], "type": "count" } ] ], "timeCol": "TicketDataDate", "timeColDataType": "TicketDataDate : timestamp", "timeDataType": "timestamp" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT count(TicketID) As 'xxx' FROM labtech.ticketdata WHERE DataType = '6' AND UserID = '35' AND $timeFilter ORDER BY count(TicketID)", "rawQuery": true, "rawSql": "SELECT \ncount(TicketID) As value,\n'xxx' as metric,\nIFNULL(UNIX_TIMESTAMP(TicketDataDate), UNIX_TIMESTAMP(NOW())) AS time_sec\nFROM labtech.ticketdata \nWHERE DataType = '6' AND UserID = '21' \nAND $__timeFilter(TicketDataDate)\n", "refId": "G", "resultFormat": "time_series", "schema": "labtech", "table": "ticketdata", "tags": [ { "key": "DataType", "operator": "=", "value": "6" }, { "condition": "AND", "key": "UserID", "operator": "=", "value": "4" } ], "targetLists": [ [ { "params": [ "TicketID" ], "type": "field" }, { "params": [], "type": "count" } ] ], "timeCol": "TicketDataDate", "timeColDataType": "TicketDataDate : timestamp", "timeDataType": "timestamp" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": true, "query": "SELECT count(TicketID) As 'xxx' FROM labtech.ticketdata WHERE DataType = '6' AND UserID = '44' AND $timeFilter ORDER BY count(TicketID)", "rawQuery": true, "rawSql": "SELECT\n UNIX_TIMESTAMP(<time_column>) as time_sec,\n <value column> as value,\n <series name column> as metric\nFROM <table name>\nWHERE $__timeFilter(time_column)\nORDER BY <time_column> ASC\n", "refId": "H", "resultFormat": "time_series", "schema": "labtech", "table": "ticketdata", "tags": [ { "key": "DataType", "operator": "=", "value": "6" }, { "condition": "AND", "key": "UserID", "operator": "=", "value": "4" } ], "targetLists": [ [ { "params": [ "TicketID" ], "type": "field" }, { "params": [], "type": "count" } ] ], "timeCol": "TicketDataDate", "timeColDataType": "TicketDataDate : timestamp", "timeDataType": "timestamp" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": true, "query": "SELECT count(TicketID) as 'xxx' FROM labtech.ticketdata WHERE DataType = '6' AND UserID = '43' AND $timeFilter ORDER BY count(TicketID)", "rawQuery": true, "rawSql": "SELECT\n UNIX_TIMESTAMP(<time_column>) as time_sec,\n <value column> as value,\n <series name column> as metric\nFROM <table name>\nWHERE $__timeFilter(time_column)\nORDER BY <time_column> ASC\n", "refId": "I", "resultFormat": "time_series", "schema": "labtech", "table": "ticketdata", "tags": [ { "key": "DataType", "operator": "=", "value": "6" }, { "condition": "AND", "key": "UserID", "operator": "=", "value": "4" } ], "targetLists": [ [ { "params": [ "TicketID" ], "type": "field" }, { "params": [], "type": "count" } ] ], "timeCol": "TicketDataDate", "timeColDataType": "TicketDataDate : timestamp", "timeDataType": "timestamp" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": true, "query": "SELECT count(TicketID) as 'xxx' FROM labtech.ticketdata WHERE DataType = '6' AND UserID = '42' AND $timeFilter ORDER BY count(TicketID)", "rawQuery": true, "rawSql": "SELECT\n UNIX_TIMESTAMP(<time_column>) as time_sec,\n <value column> as value,\n <series name column> as metric\nFROM <table name>\nWHERE $__timeFilter(time_column)\nORDER BY <time_column> ASC\n", "refId": "J", "resultFormat": "time_series", "schema": "labtech", "table": "ticketdata", "tags": [ { "key": "DataType", "operator": "=", "value": "6" }, { "condition": "AND", "key": "UserID", "operator": "=", "value": "4" } ], "targetLists": [ [ { "params": [ "TicketID" ], "type": "field" }, { "params": [], "type": "count" } ] ], "timeCol": "TicketDataDate", "timeColDataType": "TicketDataDate : timestamp", "timeDataType": "timestamp" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": true, "query": "SELECT count(TicketID) as 'xxx' FROM labtech.ticketdata WHERE DataType = '6' AND UserID = '21' AND $timeFilter ORDER BY count(TicketID)", "rawQuery": true, "rawSql": "SELECT\n UNIX_TIMESTAMP(<time_column>) as time_sec,\n <value column> as value,\n <series name column> as metric\nFROM <table name>\nWHERE $__timeFilter(time_column)\nORDER BY <time_column> ASC\n", "refId": "K", "resultFormat": "time_series", "schema": "labtech", "table": "ticketdata", "tags": [ { "key": "DataType", "operator": "=", "value": "6" }, { "condition": "AND", "key": "UserID", "operator": "=", "value": "4" } ], "targetLists": [ [ { "params": [ "TicketID" ], "type": "field" }, { "params": [], "type": "count" } ] ], "timeCol": "TicketDataDate", "timeColDataType": "TicketDataDate : timestamp", "timeDataType": "timestamp" } ], "title": "Tickets Finished", "transparent": false, "type": "grafana-piechart-panel", "valueName": "current" }, { "aliasColors": {}, "cacheTimeout": null, "combine": { "label": "Others", "threshold": 0 }, "datasource": "labtech", "editable": true, "error": false, "fontSize": "80%", "format": "short", "id": 6, "interval": null, "legend": { "percentage": true, "show": true, "values": true }, "legendType": "Right side", "links": [], "maxDataPoints": 3, "nullPointMode": "connected", "pieType": "pie", "span": 4, "strokeWidth": "1", "targets": [ { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT COUNT(*) as \"New\" FROM tickets WHERE STATUS = 1", "rawQuery": true, "rawSql": "SELECT \n IFNULL(UNIX_TIMESTAMP(StartedDate), UNIX_TIMESTAMP(NOW())) AS time_sec,\n COUNT(*) as value,\n 'New' as metric\nFROM tickets \nWHERE STATUS = 1\nAND $__timeFilter(StartedDate)", "refId": "A", "resultFormat": "time_series", "schema": "labtech", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" }, { "alias": "", "format": "time_series", "hide": false, "rawSql": "SELECT \n IFNULL(UNIX_TIMESTAMP(StartedDate), UNIX_TIMESTAMP(NOW())) AS time_sec,\n COUNT(*) as value,\n 'Open' as metric\nFROM tickets \nWHERE STATUS = 2\nAND $__timeFilter(StartedDate)", "refId": "B" }, { "alias": "", "format": "time_series", "hide": false, "rawSql": "SELECT \n IFNULL(UNIX_TIMESTAMP(StartedDate), UNIX_TIMESTAMP(NOW())) AS time_sec,\n COUNT(*) as value,\n 'Stalled' as metric\nFROM tickets \nWHERE STATUS = 3\nAND $__timeFilter(StartedDate)", "refId": "C" } ], "timeShift": null, "title": "Tickets", "transparent": false, "type": "grafana-piechart-panel", "valueName": "current" }, { "aliasColors": { "Geen": "#CFFAFF", "Prio 2 - Critical": "#BF1B00", "Prio 4 - Normal": "#508642", "Prio 5 - Low": "#967302", "automated": "#447EBC" }, "cacheTimeout": null, "combine": { "label": "Others", "threshold": 0 }, "datasource": "labtech", "editable": true, "error": false, "fontSize": "80%", "format": "short", "hideTimeOverride": false, "id": 10, "interval": null, "legend": { "percentage": true, "show": true, "sortDesc": true, "values": true }, "legendType": "Right side", "links": [], "maxDataPoints": 3, "nullPointMode": "connected", "pieType": "pie", "span": 4, "strokeWidth": 1, "targets": [ { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT COUNT(*) AS Geen FROM tickets WHERE STATUS IN (1,2,3) AND (Priority = 2)", "rawQuery": true, "rawSql": "SELECT \r\n IFNULL(UNIX_TIMESTAMP(StartedDate), UNIX_TIMESTAMP(NOW())) AS time_sec,\r\n COUNT(*) AS VALUE,\r\n 'Geen' AS metric\r\nFROM tickets \r\nWHERE STATUS IN (1,2,3) AND (Priority = 2)", "refId": "A", "resultFormat": "time_series", "schema": "labtech", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT COUNT(*) AS 'Prio 5 - Low' FROM tickets WHERE STATUS IN (1,2,3) AND (Priority = 4)", "rawQuery": true, "rawSql": "SELECT \n IFNULL(UNIX_TIMESTAMP(StartedDate), UNIX_TIMESTAMP(NOW())) AS time_sec,\n COUNT(*) as value,\n 'Prio 5 - Low' as metric\nFROM tickets\nWHERE STATUS IN (1,2,3) AND (Priority = 4)\nAND $__timeFilter(StartedDate)", "refId": "B", "resultFormat": "time_series", "schema": "labtech", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "query": "SELECT COUNT(*) AS 'Prio 4 - Normal' FROM tickets WHERE STATUS IN (1,2,3) AND (Priority = 10)", "rawQuery": true, "rawSql": "SELECT \n IFNULL(UNIX_TIMESTAMP(StartedDate), UNIX_TIMESTAMP(NOW())) AS time_sec,\n COUNT(*) as value,\n 'Prio 4 - Normal' as metric\nFROM tickets\nWHERE STATUS IN (1,2,3) AND (Priority = 10)\nAND $__timeFilter(StartedDate)", "refId": "C", "resultFormat": "time_series", "schema": "labtech", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT COUNT(*) AS 'Prio 3 - High' FROM tickets WHERE STATUS IN (1,2,3) AND (Priority = 14)", "rawQuery": true, "rawSql": "SELECT \n IFNULL(UNIX_TIMESTAMP(StartedDate), UNIX_TIMESTAMP(NOW())) AS time_sec,\n COUNT(*) as value,\n 'Prio 3 - High' as metric\nFROM tickets\nWHERE STATUS IN (1,2,3) AND (Priority = 14)\nAND $__timeFilter(StartedDate)\n", "refId": "D", "resultFormat": "time_series", "schema": "labtech", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT COUNT(*) AS 'Prio 1 - Emergency' FROM tickets WHERE STATUS IN (1,2,3) AND (Priority = 19)", "rawQuery": true, "rawSql": "SELECT \n IFNULL(UNIX_TIMESTAMP(StartedDate), UNIX_TIMESTAMP(NOW())) AS time_sec,\n COUNT(*) as value,\n 'Prio 1 - Emergency' as metric\nFROM tickets\nWHERE STATUS IN (1,2,3) AND (Priority = 19)\nAND $__timeFilter(StartedDate)\n", "refId": "E", "resultFormat": "time_series", "schema": "labtech", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT COUNT(*) AS 'Prio 2 - Critical' FROM tickets WHERE STATUS IN (1,2,3) AND (Priority = 17)", "rawQuery": true, "rawSql": "SELECT \n IFNULL(UNIX_TIMESTAMP(StartedDate), UNIX_TIMESTAMP(NOW())) AS time_sec,\n COUNT(*) as value,\n 'Prio 2 - Critical' as metric\nFROM tickets\nWHERE STATUS IN (1,2,3) AND (Priority = 17)\nAND $__timeFilter(StartedDate)\n", "refId": "F", "resultFormat": "time_series", "schema": "labtech", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" }, { "alias": "", "dsType": "sqldb", "format": "time_series", "groupBy": [], "hide": false, "query": "SELECT COUNT(*) AS 'automated' FROM tickets WHERE STATUS IN (1,2,3) AND (Priority = 5)", "rawQuery": true, "rawSql": "SELECT \n IFNULL(UNIX_TIMESTAMP(StartedDate), UNIX_TIMESTAMP(NOW())) AS time_sec,\n COUNT(*) as value,\n 'Automatec' as metric\nFROM tickets\nWHERE STATUS IN (1,2,3) AND (Priority = 5)\nAND $__timeFilter(StartedDate)", "refId": "G", "resultFormat": "time_series", "schema": "labtech", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" } ], "title": "Ticket Priority", "transparent": false, "type": "grafana-piechart-panel", "valueName": "current" }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "labtech", "decimals": 0, "editable": true, "error": false, "fill": 1, "grid": {}, "height": "200", "hideTimeOverride": false, "id": 5, "interval": "60s", "legend": { "alignAsTable": false, "avg": false, "current": false, "hideEmpty": false, "hideZero": false, "max": false, "min": false, "rightSide": false, "show": true, "sideWidth": 25, "total": false, "values": false }, "lines": true, "linewidth": 2, "links": [ { "type": "dashboard" } ], "nullPointMode": "connected", "percentage": false, "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [ { "alias": "Tickets Closed", "yaxis": 1 } ], "spaceLength": 10, "span": 10, "stack": false, "steppedLine": false, "targets": [ { "alias": "", "format": "time_series", "hide": true, "rawSql": "SELECT\r\n UNIX_TIMESTAMP(StartedDate) AS time_sec,\r\n COUNT(TicketID) AS value,\r\n \"Tickets Created\" AS metric\r\nFROM labtech.tickets\r\nWHERE STATUS IN (1,2)\r\nAND $__timeFilter(StartedDate)\r\nGROUP BY UNIX_TIMESTAMP(StartedDate)\r\nORDER BY StartedDate ASC\r\n", "refId": "B" }, { "alias": "", "format": "time_series", "hide": true, "rawSql": "SELECT\n UNIX_TIMESTAMP(UpdateDate) AS time_sec,\n COUNT(TicketID) AS value,\n \"Tickets Closed\" AS metric\nFROM labtech.tickets\nWHERE STATUS = 4\nAND $__timeFilter(UpdateDate)\nGROUP BY UNIX_TIMESTAMP(UpdateDate)\nORDER BY UpdateDate ASC\n", "refId": "D" }, { "alias": "", "format": "time_series", "hide": false, "rawSql": "CALL generate_series_date_minute_base($__timeFrom(), $__timeTo(), 5);", "refId": "A" }, { "alias": "", "format": "time_series", "rawSql": "SELECT UNIX_TIMESTAMP(series_tmp.series) as time_sec, IFNULL(tmp.Cnt,0) as value, \"Tickets Created\" AS metric FROM series_tmp\nLEFT JOIN (\nSELECT COUNT(*) AS Cnt, FROM_UNIXTIME(FLOOR(UNIX_TIMESTAMP(tickets.StartedDate)/300)*300) AS datum FROM labtech.tickets\nWHERE tickets.STATUS IN (1,2)\nGROUP BY 2\n) tmp ON tmp.Datum = series_tmp.series\nGROUP BY series_tmp.series;\n", "refId": "C" }, { "alias": "", "format": "time_series", "rawSql": "SELECT UNIX_TIMESTAMP(series_tmp.series) as time_sec, IFNULL(tmp.Cnt,0) as value, \"Tickets Closed\" AS metric FROM series_tmp\nLEFT JOIN (\nSELECT COUNT(*) AS Cnt, FROM_UNIXTIME(FLOOR(UNIX_TIMESTAMP(tickets.StartedDate)/300)*300) AS datum FROM labtech.tickets\nWHERE tickets.STATUS = 4\nGROUP BY 2\n) tmp ON tmp.Datum = series_tmp.series\nGROUP BY series_tmp.series;\n", "refId": "E" }, { "alias": "", "format": "time_series", "rawSql": "SELECT UNIX_TIMESTAMP(series_tmp.series) as time_sec, IFNULL(tmp.Cnt,0) as value, \"Tickets Combined\" AS metric FROM series_tmp\nLEFT JOIN (\nSELECT COUNT(*) AS Cnt, FROM_UNIXTIME(FLOOR(UNIX_TIMESTAMP(tickets.StartedDate)/300)*300) AS datum FROM labtech.tickets\nWHERE tickets.STATUS = 6\nGROUP BY 2\n) tmp ON tmp.Datum = series_tmp.series\nGROUP BY series_tmp.series;\n", "refId": "F" } ], "thresholds": [ { "colorMode": "custom", "fill": true, "fillColor": "rgb(248, 214, 110)", "line": true, "lineColor": "rgb(233, 188, 188)", "op": "lt", "value": null } ], "timeFrom": null, "timeShift": null, "title": "Tickets", "tooltip": { "msResolution": true, "shared": true, "sort": 0, "value_type": "cumulative" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": false } ] }, { "columns": [], "datasource": "labtech", "editable": true, "error": false, "fontSize": "80%", "id": 12, "links": [], "pageSize": 200, "scroll": false, "showHeader": true, "sort": { "col": 1, "desc": true }, "span": 2, "styles": [ { "colorMode": "row", "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": 1, "pattern": "/.*/", "thresholds": [ "3", "6" ], "type": "number", "unit": "short" } ], "targets": [ { "alias": "", "dsType": "sqldb", "format": "table", "groupBy": [], "hide": false, "query": "SELECT Users.Name AS Engineer, ((SUM(hours)*60)+SUM(mins))/60 AS Hours FROM (timeslips LEFT JOIN timecategory ON timecategory.id=timeslips.category) LEFT JOIN users ON users.userid=timeslips.userid WHERE (timeslips.Date > CURDATE()) GROUP BY timeslips.userid ORDER BY Hours DESC", "rawQuery": true, "rawSql": "SELECT Users.Name AS Engineer, ((SUM(hours)*60)+SUM(mins))/60 AS hours\nFROM (timeslips LEFT JOIN timecategory ON timecategory.id=timeslips.category)\nLEFT JOIN users ON users.userid=timeslips.userid\nWHERE (timeslips.Date > CURDATE()) \nGROUP BY timeslips.userid \nORDER BY Hours DESC", "refId": "A", "resultFormat": "table", "schema": "labtech", "table": "timeslips", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" } ], "title": "Labtech Timeslips", "transform": "table", "type": "table" } ], "repeat": null, "repeatIteration": null, "repeatRowId": null, "showTitle": false, "title": "Tickets", "titleSize": "h6" }, { "collapse": false, "height": "450px", "panels": [ { "columns": [], "datasource": "labtech", "editable": true, "error": false, "fontSize": "80%", "hideTimeOverride": true, "id": 7, "links": [], "pageSize": null, "scroll": true, "showHeader": true, "sort": { "col": 6, "desc": true }, "span": 6, "styles": [ { "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": 0, "pattern": "TicketID", "sanitize": false, "thresholds": [], "type": "string", "unit": "short" }, { "colorMode": "cell", "colors": [ "rgba(50, 172, 45, 0.97)", "rgba(237, 129, 40, 0.89)", "rgba(245, 54, 54, 0.9)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "pattern": "Looptijd", "thresholds": [ "8", "16" ], "type": "number", "unit": "none" } ], "targets": [ { "alias": "", "dsType": "sqldb", "format": "table", "groupBy": [], "hide": false, "query": "SELECT Tickets.TicketID , Users.Name AS Engineer, Clients.Name AS CLIENT , TicketPriority.Name AS Priority, infocategory.CategoryName AS Categorie, Tickets.Subject, IF (elapsed_working_hours(TD1.TicketDataDate, TD3.TicketDataDate) IS NULL, elapsed_working_hours(TD1.TicketDataDate,NOW()), elapsed_working_hours(TD1.TicketDataDate, TD3.TicketDataDate)) AS Looptijd FROM Tickets LEFT JOIN TicketData TD1 ON TD1.TicketDataID = (SELECT MIN(TD.TicketDataID) FROM TicketData TD WHERE (Tickets.TicketID = TD.TicketID) AND (TD.DataType = 1)) LEFT JOIN TicketData TD3 ON TD3.TicketDataID = (SELECT MAX(TD.TicketDataID) FROM TicketData TD WHERE (Tickets.TicketID = TD.TicketID) AND (TD.DataType = 6)) LEFT JOIN Users ON Tickets.userID = Users.UserID LEFT JOIN Clients ON Clients.ClientID = Tickets.ClientID LEFT JOIN TicketPriority ON TicketPriority.Priority = Tickets.Priority LEFT JOIN infocategory ON infocategory.ID = Tickets.Category WHERE (Tickets.Status IN (2,3)) AND (infocategory.id IN (159, 160, 165, 166)) ORDER BY Looptijd DESC LIMIT 5", "rawQuery": true, "rawSql": "SELECT Tickets.TicketID , Users.Name AS Engineer, Clients.Name AS CLIENT , TicketPriority.Name AS Priority, infocategory.CategoryName AS Categorie, Tickets.Subject, IF (elapsed_working_hours(TD1.TicketDataDate, TD3.TicketDataDate) IS NULL, elapsed_working_hours(TD1.TicketDataDate,NOW()), elapsed_working_hours(TD1.TicketDataDate, TD3.TicketDataDate)) AS Looptijd FROM Tickets LEFT JOIN TicketData TD1 ON TD1.TicketDataID = (SELECT MIN(TD.TicketDataID) FROM TicketData TD WHERE (Tickets.TicketID = TD.TicketID) AND (TD.DataType = 1)) LEFT JOIN TicketData TD3 ON TD3.TicketDataID = (SELECT MAX(TD.TicketDataID) FROM TicketData TD WHERE (Tickets.TicketID = TD.TicketID) AND (TD.DataType = 6)) LEFT JOIN Users ON Tickets.userID = Users.UserID LEFT JOIN Clients ON Clients.ClientID = Tickets.ClientID LEFT JOIN TicketPriority ON TicketPriority.Priority = Tickets.Priority LEFT JOIN infocategory ON infocategory.ID = Tickets.Category WHERE (Tickets.Status IN (2,3)) AND (infocategory.id IN (159, 160, 165, 166)) ORDER BY Looptijd DESC LIMIT 5", "refId": "A", "resultFormat": "table", "schema": "labtech", "table": "tickets", "tags": [], "targetLists": [ [ { "params": [ "*" ], "type": "field" } ] ], "timeCol": "time", "timeColDataType": "time : type", "timeDataType": "type" } ], "title": "Lopende support tickets", "transform": "table", "transparent": true, "type": "table" }, { "columns": [], "datasource": "labtech", "editable": true, "error": false, "fontSize": "100%", "id": 8, "links": [], "pageSize": null, "scroll": true, "showHeader": true, "sort": { "col": 3, "desc": false }, "span": 6, "styles": [ { "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, "pattern": "computerid", "sanitize": false, "thresholds": [], "type": "string", "unit": "short" }, { "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, "pattern": "Last contact", "thresholds": [], "type": "date", "unit": "short" } ], "targets": [ { "alias": "", "dsType": "sqldb", "format": "table", "groupBy": [], "hide": false, "query": "SELECT computers.computerid,computers.Name AS ComputerName,CONVERT(CONCAT(clients.name,' - ',locations.name) USING utf8) AS Location, computers.`LastContact` AS 'Last contact' FROM (computers LEFT JOIN Locations ON Locations.LocationID=computers.Locationid) LEFT JOIN Clients ON Clients.ClientID=Computers.clientid JOIN AgentComputerData ON Computers.ComputerID=AgentComputerData.ComputerID WHERE computers.`LastContact` < DATE_ADD(NOW(),INTERVAL -7 MINUTE) AND ((Computers.OS LIKE '%server%' OR Computers.OS LIKE '%linux%' )) ORDER BY LastContact DESC", "rawQuery": true, "rawSql": "SELECT computers.computerid,computers.Name AS ComputerName,CONVERT(CONCAT(clients.name,' - ',locations.name) USING utf8) AS Location, computers.`LastContact` AS 'Last contact' FROM (computers LEFT JOIN Locations ON Locations.LocationID=computers.Locationid) LEFT JOIN Clients ON Clients.ClientID=Computers.clientid JOIN AgentComputerData ON Computers.ComputerID=AgentComputerData.ComputerID WHERE computers.`LastContact` < DATE_ADD(NOW(),INTERVAL -7 MINUTE) AND ((Computers.OS LIKE '%server%' OR Computers.OS LIKE '%linux%' )) ORDER BY LastContact DESC", "refId": "A", "resultFormat": "table", "schema": "labtech", "table": "computers", "tags": [ { "key": "LastContact", "operator": "<", "value": "date_add(now(),interval -7 minute)" }, { "condition": "AND", "key": "OS", "operator": "=", "value": "%server%" } ], "targetLists": [ [ { "params": [ "Name" ], "type": "field" } ] ], "timeCol": "LastContact", "timeColDataType": "LastContact : datetime", "timeDataType": "datetime" } ], "title": "Offline servers", "transform": "table", "transparent": true, "type": "table" } ], "repeat": null, "repeatIteration": null, "repeatRowId": null, "showTitle": false, "title": "Lopende Tickets + Offline Server", "titleSize": "h6" }, { "collapse": false, "height": "250px", "panels": [], "repeat": null, "repeatIteration": null, "repeatRowId": null, "showTitle": false, "title": "New row", "titleSize": "h6" } ], "schemaVersion": 14, "style": "dark", "tags": [], "templating": { "list": [] }, "time": { "from": "now/d", "to": "now" }, "timepicker": { "refresh_intervals": [ "5m", "15m", "30m", "1h" ], "time_options": [ "5m", "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d" ] }, "timezone": "browser", "title": "Labtech", "version": 21 }
  2. Wupsje

    Grafana and Labtech

    Been messing with my ticket timeseries. I was bothered that it didn't start at 0. I've been able to fix that: if you insert these into a time series it will display your closed and new/opened tickets correctly along the timeline. Make sure you do the call to the generate_series_date_minute_base on the first query (A).
  3. If i use SELECT TO_BASE64 in mysql i'm getting different results though. It seems LT somehow uses extra characters. When i decode this BASE64 string (MwB8ADAALgA1AHwARgBhAGwAcwBlAHwAMQAwAHwAMAB8AC0AfAAwAA==) i get : 3|0.5|False|10|0|-|0 But when i encode that again with base64 i get this back : M3wwLjV8RmFsc2V8MTB8MHwtfDA= What am i missing that LT is doing?
  4. We're having this issue too. the scripts don't seem to work (like DarrenWhite99 said). It's on the development board with CWA. no other updates yet...
  5. Hi Darren, Would you happen to know the SQL how to convert the result type from String to Numeric? It changes the DataIn in the agents table to something unreadable (PMI:MwB8ADAALgA1AHwARgBhAGwAcwBlAHwAMQAwAHwAMAB8AC0AfAAwAA==)
  6. That's a good idea! Tried that, but it seems the pipe sign is the field separator. I can't use it there.
  7. I've added Dutch and French to the Normal State. So that CWA can recognise that too. And the dutch to the error state. Still need to find a better way to do this..
  8. I looked but apparently we deleted this one. You can easily set it up yourself. you can either search and find the eventlog on the agent that it happened on. Right click it and select Create Event Monitor. Or you could create a monitor with the event id (39) and source iScsiPrt
  9. I think there is a eventid you could watch for that alerts on failed Scheduled tasks.
  10. Wupsje

    Linux - Monitor INODES

    You could setup an remote monitor that parses the df -i output and trigger above a certain percentage.
  11. You could either work this into an remote monitor or an internal monitor. your call. Those monitors you could setup through groups and searches. It's based on eventlogs that are being generated. I tink we setup an search that finds machines with the iscsi initiator installed and the service as automatic/running. And deploy eventlog remote monitor.
  12. Hi, I've posted the XML somewhere in this thread. You can import that. If the parameters give you any trouble. Just replace @paramater@ with a simple fixed value. That should do it.
  13. I'm unsure why it's not working for you. You could use replace that parameters with a fixed value.
  14. Hi, I've found and modified a powershell script that can output HTML and do roughly the same. You will need to setup an SMTP relay server, account and the appropriate email address. Parameters are optional, it will use defaults if you leave them blank. It will email a report. The body and attachment contain the tree sorted by size. If you open the attachment in a browser javascript will kick it to make it expandable. like so: Treesize (Email).xml
  15. Wupsje

    EV - Failed Logins* - making it usable?

    If you set an alert template that creates a ticket and has %RESULT% somewhere in to alert message on failure. you're set.
  16. It seems they (WR) might have a fix soon.. https://community.webroot.com/t5/Webroot-SecureAnywhere-Complete/Task-Manager/td-p/309032/page/14
  17. Wupsje

    File Server Active Ransomware Protection

    Nice, We've already had a working powershell in LT that downloads the filelist from that site. It's only alerting though. Never got around to scripting a SMB Block. Might implement that still.. although it's been quiet on the ransomware infection side recently *crosses fingers*
  18. Wupsje

    EV - Failed Logins* - making it usable?

    Sure, does this help you out? We're settings this on our groups so that it runs on all windows servers.
  19. Wupsje

    EV - Failed Logins* - making it usable?

    We're also using an remote monitor. Since eventlogs get cleared out quickly (DB size) and don't always work right. Offloading it to the remote agent works well. I've formatted the output so you group on anything (eg username, IP address, LogonType). We use this output in a ticket so we can have a technician deep dive into the system %windir%\System32\WindowsPowerShell\v1.0\powershell.exe "Get-EventLog -LogName 'Security' -InstanceId 4625 -After ([DateTime]::Now.AddDays(-1)) -ErrorAction SilentlyContinue | Select-Object TimeGenerated, @{Name='TargetUserName' ; Expression={$_.ReplacementStrings[5]} }, @{Name='WorkstationName' ; Expression={$_.ReplacementStrings[1] -replace '\$$'} }, @{Name='LogonType' ; Expression={$_.ReplacementStrings[10]}}, @{Name='IpAddress' ; Expression={$_.ReplacementStrings[-2]}}, @{Name='IpPort' ; Expression={$_.ReplacementStrings[-5]}} | Where-Object {$_.TargetUserName -ne $env:computername + '$' -and $_.TargetUserName -ne $env:computername -and $_.TargetUserName -ne '-' -and $_.TargetUserName -ne '@'} | Group-Object LogonType, TargetUserName | Where-Object {$_.Count -ge 30} | Sort-Object Count -Descending | FT Count, Name -autosize"
  20. Wupsje

    How to deploy Bios updates remotely in mass.

    Would be nice. We are doing it manually now...
  21. Wupsje

    How to deploy Bios updates remotely in mass.

    Anybody have to deal with HP laptops and desktops yet?
  22. Wupsje

    Let's Encrypt on Labtech Server

    I've done it manually on IIS outside of any wizard. renewal is handled by the ACMEclient through a scheduled task
  23. Wupsje

    Let's Encrypt on Labtech Server

    We've been using it for some time now. It has never failed yet.
  24. Wupsje

    Failed Logins - Brute Force

    Áre you looking for something like this?
×