Jump to content

Wupsje

Members
  • Content Count

    67
  • Joined

  • Last visited

  • Days Won

    3

Wupsje last won the day on June 10

Wupsje had the most liked content!

Community Reputation

6 Neutral

My Information

  • Agent Count
    1500+

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. here's a screenshot of our working monitor. make sure you change the groupid to the group that matches your azure backup agents
  2. I'm not sure. I think Office365 requires the use of TLS/SSL so uncomment that line ($SMTPClient.EnableSsl = $true ) But there's a reason why in don't use O365. It has started to require modern authentification on it's protocols. Therefor even if you get this to work now it will not work in the future. The right way to do it on office365 require an token with the right permissions setup.
  3. Hi Tevin, I use a free account from sparkpost to send emails (since it's next to impossible to always have a secure way to email from the client). You need to adjust the $CredUser, $CredPassword and $Message.From to reflect the settings in your own account. @EmailAddress@ is a labtech variable in the script that gets set to the email adres of the labtech engineer that executes the script. If you have a different SMTP server that accepts email, you could adjust the code to email through there.
  4. I use it like this I needed to remove trailing linefeed and carriage return otherwise line 5 wouldn't work. Then it's just downloading the file:
  5. Hi, here's the script that I use. It uses powershell to built an dynamic HTML of the path with the parameters specified. I use sparkpost to email it. Make sure you add/change the sparkpost & email in the bottom of the powershell script on step 17. Otherwise it will not email. Dynamic HTML doesn't work in outlook though so make sure you open it in a browser Treesize (Email).xml
  6. Small upadte. I had to rewrite the time series to round to 0 on 5 minute intervals. Otherwise the count would not work correctly anymore. I figure this has something todo with an update. i'm guessing grafana. This is what I now use on the A series the generate the right time series. CALL generate_series_date_minute_base(FROM_UNIXTIME((UNIX_TIMESTAMP($__timeFrom()) DIV 300) * 300), $__timeTo(), 5);
  7. Simple, Add an incoming webhook to the channel you wish to configure messages to. Save the URL so that you can use it in labtech scripting. If you script it like this you will be able to used the script in alerting. -command "Invoke-WebRequest -Method Post -Uri <INSERTURLHERE> -ContentType \"application/json\" -Body (ConvertTo-Json @{text=\"@myresult@\"} -Depth 3)"
  8. { "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 }
  9. 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).
  10. 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?
  11. 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...
  12. 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==)
  13. That's a good idea! Tried that, but it seems the pipe sign is the field separator. I can't use it there.
  14. 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..
×
×
  • Create New...