guest / grafana.json

{ "apiVersion": "dashboard.grafana.app/v2", "kind": "Dashboard", "metadata": { "name": "ad-samba-audit2", "generation": 44, "creationTimestamp": "2026-07-03T12:41:09Z", "labels": {}, "annotations": {} }, "spec": { "annotations": [ { "kind": "AnnotationQuery", "spec": { "query": { "kind": "DataQuery", "group": "grafana", "version": "v0", "spec": {} }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "builtIn": true } } ], "cursorSync": "Crosshair", "editable": true, "elements": { "panel-1": { "kind": "Panel", "spec": { "id": 1, "title": "Logins OK", "description": "Успешные входы в домен (samba_auth): машинные и пользовательские, разбивка по домену.", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "machine_login", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "domain::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_auth", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "client_account" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "status::tag", "operator": "=", "value": "NT_STATUS_OK" }, { "condition": "AND", "key": "account::tag", "operator": "=~", "value": "/^MACHINE/" } ] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "user_login", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "domain::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_auth", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^user/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "client_account" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "status::tag", "operator": "=", "value": "NT_STATUS_OK" }, { "condition": "AND", "key": "account::tag", "operator": "=~", "value": "/^user/" }, { "condition": "OR", "key": "account::tag", "operator": "=~", "value": "/^loadtest/" } ] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "B", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-10": { "kind": "Panel", "spec": { "id": 10, "title": "Samba: подключённых клиентов", "description": "История числа подключённых SMB-клиентов (samba_clients.count).", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "clients", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_clients", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"count\") FROM \"samba_clients\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "count" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "unit": "none", "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 15, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "stepAfter", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-11": { "kind": "Panel", "spec": { "id": 11, "title": "Authentifications", "description": "Успешные входы в домен (samba_auth): машинные и пользовательские, разбивка по домену.", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "machine_logins", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "domain::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_auth", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "client_account" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "status::tag", "operator": "=", "value": "NT_STATUS_OK" }, { "condition": "AND", "key": "account::tag", "operator": "=~", "value": "/^MACHINE/" } ] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "user_logins", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "domain::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_auth", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^user/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "client_account" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "status::tag", "operator": "=", "value": "NT_STATUS_OK" }, { "condition": "AND", "key": "account::tag", "operator": "=~", "value": "/^user/" }, { "condition": "OR", "key": "account::tag", "operator": "=~", "value": "/^loadtest/" } ] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "B", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "stat", "version": "13.0.1+security-01", "spec": { "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "sum" ], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" } }, "overrides": [] } } } } }, "panel-12": { "kind": "Panel", "spec": { "id": 12, "title": "vfs_fsync ops", "description": "Метрика за каждую секунду: Каждый блок или строчка — это отчет за 1 секунду времени (так как в скрипте задан интервал interval:s:1).Имя функции (vfs_fsync_range): Ядро Linux обрабатывает запросы к файлу .ldb именно через системный вызов vfs_fsync_range. Это означает, что приложение не просто сохраняет весь файл целиком, а пытается очень часто и точечно сбрасывать из оперативной памяти на диск конкретные измененные участки (диапазоны байт).", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "machine_login", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_sync_ops", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "count" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-13": { "kind": "Panel", "spec": { "id": 13, "title": "ldb ops process operation", "description": "* Режим чистого чтения [ R ]: Метрика ldb_search_events растет (пользователи входят \n в сеть), а syscall_fsync_events держится около нуля. База в RAM работает идеально.\n* Режим записи [ W ] / [ CW ]: Метрика syscall_fsync_events начинает расти синхронно \n с действиями пользователей. Это означает, что изменения фиксируются на диск. \n Если график упирается в производительность ваших дисков, время ответа Samba \n будет увеличиваться (растут задержки аутентификации).\n\nO=Open (Открытие файла для записи/изменения)\n\nRO=Read Only (Открытие файла строго для чтения)\n\nR=Read (Чтение данных из файла)\n\nW=Write (Запись измененных данных в кэш памяти)\n\nCW=Commit/Close Write (Фиксация транзакции и принудительный сброс на диск)", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "prog::tag" ], "type": "tag" }, { "params": [ "action::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_file_access", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "path" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-14": { "kind": "Panel", "spec": { "id": 14, "title": "vmstat", "description": "si=Swap In, Объем данных в КБ/сек, считываемый из свопа обратно в ОЗУ. Высокое значение = жесткие тормоза.\nso=Swap Out, Объем данных в КБ/сек, сбрасываемый из ОЗУ в своп на диск из-за нехватки памяти.\n\nbi=Blocks In, Количество блоков, считанных с диска в КБ/сек. Показывает активность чтения.\nbo=Blocks Out, Количество блоков, записанных на диск в КБ/сек. Связано с операциями W, CW и fsync.\n\nin=Interrupts, Количество аппаратных прерываний в секунду, включая системные часы.\n\nid=Idle Time, Процент времени, когда CPU ничем не занят. Если около 0 — процессор загружен полностью.", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "si", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_vmstat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "si" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "so", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_vmstat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "so" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "E", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "bi", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_vmstat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "bi" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "B", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "bo", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_vmstat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "bo" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "F", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-15": { "kind": "Panel", "spec": { "id": 15, "title": "pidstat", "description": "minflt/s = Скорость работы с ОЗУ. Сколько раз в секунду процесс запрашивал данные, \n которые ядро Linux успешно выдало из оперативной памяти (из кэша).\n Высокое значение — это норма при активных вычислениях или LDAP-запросах.\n\nmajflt/s = Скорость просадки на диск. Сколько раз в секунду процесс лез за данными \n на физический диск (или в SWAP), потому что их не оказалость в ОЗУ.\n В идеале должно быть равно 0. Если число растет — сервер сильно тормозит.\n\n%MEM = Процент ОЗУ. Доля оперативной памяти сервера, которую съел этот PID.", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "minfit", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "comm::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_pidstat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "minflt" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "majfit", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "comm::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_pidstat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "majflt" ], "type": "field" }, { "params": [], "type": "median" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "B", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [ { "__systemRef": "hideSeriesFrom", "matcher": { "id": "byNames", "options": { "mode": "exclude", "names": [ "MEM" ], "prefix": "All except:", "readOnly": true } }, "properties": [ { "id": "custom.hideFrom", "value": { "legend": false, "tooltip": true, "viz": true } } ] } ] } } } } }, "panel-16": { "kind": "Panel", "spec": { "id": 16, "title": "ldb ops operation", "description": "* Режим чистого чтения [ R ]: Метрика ldb_search_events растет (пользователи входят \n в сеть), а syscall_fsync_events держится около нуля. База в RAM работает идеально.\n* Режим записи [ W ] / [ CW ]: Метрика syscall_fsync_events начинает расти синхронно \n с действиями пользователей. Это означает, что изменения фиксируются на диск. \n Если график упирается в производительность ваших дисков, время ответа Samba \n будет увеличиваться (растут задержки аутентификации).\n\nO=Open (Открытие файла для записи/изменения)\n\nRO=Read Only (Открытие файла строго для чтения)\n\nR=Read (Чтение данных из файла)\n\nW=Write (Запись измененных данных в кэш памяти)\n\nCW=Commit/Close Write (Фиксация транзакции и принудительный сброс на диск)", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "action::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_file_access", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "path" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-17": { "kind": "Panel", "spec": { "id": 17, "title": "Iostat await", "description": "", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "$tag_device f_await", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "device::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_iostat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "f_await" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "$tag_device r_await", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "device::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_iostat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "r_await" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "B", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "$tag_device w_await", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "device::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_iostat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "w_await" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "C", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-18": { "kind": "Panel", "spec": { "id": 18, "title": "pidstat mem", "description": "minflt/s = Скорость работы с ОЗУ. Сколько раз в секунду процесс запрашивал данные, \n которые ядро Linux успешно выдало из оперативной памяти (из кэша).\n Высокое значение — это норма при активных вычислениях или LDAP-запросах.\n\nmajflt/s = Скорость просадки на диск. Сколько раз в секунду процесс лез за данными \n на физический диск (или в SWAP), потому что их не оказалость в ОЗУ.\n В идеале должно быть равно 0. Если число растет — сервер сильно тормозит.\n\n%MEM = Процент ОЗУ. Доля оперативной памяти сервера, которую съел этот PID.", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "%MEM", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "comm::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_pidstat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "mem" ], "type": "field" }, { "params": [], "type": "median" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "C", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-19": { "kind": "Panel", "spec": { "id": 19, "title": "RSS", "description": "minflt/s = Скорость работы с ОЗУ. Сколько раз в секунду процесс запрашивал данные, \n которые ядро Linux успешно выдало из оперативной памяти (из кэша).\n Высокое значение — это норма при активных вычислениях или LDAP-запросах.\n\nmajflt/s = Скорость просадки на диск. Сколько раз в секунду процесс лез за данными \n на физический диск (или в SWAP), потому что их не оказалость в ОЗУ.\n В идеале должно быть равно 0. Если число растет — сервер сильно тормозит.\n\n%MEM = Процент ОЗУ. Доля оперативной памяти сервера, которую съел этот PID.", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "RSS", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "comm::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_pidstat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "rss" ], "type": "field" }, { "params": [], "type": "median" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "C", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-2": { "kind": "Panel", "spec": { "id": 2, "title": "DSDB: изменения по операциям", "description": "Число изменений объектов каталога (samba_dsdb), разбивка по типу операции.", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "groupBy": [], "measurement": "samba_dsdb", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"status_code\") FROM \"samba_dsdb\" WHERE $timeFilter GROUP BY time($interval), \"operation\"::tag fill(null)", "rawQuery": true, "resultFormat": "time_series", "select": [], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "multi", "sort": "desc" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "bars", "fillOpacity": 50, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "normal" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-20": { "kind": "Panel", "spec": { "id": 20, "title": "ldb ops", "description": "* Режим чистого чтения [ R ]: Метрика ldb_search_events растет (пользователи входят \n в сеть), а syscall_fsync_events держится около нуля. База в RAM работает идеально.\n* Режим записи [ W ] / [ CW ]: Метрика syscall_fsync_events начинает расти синхронно \n с действиями пользователей. Это означает, что изменения фиксируются на диск. \n Если график упирается в производительность ваших дисков, время ответа Samba \n будет увеличиваться (растут задержки аутентификации).\n\nO=Open (Открытие файла для записи/изменения)\n\nRO=Read Only (Открытие файла строго для чтения)\n\nR=Read (Чтение данных из файла)\n\nW=Write (Запись измененных данных в кэш памяти)\n\nCW=Commit/Close Write (Фиксация транзакции и принудительный сброс на диск)", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_file_access", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "path" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-21": { "kind": "Panel", "spec": { "id": 21, "title": "ldb ops summ", "description": "* Режим чистого чтения [ R ]: Метрика ldb_search_events растет (пользователи входят \n в сеть), а syscall_fsync_events держится около нуля. База в RAM работает идеально.\n* Режим записи [ W ] / [ CW ]: Метрика syscall_fsync_events начинает расти синхронно \n с действиями пользователей. Это означает, что изменения фиксируются на диск. \n Если график упирается в производительность ваших дисков, время ответа Samba \n будет увеличиваться (растут задержки аутентификации).\n\nO=Open (Открытие файла для записи/изменения)\n\nRO=Read Only (Открытие файла строго для чтения)\n\nR=Read (Чтение данных из файла)\n\nW=Write (Запись измененных данных в кэш памяти)\n\nCW=Commit/Close Write (Фиксация транзакции и принудительный сброс на диск)", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_file_access", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "path" ], "type": "field" }, { "params": [], "type": "count" }, { "params": [], "type": "cumulative_sum" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "stat", "version": "13.0.1+security-01", "spec": { "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" } }, "overrides": [] } } } } }, "panel-22": { "kind": "Panel", "spec": { "id": 22, "title": "Iostat kb/s", "description": "", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "$tag_device d kb/s", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "device::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_iostat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "dkb_s" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "$tag_device r kb/s", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "device::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_iostat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "rkb_s" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "B", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "$tag_device w kb/s", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "device::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_iostat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "wkb_s" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "C", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-23": { "kind": "Panel", "spec": { "id": 23, "title": "Iostat util", "description": "", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "$tag_device util", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "device::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_iostat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "util" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-24": { "kind": "Panel", "spec": { "id": 24, "title": "Iostat s", "description": "", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "$tag_device f/s", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "device::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_iostat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "f_s" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "$tag_device r/s", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "device::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_iostat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "r_s" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "B", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "$tag_device w/s", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "device::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_iostat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "w_s" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "C", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-25": { "kind": "Panel", "spec": { "id": 25, "title": "vmstat idle", "description": "si=Swap In, Объем данных в КБ/сек, считываемый из свопа обратно в ОЗУ. Высокое значение = жесткие тормоза.\nso=Swap Out, Объем данных в КБ/сек, сбрасываемый из ОЗУ в своп на диск из-за нехватки памяти.\n\nbi=Blocks In, Количество блоков, считанных с диска в КБ/сек. Показывает активность чтения.\nbo=Blocks Out, Количество блоков, записанных на диск в КБ/сек. Связано с операциями W, CW и fsync.\n\nin=Interrupts, Количество аппаратных прерываний в секунду, включая системные часы.\n\nid=Idle Time, Процент времени, когда CPU ничем не занят. Если около 0 — процессор загружен полностью.", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "idle", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_vmstat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "idle" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "D", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-26": { "kind": "Panel", "spec": { "id": 26, "title": "vmstat interrupts", "description": "si=Swap In, Объем данных в КБ/сек, считываемый из свопа обратно в ОЗУ. Высокое значение = жесткие тормоза.\nso=Swap Out, Объем данных в КБ/сек, сбрасываемый из ОЗУ в своп на диск из-за нехватки памяти.\n\nbi=Blocks In, Количество блоков, считанных с диска в КБ/сек. Показывает активность чтения.\nbo=Blocks Out, Количество блоков, записанных на диск в КБ/сек. Связано с операциями W, CW и fsync.\n\nin=Interrupts, Количество аппаратных прерываний в секунду, включая системные часы.\n\nid=Idle Time, Процент времени, когда CPU ничем не занят. Если около 0 — процессор загружен полностью.", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "in", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "host_vmstat", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "intr" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "C", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-3": { "kind": "Panel", "spec": { "id": 3, "title": "DSDB: система vs пользователь", "description": "Изменения каталога с разбивкой по performedAsSystem (true = выполнено системой).", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "groupBy": [], "measurement": "samba_dsdb", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"status_code\") FROM \"samba_dsdb\" WHERE $timeFilter GROUP BY time($interval), \"as_system\"::tag fill(null)", "rawQuery": true, "resultFormat": "time_series", "select": [], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "multi", "sort": "desc" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 20, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-4": { "kind": "Panel", "spec": { "id": 4, "title": "DSDB: топ инициаторов (SID)", "description": "Кто инициировал изменения каталога — разбивка по userSid.", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "groupBy": [], "measurement": "samba_dsdb", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"status_code\") FROM \"samba_dsdb\" WHERE $timeFilter GROUP BY time($interval), \"user_sid\"::tag fill(null)", "rawQuery": true, "resultFormat": "time_series", "select": [], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [ "sum" ], "displayMode": "table", "placement": "right", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "multi", "sort": "desc" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "bars", "fillOpacity": 50, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "normal" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-5": { "kind": "Panel", "spec": { "id": 5, "title": "Транзакции: длительность (mean/max)", "description": "Длительность транзакций каталога (samba_dsdb_tx) в микросекундах.", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "groupBy": [], "measurement": "samba_dsdb_tx", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"duration\") AS \"mean\", max(\"duration\") AS \"max\" FROM \"samba_dsdb_tx\" WHERE $timeFilter GROUP BY time($interval) fill(null)", "rawQuery": true, "resultFormat": "time_series", "select": [], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [ "mean", "max" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "multi", "sort": "desc" } }, "fieldConfig": { "defaults": { "unit": "µs", "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-6": { "kind": "Panel", "spec": { "id": 6, "title": "Транзакции по типу действия", "description": "Число транзакций каталога, разбивка по action (commit / rollback / prepare commit / begin).", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "groupBy": [], "measurement": "samba_dsdb_tx", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"duration\") FROM \"samba_dsdb_tx\" WHERE $timeFilter GROUP BY time($interval), \"action\"::tag fill(null)", "rawQuery": true, "resultFormat": "time_series", "select": [], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "multi", "sort": "desc" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "bars", "fillOpacity": 50, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "normal" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-7": { "kind": "Panel", "spec": { "id": 7, "title": "SMB activity", "description": "", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "user_smb", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "domain::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_authz", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "auth_type" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "service::tag", "operator": "=", "value": "SMB2" }, { "condition": "AND", "key": "auth_type::field", "operator": "=", "value": "krb5" }, { "condition": "AND", "key": "account::tag", "operator": "=~", "value": "/^user-/" } ] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "machine_smb", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "domain::tag" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_authz", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "auth_type" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "service::tag", "operator": "=", "value": "SMB2" }, { "condition": "AND", "key": "auth_type::field", "operator": "=", "value": "krb5" }, { "condition": "AND", "key": "account::tag", "operator": "=~", "value": "/^MACHINE/" } ] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "B", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-8": { "kind": "Panel", "spec": { "id": 8, "title": "DNS activity", "description": "", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "rcode=0", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_dns_rcode", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "rcode" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "rcode::field", "operator": "=", "value": "0" }, { "condition": "AND", "key": "direction::tag", "operator": "=", "value": "out_packet" } ] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } }, { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "rcode=3", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_dns_rcode", "orderByTime": "ASC", "policy": "default", "query": "SELECT count(\"client_account\") FROM \"samba_auth\" WHERE (\"status\"::tag = 'NT_STATUS_OK' AND \"account\"::tag =~ /^MACHINE/) AND $timeFilter GROUP BY time($interval), \"domain\"::tag fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "rcode" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "rcode::field", "operator": "=", "value": "3" }, { "condition": "AND", "key": "direction::tag", "operator": "=", "value": "out_packet" } ] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "B", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "timeseries", "version": "13.0.1+security-01", "spec": { "options": { "annotations": { "clustering": -1, "multiLane": false }, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 10, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "showValues": false, "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } } }, "overrides": [] } } } } }, "panel-9": { "kind": "Panel", "spec": { "id": 9, "title": "Samba: клиентов сейчас", "description": "Текущее число подключённых SMB-клиентов (последний опрос smbstatus -v, первый блок).", "links": [], "data": { "kind": "QueryGroup", "spec": { "queries": [ { "kind": "PanelQuery", "spec": { "query": { "kind": "DataQuery", "group": "influxdb", "version": "v0", "spec": { "alias": "clients", "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "samba_clients", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"count\") FROM \"samba_clients\" WHERE $timeFilter GROUP BY time($interval) fill(null)", "rawQuery": false, "resultFormat": "time_series", "select": [ [ { "params": [ "count" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] }, "labels": { "grafana.app/export-label": "influxdb-1" } }, "refId": "A", "hidden": false } } ], "transformations": [], "queryOptions": {} } }, "vizConfig": { "kind": "VizConfig", "group": "stat", "version": "13.0.1+security-01", "spec": { "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "fieldConfig": { "defaults": { "unit": "none", "thresholds": { "mode": "absolute", "steps": [ { "value": 0, "color": "green" }, { "value": null, "color": "red" } ] }, "color": { "mode": "palette-classic" } }, "overrides": [] } } } } } }, "layout": { "kind": "GridLayout", "spec": { "items": [ { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 0, "width": 11, "height": 10, "element": { "kind": "ElementReference", "name": "panel-11" } } }, { "kind": "GridLayoutItem", "spec": { "x": 11, "y": 0, "width": 13, "height": 10, "element": { "kind": "ElementReference", "name": "panel-1" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 10, "width": 24, "height": 10, "element": { "kind": "ElementReference", "name": "panel-12" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 20, "width": 8, "height": 11, "element": { "kind": "ElementReference", "name": "panel-21" } } }, { "kind": "GridLayoutItem", "spec": { "x": 8, "y": 20, "width": 16, "height": 11, "element": { "kind": "ElementReference", "name": "panel-20" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 31, "width": 11, "height": 11, "element": { "kind": "ElementReference", "name": "panel-16" } } }, { "kind": "GridLayoutItem", "spec": { "x": 11, "y": 31, "width": 13, "height": 11, "element": { "kind": "ElementReference", "name": "panel-13" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 42, "width": 11, "height": 10, "element": { "kind": "ElementReference", "name": "panel-17" } } }, { "kind": "GridLayoutItem", "spec": { "x": 11, "y": 42, "width": 13, "height": 10, "element": { "kind": "ElementReference", "name": "panel-22" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 52, "width": 16, "height": 10, "element": { "kind": "ElementReference", "name": "panel-24" } } }, { "kind": "GridLayoutItem", "spec": { "x": 16, "y": 52, "width": 8, "height": 10, "element": { "kind": "ElementReference", "name": "panel-23" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 62, "width": 8, "height": 9, "element": { "kind": "ElementReference", "name": "panel-14" } } }, { "kind": "GridLayoutItem", "spec": { "x": 8, "y": 62, "width": 9, "height": 9, "element": { "kind": "ElementReference", "name": "panel-26" } } }, { "kind": "GridLayoutItem", "spec": { "x": 17, "y": 62, "width": 7, "height": 9, "element": { "kind": "ElementReference", "name": "panel-25" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 71, "width": 8, "height": 8, "element": { "kind": "ElementReference", "name": "panel-15" } } }, { "kind": "GridLayoutItem", "spec": { "x": 8, "y": 71, "width": 8, "height": 8, "element": { "kind": "ElementReference", "name": "panel-18" } } }, { "kind": "GridLayoutItem", "spec": { "x": 16, "y": 71, "width": 8, "height": 8, "element": { "kind": "ElementReference", "name": "panel-19" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 79, "width": 12, "height": 7, "element": { "kind": "ElementReference", "name": "panel-7" } } }, { "kind": "GridLayoutItem", "spec": { "x": 12, "y": 79, "width": 12, "height": 7, "element": { "kind": "ElementReference", "name": "panel-8" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 86, "width": 12, "height": 8, "element": { "kind": "ElementReference", "name": "panel-2" } } }, { "kind": "GridLayoutItem", "spec": { "x": 12, "y": 86, "width": 12, "height": 8, "element": { "kind": "ElementReference", "name": "panel-3" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 94, "width": 12, "height": 8, "element": { "kind": "ElementReference", "name": "panel-4" } } }, { "kind": "GridLayoutItem", "spec": { "x": 12, "y": 94, "width": 12, "height": 8, "element": { "kind": "ElementReference", "name": "panel-5" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 102, "width": 12, "height": 8, "element": { "kind": "ElementReference", "name": "panel-6" } } }, { "kind": "GridLayoutItem", "spec": { "x": 0, "y": 110, "width": 6, "height": 8, "element": { "kind": "ElementReference", "name": "panel-9" } } }, { "kind": "GridLayoutItem", "spec": { "x": 6, "y": 110, "width": 18, "height": 8, "element": { "kind": "ElementReference", "name": "panel-10" } } } ] } }, "links": [], "liveNow": false, "preload": false, "tags": [ "samba", "ad", "audit" ], "timeSettings": { "timezone": "browser", "from": "now-6h", "to": "now", "autoRefresh": "", "autoRefreshIntervals": [ "5s", "10s", "30s", "1m", "5m", "15m", "30m", "1h", "2h", "1d" ], "hideTimepicker": false, "fiscalYearStartMonth": 0 }, "title": "Samba AD audit2", "variables": [ { "kind": "IntervalVariable", "spec": { "name": "interval", "query": "1s,3s,5s,10s,30s,1m,10m,30m,1h,6h,12h,1d,7d,14d,30d", "current": { "text": "1m", "value": "1m" }, "options": [ { "selected": true, "text": "1m", "value": "1m" }, { "selected": false, "text": "10m", "value": "10m" }, { "selected": false, "text": "30m", "value": "30m" }, { "selected": false, "text": "1h", "value": "1h" }, { "selected": false, "text": "6h", "value": "6h" }, { "selected": false, "text": "12h", "value": "12h" }, { "selected": false, "text": "1d", "value": "1d" } ], "auto": false, "auto_min": "10s", "auto_count": 30, "refresh": "onTimeRangeChanged", "hide": "dontHide", "skipUrlSync": false } } ], "preferences": { "layout": { "kind": "GridLayout", "spec": { "items": [] } } } } }