{ "__inputs": [ { "name": "DS_MICROSOFT_SQL SERVER", "label": "Microsoft SQL Server", "description": "", "type": "datasource", "pluginId": "mssql", "pluginName": "Microsoft SQL Server" } ], "__requires": [ { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "7.5.5" }, { "type": "panel", "id": "grafana-piechart-panel", "name": "Pie Chart", "version": "1.6.1" }, { "type": "datasource", "id": "mssql", "name": "Microsoft SQL Server", "version": "1.0.0" }, { "type": "panel", "id": "table", "name": "Table", "version": "" } ], "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": null, "links": [], "panels": [ { "aliasColors": {}, "breakPoint": "50%", "cacheTimeout": null, "combine": { "label": "Others", "threshold": 0 }, "datasource": "${DS_MICROSOFT_SQL SERVER}", "fieldConfig": { "defaults": {}, "overrides": [] }, "fontSize": "80%", "format": "short", "gridPos": { "h": 12, "w": 24, "x": 0, "y": 0 }, "hideTimeOverride": false, "id": 4, "interval": null, "legend": { "percentage": true, "show": true, "sideWidth": null, "sort": "total", "sortDesc": true, "values": true }, "legendType": "Right side", "links": [], "maxDataPoints": 3, "nullPointMode": "connected", "pieType": "pie", "pluginVersion": "6.4.3", "strokeWidth": "0", "targets": [ { "alias": "", "format": "time_series", "rawSql": "SELECT\r\n $__timeEpoch(bpaa.eventdatetime),\r\n count(bpaa.sCode) as value,\r\n CC.Evento as metric\r\nFROM\r\n BPAAuditEvents bpaa (NOLOCK)\r\n INNER JOIN COE_sCode CC ON bpaa.sCode = CC.sCode\r\nWHERE\r\n $__timeFilter(eventdatetime)\r\nGROUP BY\r\nbpaa.sCode, bpaa.eventdatetime,CC.Evento\r\nORDER BY\r\n bpaa.eventdatetime DESC", "refId": "A" } ], "timeFrom": null, "timeShift": null, "title": "Eventos", "type": "grafana-piechart-panel", "valueName": "total" }, { "datasource": "${DS_MICROSOFT_SQL SERVER}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": null, "filterable": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "username" }, "properties": [ { "id": "unit", "value": "short" }, { "id": "decimals", "value": 2 }, { "id": "custom.align", "value": null }, { "id": "custom.width", "value": 76 } ] }, { "matcher": { "id": "byName", "options": "name" }, "properties": [ { "id": "displayName", "value": "Resource" }, { "id": "unit", "value": "short" }, { "id": "decimals", "value": 2 }, { "id": "custom.align", "value": null } ] }, { "matcher": { "id": "byName", "options": "Action" }, "properties": [ { "id": "displayName", "value": "Evento" }, { "id": "unit", "value": "short" }, { "id": "decimals", "value": 2 }, { "id": "custom.displayMode", "value": "color-background" }, { "id": "custom.align", "value": null }, { "id": "thresholds", "value": { "mode": "absolute", "steps": [ { "color": "#19730E", "value": null }, { "color": "#37872D", "value": 1 }, { "color": "rgb(45, 84, 45)", "value": 2 } ] } } ] }, { "matcher": { "id": "byName", "options": "sNarrative" }, "properties": [ { "id": "displayName", "value": "Description" }, { "id": "unit", "value": "short" }, { "id": "decimals", "value": 2 }, { "id": "custom.align", "value": null } ] } ] }, "gridPos": { "h": 12, "w": 12, "x": 0, "y": 12 }, "id": 2, "links": [], "options": { "showHeader": true, "sortBy": [] }, "pluginVersion": "7.5.5", "targets": [ { "alias": "", "format": "table", "rawSql": "SELECT \r\nFORMAT(ADE.[eventdatetime],'dd/mm/yyyy - hh:mm:ss') AS 'Datatime',\r\nU.username,\r\nR.name,\r\nADE.sNarrative\r\nFROM BPAAuditEvents ADE WITH (NOLOCK)\r\nINNER JOIN BPAUser AS U ON U.[USERID] = ADE.[gSrcUserID]\r\nINNER JOIN BPAResource AS R ON ADE.gTgtResourceID = R.[resourceid]\r\nwhere sCode = 'L001' OR sCode = 'L002' AND [eventdatetime] $__timeFilter()\r\nAND $__timeFilter(ADE.eventdatetime)\r\nORDER BY ADE.eventdatetime", "refId": "A" } ], "title": "Login Events", "transformations": [ { "id": "merge", "options": { "reducers": [] } } ], "type": "table" }, { "datasource": "${DS_MICROSOFT_SQL SERVER}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": null, "filterable": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "eventdatetime" }, "properties": [ { "id": "displayName", "value": "Data e Hora" }, { "id": "unit", "value": "dateTimeFromNow" }, { "id": "unit", "value": "time: DD/MM/YYYY h:mm:ss a" }, { "id": "custom.align", "value": null } ] }, { "matcher": { "id": "byName", "options": "sCode" }, "properties": [ { "id": "displayName", "value": "Event" }, { "id": "unit", "value": "short" }, { "id": "decimals", "value": 2 }, { "id": "custom.displayMode", "value": "color-text" }, { "id": "custom.align", "value": null } ] }, { "matcher": { "id": "byName", "options": "sNarrative" }, "properties": [ { "id": "displayName", "value": "Ações Realizadas" }, { "id": "unit", "value": "short" }, { "id": "decimals", "value": 2 }, { "id": "custom.align", "value": null } ] } ] }, "gridPos": { "h": 12, "w": 12, "x": 12, "y": 12 }, "id": 6, "links": [], "options": { "showHeader": true }, "pluginVersion": "7.5.5", "targets": [ { "alias": "", "format": "table", "hide": false, "rawSql": " SELECT TOP 500\r\n FORMAT([eventdatetime],'dd/mm/yyyy - hh:mm:ss') AS 'Datatime',\r\n\tsNarrative,\r\n\tcomments\r\nFROM\r\n\t[BPAAuditEvents] bpaa (NOLOCK)\r\nINNER JOIN COE_sCode CC ON bpaa.sCode = CC.sCode\r\nGROUP BY\r\n\tbpaa.sCode, bpaa.eventdatetime, bpaa.sNarrative, bpaa.comments, CC.Evento\r\nORDER BY\r\n\tbpaa.eventdatetime DESC", "refId": "A" } ], "title": "Events", "transformations": [ { "id": "merge", "options": { "reducers": [] } } ], "type": "table" }, { "datasource": null, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": null, "filterable": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "short" }, "overrides": [ { "matcher": { "id": "byName", "options": "Datatime" }, "properties": [ { "id": "unit", "value": "dthms" } ] } ] }, "gridPos": { "h": 15, "w": 24, "x": 0, "y": 24 }, "id": 8, "options": { "showHeader": true }, "pluginVersion": "7.5.5", "targets": [ { "alias": "", "format": "table", "rawSql": "SELECT\r\nsCode\r\n,P.name 'Process name'\r\n,EditSummary\r\n,FORMAT(eventdatetime,'dd/MM/yyyy - HH:mm:ss') Datatime\r\n FROM [Blue Prism].[dbo].[BPAAuditEvents] AE\r\n Inner Join BPAProcess P ON AE.gTgtProcID = P.processid\r\nWHERE sCode = 'P004'\r\n\r\nORDER BY 3 DESC", "refId": "A" } ], "timeFrom": null, "timeShift": null, "title": "Lasted Process updated", "type": "table" } ], "refresh": "1m", "schemaVersion": 27, "style": "dark", "tags": [ "BluePrism Audit" ], "templating": { "list": [] }, "time": { "from": "now-7d", "to": "now" }, "timepicker": { "refresh_intervals": [ "1m" ], "time_options": [ "5m", "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d" ] }, "timezone": "", "title": "Viewer - Audit", "uid": "Audit", "version": 5 }