Last active 1 week ago

Revision febd7490598e169c2ee5c363ce8c98d5741e7252

grafana.json Raw
1{
2 "apiVersion": "dashboard.grafana.app/v2",
3 "kind": "Dashboard",
4 "metadata": {
5 "name": "ad-samba-audit2",
6 "generation": 45,
7 "creationTimestamp": "2026-07-03T12:41:09Z",
8 "labels": {},
9 "annotations": {}
10 },
11 "spec": {
12 "annotations": [
13 {
14 "kind": "AnnotationQuery",
15 "spec": {
16 "query": {
17 "kind": "DataQuery",
18 "group": "grafana",
19 "version": "v0",
20 "spec": {}
21 },
22 "enable": true,
23 "hide": true,
24 "iconColor": "rgba(0, 211, 255, 1)",
25 "name": "Annotations & Alerts",
26 "builtIn": true
27 }
28 }
29 ],
30 "cursorSync": "Crosshair",
31 "editable": true,
32 "elements": {
33 "panel-1": {
34 "kind": "Panel",
35 "spec": {
36 "id": 1,
37 "title": "Logins OK",
38 "description": "Успешные входы в домен (samba_auth): машинные и пользовательские, разбивка по домену.",
39 "links": [],
40 "data": {
41 "kind": "QueryGroup",
42 "spec": {
43 "queries": [
44 {
45 "kind": "PanelQuery",
46 "spec": {
47 "query": {
48 "kind": "DataQuery",
49 "group": "influxdb",
50 "version": "v0",
51 "spec": {
52 "alias": "machine_login",
53 "groupBy": [
54 {
55 "params": [
56 "$interval"
57 ],
58 "type": "time"
59 },
60 {
61 "params": [
62 "domain::tag"
63 ],
64 "type": "tag"
65 },
66 {
67 "params": [
68 "null"
69 ],
70 "type": "fill"
71 }
72 ],
73 "measurement": "samba_auth",
74 "orderByTime": "ASC",
75 "policy": "default",
76 "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)",
77 "rawQuery": false,
78 "resultFormat": "time_series",
79 "select": [
80 [
81 {
82 "params": [
83 "client_account"
84 ],
85 "type": "field"
86 },
87 {
88 "params": [],
89 "type": "count"
90 }
91 ]
92 ],
93 "tags": [
94 {
95 "key": "status::tag",
96 "operator": "=",
97 "value": "NT_STATUS_OK"
98 },
99 {
100 "condition": "AND",
101 "key": "account::tag",
102 "operator": "=~",
103 "value": "/^MACHINE/"
104 }
105 ]
106 },
107 "labels": {
108 "grafana.app/export-label": "influxdb-1"
109 }
110 },
111 "refId": "A",
112 "hidden": false
113 }
114 },
115 {
116 "kind": "PanelQuery",
117 "spec": {
118 "query": {
119 "kind": "DataQuery",
120 "group": "influxdb",
121 "version": "v0",
122 "spec": {
123 "alias": "user_login",
124 "groupBy": [
125 {
126 "params": [
127 "$interval"
128 ],
129 "type": "time"
130 },
131 {
132 "params": [
133 "domain::tag"
134 ],
135 "type": "tag"
136 },
137 {
138 "params": [
139 "null"
140 ],
141 "type": "fill"
142 }
143 ],
144 "measurement": "samba_auth",
145 "orderByTime": "ASC",
146 "policy": "default",
147 "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)",
148 "rawQuery": false,
149 "resultFormat": "time_series",
150 "select": [
151 [
152 {
153 "params": [
154 "client_account"
155 ],
156 "type": "field"
157 },
158 {
159 "params": [],
160 "type": "count"
161 }
162 ]
163 ],
164 "tags": [
165 {
166 "key": "status::tag",
167 "operator": "=",
168 "value": "NT_STATUS_OK"
169 },
170 {
171 "condition": "AND",
172 "key": "account::tag",
173 "operator": "=~",
174 "value": "/^user/"
175 },
176 {
177 "condition": "OR",
178 "key": "account::tag",
179 "operator": "=~",
180 "value": "/^loadtest/"
181 }
182 ]
183 },
184 "labels": {
185 "grafana.app/export-label": "influxdb-1"
186 }
187 },
188 "refId": "B",
189 "hidden": false
190 }
191 }
192 ],
193 "transformations": [],
194 "queryOptions": {}
195 }
196 },
197 "vizConfig": {
198 "kind": "VizConfig",
199 "group": "timeseries",
200 "version": "13.0.1+security-01",
201 "spec": {
202 "options": {
203 "annotations": {
204 "clustering": -1,
205 "multiLane": false
206 },
207 "legend": {
208 "calcs": [],
209 "displayMode": "list",
210 "placement": "bottom",
211 "showLegend": true
212 },
213 "tooltip": {
214 "hideZeros": false,
215 "mode": "single",
216 "sort": "none"
217 }
218 },
219 "fieldConfig": {
220 "defaults": {
221 "thresholds": {
222 "mode": "absolute",
223 "steps": [
224 {
225 "value": 0,
226 "color": "green"
227 },
228 {
229 "value": 80,
230 "color": "red"
231 }
232 ]
233 },
234 "color": {
235 "mode": "palette-classic"
236 },
237 "custom": {
238 "axisBorderShow": false,
239 "axisCenteredZero": false,
240 "axisColorMode": "text",
241 "axisLabel": "",
242 "axisPlacement": "auto",
243 "barAlignment": 0,
244 "barWidthFactor": 0.6,
245 "drawStyle": "line",
246 "fillOpacity": 10,
247 "gradientMode": "none",
248 "hideFrom": {
249 "legend": false,
250 "tooltip": false,
251 "viz": false
252 },
253 "insertNulls": false,
254 "lineInterpolation": "smooth",
255 "lineWidth": 1,
256 "pointSize": 5,
257 "scaleDistribution": {
258 "type": "linear"
259 },
260 "showPoints": "auto",
261 "showValues": false,
262 "spanNulls": false,
263 "stacking": {
264 "group": "A",
265 "mode": "none"
266 },
267 "thresholdsStyle": {
268 "mode": "off"
269 }
270 }
271 },
272 "overrides": []
273 }
274 }
275 }
276 }
277 },
278 "panel-10": {
279 "kind": "Panel",
280 "spec": {
281 "id": 10,
282 "title": "Samba: подключённых клиентов",
283 "description": "История числа подключённых SMB-клиентов (samba_clients.count).",
284 "links": [],
285 "data": {
286 "kind": "QueryGroup",
287 "spec": {
288 "queries": [
289 {
290 "kind": "PanelQuery",
291 "spec": {
292 "query": {
293 "kind": "DataQuery",
294 "group": "influxdb",
295 "version": "v0",
296 "spec": {
297 "alias": "clients",
298 "groupBy": [
299 {
300 "params": [
301 "$__interval"
302 ],
303 "type": "time"
304 },
305 {
306 "params": [
307 "null"
308 ],
309 "type": "fill"
310 }
311 ],
312 "measurement": "samba_clients",
313 "orderByTime": "ASC",
314 "policy": "default",
315 "query": "SELECT last(\"count\") FROM \"samba_clients\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
316 "rawQuery": false,
317 "resultFormat": "time_series",
318 "select": [
319 [
320 {
321 "params": [
322 "count"
323 ],
324 "type": "field"
325 },
326 {
327 "params": [],
328 "type": "last"
329 }
330 ]
331 ],
332 "tags": []
333 },
334 "labels": {
335 "grafana.app/export-label": "influxdb-1"
336 }
337 },
338 "refId": "A",
339 "hidden": false
340 }
341 }
342 ],
343 "transformations": [],
344 "queryOptions": {}
345 }
346 },
347 "vizConfig": {
348 "kind": "VizConfig",
349 "group": "timeseries",
350 "version": "13.0.1+security-01",
351 "spec": {
352 "options": {
353 "annotations": {
354 "clustering": -1,
355 "multiLane": false
356 },
357 "legend": {
358 "calcs": [],
359 "displayMode": "list",
360 "placement": "bottom",
361 "showLegend": true
362 },
363 "tooltip": {
364 "hideZeros": false,
365 "mode": "single",
366 "sort": "none"
367 }
368 },
369 "fieldConfig": {
370 "defaults": {
371 "unit": "none",
372 "thresholds": {
373 "mode": "absolute",
374 "steps": [
375 {
376 "value": 0,
377 "color": "green"
378 }
379 ]
380 },
381 "color": {
382 "mode": "palette-classic"
383 },
384 "custom": {
385 "axisBorderShow": false,
386 "axisCenteredZero": false,
387 "axisColorMode": "text",
388 "axisLabel": "",
389 "axisPlacement": "auto",
390 "barAlignment": 0,
391 "barWidthFactor": 0.6,
392 "drawStyle": "line",
393 "fillOpacity": 15,
394 "gradientMode": "none",
395 "hideFrom": {
396 "legend": false,
397 "tooltip": false,
398 "viz": false
399 },
400 "insertNulls": false,
401 "lineInterpolation": "stepAfter",
402 "lineWidth": 2,
403 "pointSize": 5,
404 "scaleDistribution": {
405 "type": "linear"
406 },
407 "showPoints": "auto",
408 "showValues": false,
409 "spanNulls": false,
410 "stacking": {
411 "group": "A",
412 "mode": "none"
413 },
414 "thresholdsStyle": {
415 "mode": "off"
416 }
417 }
418 },
419 "overrides": []
420 }
421 }
422 }
423 }
424 },
425 "panel-11": {
426 "kind": "Panel",
427 "spec": {
428 "id": 11,
429 "title": "Authentifications",
430 "description": "Успешные входы в домен (samba_auth): машинные и пользовательские, разбивка по домену.",
431 "links": [],
432 "data": {
433 "kind": "QueryGroup",
434 "spec": {
435 "queries": [
436 {
437 "kind": "PanelQuery",
438 "spec": {
439 "query": {
440 "kind": "DataQuery",
441 "group": "influxdb",
442 "version": "v0",
443 "spec": {
444 "alias": "machine_logins",
445 "groupBy": [
446 {
447 "params": [
448 "$interval"
449 ],
450 "type": "time"
451 },
452 {
453 "params": [
454 "domain::tag"
455 ],
456 "type": "tag"
457 },
458 {
459 "params": [
460 "null"
461 ],
462 "type": "fill"
463 }
464 ],
465 "measurement": "samba_auth",
466 "orderByTime": "ASC",
467 "policy": "default",
468 "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)",
469 "rawQuery": false,
470 "resultFormat": "time_series",
471 "select": [
472 [
473 {
474 "params": [
475 "client_account"
476 ],
477 "type": "field"
478 },
479 {
480 "params": [],
481 "type": "count"
482 }
483 ]
484 ],
485 "tags": [
486 {
487 "key": "status::tag",
488 "operator": "=",
489 "value": "NT_STATUS_OK"
490 },
491 {
492 "condition": "AND",
493 "key": "account::tag",
494 "operator": "=~",
495 "value": "/^MACHINE/"
496 }
497 ]
498 },
499 "labels": {
500 "grafana.app/export-label": "influxdb-1"
501 }
502 },
503 "refId": "A",
504 "hidden": false
505 }
506 },
507 {
508 "kind": "PanelQuery",
509 "spec": {
510 "query": {
511 "kind": "DataQuery",
512 "group": "influxdb",
513 "version": "v0",
514 "spec": {
515 "alias": "user_logins",
516 "groupBy": [
517 {
518 "params": [
519 "$interval"
520 ],
521 "type": "time"
522 },
523 {
524 "params": [
525 "domain::tag"
526 ],
527 "type": "tag"
528 },
529 {
530 "params": [
531 "null"
532 ],
533 "type": "fill"
534 }
535 ],
536 "measurement": "samba_auth",
537 "orderByTime": "ASC",
538 "policy": "default",
539 "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)",
540 "rawQuery": false,
541 "resultFormat": "time_series",
542 "select": [
543 [
544 {
545 "params": [
546 "client_account"
547 ],
548 "type": "field"
549 },
550 {
551 "params": [],
552 "type": "count"
553 }
554 ]
555 ],
556 "tags": [
557 {
558 "key": "status::tag",
559 "operator": "=",
560 "value": "NT_STATUS_OK"
561 },
562 {
563 "condition": "AND",
564 "key": "account::tag",
565 "operator": "=~",
566 "value": "/^user/"
567 },
568 {
569 "condition": "OR",
570 "key": "account::tag",
571 "operator": "=~",
572 "value": "/^loadtest/"
573 }
574 ]
575 },
576 "labels": {
577 "grafana.app/export-label": "influxdb-1"
578 }
579 },
580 "refId": "B",
581 "hidden": false
582 }
583 }
584 ],
585 "transformations": [],
586 "queryOptions": {}
587 }
588 },
589 "vizConfig": {
590 "kind": "VizConfig",
591 "group": "stat",
592 "version": "13.0.1+security-01",
593 "spec": {
594 "options": {
595 "colorMode": "value",
596 "graphMode": "area",
597 "justifyMode": "auto",
598 "orientation": "auto",
599 "percentChangeColorMode": "standard",
600 "reduceOptions": {
601 "calcs": [
602 "sum"
603 ],
604 "fields": "",
605 "values": false
606 },
607 "showPercentChange": false,
608 "textMode": "auto",
609 "wideLayout": true
610 },
611 "fieldConfig": {
612 "defaults": {
613 "thresholds": {
614 "mode": "absolute",
615 "steps": [
616 {
617 "value": 0,
618 "color": "green"
619 },
620 {
621 "value": 80,
622 "color": "red"
623 }
624 ]
625 },
626 "color": {
627 "mode": "palette-classic"
628 }
629 },
630 "overrides": []
631 }
632 }
633 }
634 }
635 },
636 "panel-12": {
637 "kind": "Panel",
638 "spec": {
639 "id": 12,
640 "title": "vfs_fsync ops",
641 "description": "Метрика за каждую секунду: Каждый блок или строчка — это отчет за 1 секунду времени (так как в скрипте задан интервал interval:s:1).Имя функции (vfs_fsync_range): Ядро Linux обрабатывает запросы к файлу .ldb именно через системный вызов vfs_fsync_range. Это означает, что приложение не просто сохраняет весь файл целиком, а пытается очень часто и точечно сбрасывать из оперативной памяти на диск конкретные измененные участки (диапазоны байт).",
642 "links": [],
643 "data": {
644 "kind": "QueryGroup",
645 "spec": {
646 "queries": [
647 {
648 "kind": "PanelQuery",
649 "spec": {
650 "query": {
651 "kind": "DataQuery",
652 "group": "influxdb",
653 "version": "v0",
654 "spec": {
655 "alias": "machine_login",
656 "groupBy": [
657 {
658 "params": [
659 "$interval"
660 ],
661 "type": "time"
662 },
663 {
664 "params": [
665 "null"
666 ],
667 "type": "fill"
668 }
669 ],
670 "measurement": "samba_sync_ops",
671 "orderByTime": "ASC",
672 "policy": "default",
673 "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)",
674 "rawQuery": false,
675 "resultFormat": "time_series",
676 "select": [
677 [
678 {
679 "params": [
680 "count"
681 ],
682 "type": "field"
683 },
684 {
685 "params": [],
686 "type": "sum"
687 }
688 ]
689 ],
690 "tags": []
691 },
692 "labels": {
693 "grafana.app/export-label": "influxdb-1"
694 }
695 },
696 "refId": "A",
697 "hidden": false
698 }
699 }
700 ],
701 "transformations": [],
702 "queryOptions": {}
703 }
704 },
705 "vizConfig": {
706 "kind": "VizConfig",
707 "group": "timeseries",
708 "version": "13.0.1+security-01",
709 "spec": {
710 "options": {
711 "annotations": {
712 "clustering": -1,
713 "multiLane": false
714 },
715 "legend": {
716 "calcs": [],
717 "displayMode": "list",
718 "placement": "bottom",
719 "showLegend": true
720 },
721 "tooltip": {
722 "hideZeros": false,
723 "mode": "single",
724 "sort": "none"
725 }
726 },
727 "fieldConfig": {
728 "defaults": {
729 "thresholds": {
730 "mode": "absolute",
731 "steps": [
732 {
733 "value": 0,
734 "color": "green"
735 },
736 {
737 "value": 80,
738 "color": "red"
739 }
740 ]
741 },
742 "color": {
743 "mode": "palette-classic"
744 },
745 "custom": {
746 "axisBorderShow": false,
747 "axisCenteredZero": false,
748 "axisColorMode": "text",
749 "axisLabel": "",
750 "axisPlacement": "auto",
751 "barAlignment": 0,
752 "barWidthFactor": 0.6,
753 "drawStyle": "line",
754 "fillOpacity": 10,
755 "gradientMode": "none",
756 "hideFrom": {
757 "legend": false,
758 "tooltip": false,
759 "viz": false
760 },
761 "insertNulls": false,
762 "lineInterpolation": "smooth",
763 "lineWidth": 1,
764 "pointSize": 5,
765 "scaleDistribution": {
766 "type": "linear"
767 },
768 "showPoints": "auto",
769 "showValues": false,
770 "spanNulls": false,
771 "stacking": {
772 "group": "A",
773 "mode": "none"
774 },
775 "thresholdsStyle": {
776 "mode": "off"
777 }
778 }
779 },
780 "overrides": []
781 }
782 }
783 }
784 }
785 },
786 "panel-13": {
787 "kind": "Panel",
788 "spec": {
789 "id": 13,
790 "title": "ldb ops process operation",
791 "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 (Фиксация транзакции и принудительный сброс на диск)",
792 "links": [],
793 "data": {
794 "kind": "QueryGroup",
795 "spec": {
796 "queries": [
797 {
798 "kind": "PanelQuery",
799 "spec": {
800 "query": {
801 "kind": "DataQuery",
802 "group": "influxdb",
803 "version": "v0",
804 "spec": {
805 "groupBy": [
806 {
807 "params": [
808 "$interval"
809 ],
810 "type": "time"
811 },
812 {
813 "params": [
814 "prog::tag"
815 ],
816 "type": "tag"
817 },
818 {
819 "params": [
820 "action::tag"
821 ],
822 "type": "tag"
823 },
824 {
825 "params": [
826 "null"
827 ],
828 "type": "fill"
829 }
830 ],
831 "measurement": "samba_file_access",
832 "orderByTime": "ASC",
833 "policy": "default",
834 "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)",
835 "rawQuery": false,
836 "resultFormat": "time_series",
837 "select": [
838 [
839 {
840 "params": [
841 "path"
842 ],
843 "type": "field"
844 },
845 {
846 "params": [],
847 "type": "count"
848 }
849 ]
850 ],
851 "tags": []
852 },
853 "labels": {
854 "grafana.app/export-label": "influxdb-1"
855 }
856 },
857 "refId": "A",
858 "hidden": false
859 }
860 }
861 ],
862 "transformations": [],
863 "queryOptions": {}
864 }
865 },
866 "vizConfig": {
867 "kind": "VizConfig",
868 "group": "timeseries",
869 "version": "13.0.1+security-01",
870 "spec": {
871 "options": {
872 "annotations": {
873 "clustering": -1,
874 "multiLane": false
875 },
876 "legend": {
877 "calcs": [],
878 "displayMode": "list",
879 "placement": "bottom",
880 "showLegend": true
881 },
882 "tooltip": {
883 "hideZeros": false,
884 "mode": "single",
885 "sort": "none"
886 }
887 },
888 "fieldConfig": {
889 "defaults": {
890 "thresholds": {
891 "mode": "absolute",
892 "steps": [
893 {
894 "value": 0,
895 "color": "green"
896 },
897 {
898 "value": 80,
899 "color": "red"
900 }
901 ]
902 },
903 "color": {
904 "mode": "palette-classic"
905 },
906 "custom": {
907 "axisBorderShow": false,
908 "axisCenteredZero": false,
909 "axisColorMode": "text",
910 "axisLabel": "",
911 "axisPlacement": "auto",
912 "barAlignment": 0,
913 "barWidthFactor": 0.6,
914 "drawStyle": "line",
915 "fillOpacity": 10,
916 "gradientMode": "none",
917 "hideFrom": {
918 "legend": false,
919 "tooltip": false,
920 "viz": false
921 },
922 "insertNulls": false,
923 "lineInterpolation": "smooth",
924 "lineWidth": 1,
925 "pointSize": 5,
926 "scaleDistribution": {
927 "type": "linear"
928 },
929 "showPoints": "auto",
930 "showValues": false,
931 "spanNulls": false,
932 "stacking": {
933 "group": "A",
934 "mode": "none"
935 },
936 "thresholdsStyle": {
937 "mode": "off"
938 }
939 }
940 },
941 "overrides": []
942 }
943 }
944 }
945 }
946 },
947 "panel-14": {
948 "kind": "Panel",
949 "spec": {
950 "id": 14,
951 "title": "vmstat",
952 "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 — процессор загружен полностью.",
953 "links": [],
954 "data": {
955 "kind": "QueryGroup",
956 "spec": {
957 "queries": [
958 {
959 "kind": "PanelQuery",
960 "spec": {
961 "query": {
962 "kind": "DataQuery",
963 "group": "influxdb",
964 "version": "v0",
965 "spec": {
966 "alias": "si",
967 "groupBy": [
968 {
969 "params": [
970 "$interval"
971 ],
972 "type": "time"
973 },
974 {
975 "params": [
976 "null"
977 ],
978 "type": "fill"
979 }
980 ],
981 "measurement": "host_vmstat",
982 "orderByTime": "ASC",
983 "policy": "default",
984 "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)",
985 "rawQuery": false,
986 "resultFormat": "time_series",
987 "select": [
988 [
989 {
990 "params": [
991 "si"
992 ],
993 "type": "field"
994 },
995 {
996 "params": [],
997 "type": "sum"
998 }
999 ]
1000 ],
1001 "tags": []
1002 },
1003 "labels": {
1004 "grafana.app/export-label": "influxdb-1"
1005 }
1006 },
1007 "refId": "A",
1008 "hidden": false
1009 }
1010 },
1011 {
1012 "kind": "PanelQuery",
1013 "spec": {
1014 "query": {
1015 "kind": "DataQuery",
1016 "group": "influxdb",
1017 "version": "v0",
1018 "spec": {
1019 "alias": "so",
1020 "groupBy": [
1021 {
1022 "params": [
1023 "$interval"
1024 ],
1025 "type": "time"
1026 },
1027 {
1028 "params": [
1029 "null"
1030 ],
1031 "type": "fill"
1032 }
1033 ],
1034 "measurement": "host_vmstat",
1035 "orderByTime": "ASC",
1036 "policy": "default",
1037 "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)",
1038 "rawQuery": false,
1039 "resultFormat": "time_series",
1040 "select": [
1041 [
1042 {
1043 "params": [
1044 "so"
1045 ],
1046 "type": "field"
1047 },
1048 {
1049 "params": [],
1050 "type": "sum"
1051 }
1052 ]
1053 ],
1054 "tags": []
1055 },
1056 "labels": {
1057 "grafana.app/export-label": "influxdb-1"
1058 }
1059 },
1060 "refId": "E",
1061 "hidden": false
1062 }
1063 },
1064 {
1065 "kind": "PanelQuery",
1066 "spec": {
1067 "query": {
1068 "kind": "DataQuery",
1069 "group": "influxdb",
1070 "version": "v0",
1071 "spec": {
1072 "alias": "bi",
1073 "groupBy": [
1074 {
1075 "params": [
1076 "$interval"
1077 ],
1078 "type": "time"
1079 },
1080 {
1081 "params": [
1082 "null"
1083 ],
1084 "type": "fill"
1085 }
1086 ],
1087 "measurement": "host_vmstat",
1088 "orderByTime": "ASC",
1089 "policy": "default",
1090 "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)",
1091 "rawQuery": false,
1092 "resultFormat": "time_series",
1093 "select": [
1094 [
1095 {
1096 "params": [
1097 "bi"
1098 ],
1099 "type": "field"
1100 },
1101 {
1102 "params": [],
1103 "type": "sum"
1104 }
1105 ]
1106 ],
1107 "tags": []
1108 },
1109 "labels": {
1110 "grafana.app/export-label": "influxdb-1"
1111 }
1112 },
1113 "refId": "B",
1114 "hidden": false
1115 }
1116 },
1117 {
1118 "kind": "PanelQuery",
1119 "spec": {
1120 "query": {
1121 "kind": "DataQuery",
1122 "group": "influxdb",
1123 "version": "v0",
1124 "spec": {
1125 "alias": "bo",
1126 "groupBy": [
1127 {
1128 "params": [
1129 "$interval"
1130 ],
1131 "type": "time"
1132 },
1133 {
1134 "params": [
1135 "null"
1136 ],
1137 "type": "fill"
1138 }
1139 ],
1140 "measurement": "host_vmstat",
1141 "orderByTime": "ASC",
1142 "policy": "default",
1143 "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)",
1144 "rawQuery": false,
1145 "resultFormat": "time_series",
1146 "select": [
1147 [
1148 {
1149 "params": [
1150 "bo"
1151 ],
1152 "type": "field"
1153 },
1154 {
1155 "params": [],
1156 "type": "sum"
1157 }
1158 ]
1159 ],
1160 "tags": []
1161 },
1162 "labels": {
1163 "grafana.app/export-label": "influxdb-1"
1164 }
1165 },
1166 "refId": "F",
1167 "hidden": false
1168 }
1169 }
1170 ],
1171 "transformations": [],
1172 "queryOptions": {}
1173 }
1174 },
1175 "vizConfig": {
1176 "kind": "VizConfig",
1177 "group": "timeseries",
1178 "version": "13.0.1+security-01",
1179 "spec": {
1180 "options": {
1181 "annotations": {
1182 "clustering": -1,
1183 "multiLane": false
1184 },
1185 "legend": {
1186 "calcs": [],
1187 "displayMode": "list",
1188 "placement": "bottom",
1189 "showLegend": true
1190 },
1191 "tooltip": {
1192 "hideZeros": false,
1193 "mode": "single",
1194 "sort": "none"
1195 }
1196 },
1197 "fieldConfig": {
1198 "defaults": {
1199 "thresholds": {
1200 "mode": "absolute",
1201 "steps": [
1202 {
1203 "value": 0,
1204 "color": "green"
1205 },
1206 {
1207 "value": 80,
1208 "color": "red"
1209 }
1210 ]
1211 },
1212 "color": {
1213 "mode": "palette-classic"
1214 },
1215 "custom": {
1216 "axisBorderShow": false,
1217 "axisCenteredZero": false,
1218 "axisColorMode": "text",
1219 "axisLabel": "",
1220 "axisPlacement": "auto",
1221 "barAlignment": 0,
1222 "barWidthFactor": 0.6,
1223 "drawStyle": "line",
1224 "fillOpacity": 10,
1225 "gradientMode": "none",
1226 "hideFrom": {
1227 "legend": false,
1228 "tooltip": false,
1229 "viz": false
1230 },
1231 "insertNulls": false,
1232 "lineInterpolation": "smooth",
1233 "lineWidth": 1,
1234 "pointSize": 5,
1235 "scaleDistribution": {
1236 "type": "linear"
1237 },
1238 "showPoints": "auto",
1239 "showValues": false,
1240 "spanNulls": false,
1241 "stacking": {
1242 "group": "A",
1243 "mode": "none"
1244 },
1245 "thresholdsStyle": {
1246 "mode": "off"
1247 }
1248 }
1249 },
1250 "overrides": []
1251 }
1252 }
1253 }
1254 }
1255 },
1256 "panel-15": {
1257 "kind": "Panel",
1258 "spec": {
1259 "id": 15,
1260 "title": "pidstat",
1261 "description": "minflt/s = Скорость работы с ОЗУ. Сколько раз в секунду процесс запрашивал данные, \n которые ядро Linux успешно выдало из оперативной памяти (из кэша).\n Высокое значение — это норма при активных вычислениях или LDAP-запросах.\n\nmajflt/s = Скорость просадки на диск. Сколько раз в секунду процесс лез за данными \n на физический диск (или в SWAP), потому что их не оказалость в ОЗУ.\n В идеале должно быть равно 0. Если число растет — сервер сильно тормозит.\n\n%MEM = Процент ОЗУ. Доля оперативной памяти сервера, которую съел этот PID.",
1262 "links": [],
1263 "data": {
1264 "kind": "QueryGroup",
1265 "spec": {
1266 "queries": [
1267 {
1268 "kind": "PanelQuery",
1269 "spec": {
1270 "query": {
1271 "kind": "DataQuery",
1272 "group": "influxdb",
1273 "version": "v0",
1274 "spec": {
1275 "alias": "minfit",
1276 "groupBy": [
1277 {
1278 "params": [
1279 "$interval"
1280 ],
1281 "type": "time"
1282 },
1283 {
1284 "params": [
1285 "comm::tag"
1286 ],
1287 "type": "tag"
1288 },
1289 {
1290 "params": [
1291 "null"
1292 ],
1293 "type": "fill"
1294 }
1295 ],
1296 "measurement": "samba_pidstat",
1297 "orderByTime": "ASC",
1298 "policy": "default",
1299 "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)",
1300 "rawQuery": false,
1301 "resultFormat": "time_series",
1302 "select": [
1303 [
1304 {
1305 "params": [
1306 "minflt"
1307 ],
1308 "type": "field"
1309 },
1310 {
1311 "params": [],
1312 "type": "mean"
1313 }
1314 ]
1315 ],
1316 "tags": []
1317 },
1318 "labels": {
1319 "grafana.app/export-label": "influxdb-1"
1320 }
1321 },
1322 "refId": "A",
1323 "hidden": false
1324 }
1325 },
1326 {
1327 "kind": "PanelQuery",
1328 "spec": {
1329 "query": {
1330 "kind": "DataQuery",
1331 "group": "influxdb",
1332 "version": "v0",
1333 "spec": {
1334 "alias": "majfit",
1335 "groupBy": [
1336 {
1337 "params": [
1338 "$interval"
1339 ],
1340 "type": "time"
1341 },
1342 {
1343 "params": [
1344 "comm::tag"
1345 ],
1346 "type": "tag"
1347 },
1348 {
1349 "params": [
1350 "null"
1351 ],
1352 "type": "fill"
1353 }
1354 ],
1355 "measurement": "samba_pidstat",
1356 "orderByTime": "ASC",
1357 "policy": "default",
1358 "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)",
1359 "rawQuery": false,
1360 "resultFormat": "time_series",
1361 "select": [
1362 [
1363 {
1364 "params": [
1365 "majflt"
1366 ],
1367 "type": "field"
1368 },
1369 {
1370 "params": [],
1371 "type": "median"
1372 }
1373 ]
1374 ],
1375 "tags": []
1376 },
1377 "labels": {
1378 "grafana.app/export-label": "influxdb-1"
1379 }
1380 },
1381 "refId": "B",
1382 "hidden": false
1383 }
1384 }
1385 ],
1386 "transformations": [],
1387 "queryOptions": {}
1388 }
1389 },
1390 "vizConfig": {
1391 "kind": "VizConfig",
1392 "group": "timeseries",
1393 "version": "13.0.1+security-01",
1394 "spec": {
1395 "options": {
1396 "annotations": {
1397 "clustering": -1,
1398 "multiLane": false
1399 },
1400 "legend": {
1401 "calcs": [],
1402 "displayMode": "list",
1403 "placement": "bottom",
1404 "showLegend": true
1405 },
1406 "tooltip": {
1407 "hideZeros": false,
1408 "mode": "single",
1409 "sort": "none"
1410 }
1411 },
1412 "fieldConfig": {
1413 "defaults": {
1414 "thresholds": {
1415 "mode": "absolute",
1416 "steps": [
1417 {
1418 "value": 0,
1419 "color": "green"
1420 },
1421 {
1422 "value": 80,
1423 "color": "red"
1424 }
1425 ]
1426 },
1427 "color": {
1428 "mode": "palette-classic"
1429 },
1430 "custom": {
1431 "axisBorderShow": false,
1432 "axisCenteredZero": false,
1433 "axisColorMode": "text",
1434 "axisLabel": "",
1435 "axisPlacement": "auto",
1436 "barAlignment": 0,
1437 "barWidthFactor": 0.6,
1438 "drawStyle": "line",
1439 "fillOpacity": 10,
1440 "gradientMode": "none",
1441 "hideFrom": {
1442 "legend": false,
1443 "tooltip": false,
1444 "viz": false
1445 },
1446 "insertNulls": false,
1447 "lineInterpolation": "smooth",
1448 "lineWidth": 1,
1449 "pointSize": 5,
1450 "scaleDistribution": {
1451 "type": "linear"
1452 },
1453 "showPoints": "auto",
1454 "showValues": false,
1455 "spanNulls": false,
1456 "stacking": {
1457 "group": "A",
1458 "mode": "none"
1459 },
1460 "thresholdsStyle": {
1461 "mode": "off"
1462 }
1463 }
1464 },
1465 "overrides": [
1466 {
1467 "__systemRef": "hideSeriesFrom",
1468 "matcher": {
1469 "id": "byNames",
1470 "options": {
1471 "mode": "exclude",
1472 "names": [
1473 "MEM"
1474 ],
1475 "prefix": "All except:",
1476 "readOnly": true
1477 }
1478 },
1479 "properties": [
1480 {
1481 "id": "custom.hideFrom",
1482 "value": {
1483 "legend": false,
1484 "tooltip": true,
1485 "viz": true
1486 }
1487 }
1488 ]
1489 }
1490 ]
1491 }
1492 }
1493 }
1494 }
1495 },
1496 "panel-16": {
1497 "kind": "Panel",
1498 "spec": {
1499 "id": 16,
1500 "title": "ldb ops operation",
1501 "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 (Фиксация транзакции и принудительный сброс на диск)",
1502 "links": [],
1503 "data": {
1504 "kind": "QueryGroup",
1505 "spec": {
1506 "queries": [
1507 {
1508 "kind": "PanelQuery",
1509 "spec": {
1510 "query": {
1511 "kind": "DataQuery",
1512 "group": "influxdb",
1513 "version": "v0",
1514 "spec": {
1515 "groupBy": [
1516 {
1517 "params": [
1518 "$interval"
1519 ],
1520 "type": "time"
1521 },
1522 {
1523 "params": [
1524 "action::tag"
1525 ],
1526 "type": "tag"
1527 },
1528 {
1529 "params": [
1530 "null"
1531 ],
1532 "type": "fill"
1533 }
1534 ],
1535 "measurement": "samba_file_access",
1536 "orderByTime": "ASC",
1537 "policy": "default",
1538 "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)",
1539 "rawQuery": false,
1540 "resultFormat": "time_series",
1541 "select": [
1542 [
1543 {
1544 "params": [
1545 "path"
1546 ],
1547 "type": "field"
1548 },
1549 {
1550 "params": [],
1551 "type": "count"
1552 }
1553 ]
1554 ],
1555 "tags": []
1556 },
1557 "labels": {
1558 "grafana.app/export-label": "influxdb-1"
1559 }
1560 },
1561 "refId": "A",
1562 "hidden": false
1563 }
1564 }
1565 ],
1566 "transformations": [],
1567 "queryOptions": {}
1568 }
1569 },
1570 "vizConfig": {
1571 "kind": "VizConfig",
1572 "group": "timeseries",
1573 "version": "13.0.1+security-01",
1574 "spec": {
1575 "options": {
1576 "annotations": {
1577 "clustering": -1,
1578 "multiLane": false
1579 },
1580 "legend": {
1581 "calcs": [],
1582 "displayMode": "list",
1583 "placement": "bottom",
1584 "showLegend": true
1585 },
1586 "tooltip": {
1587 "hideZeros": false,
1588 "mode": "single",
1589 "sort": "none"
1590 }
1591 },
1592 "fieldConfig": {
1593 "defaults": {
1594 "thresholds": {
1595 "mode": "absolute",
1596 "steps": [
1597 {
1598 "value": 0,
1599 "color": "green"
1600 },
1601 {
1602 "value": 80,
1603 "color": "red"
1604 }
1605 ]
1606 },
1607 "color": {
1608 "mode": "palette-classic"
1609 },
1610 "custom": {
1611 "axisBorderShow": false,
1612 "axisCenteredZero": false,
1613 "axisColorMode": "text",
1614 "axisLabel": "",
1615 "axisPlacement": "auto",
1616 "barAlignment": 0,
1617 "barWidthFactor": 0.6,
1618 "drawStyle": "line",
1619 "fillOpacity": 0,
1620 "gradientMode": "none",
1621 "hideFrom": {
1622 "legend": false,
1623 "tooltip": false,
1624 "viz": false
1625 },
1626 "insertNulls": false,
1627 "lineInterpolation": "linear",
1628 "lineWidth": 1,
1629 "pointSize": 5,
1630 "scaleDistribution": {
1631 "type": "linear"
1632 },
1633 "showPoints": "auto",
1634 "showValues": false,
1635 "spanNulls": false,
1636 "stacking": {
1637 "group": "A",
1638 "mode": "none"
1639 },
1640 "thresholdsStyle": {
1641 "mode": "off"
1642 }
1643 }
1644 },
1645 "overrides": []
1646 }
1647 }
1648 }
1649 }
1650 },
1651 "panel-17": {
1652 "kind": "Panel",
1653 "spec": {
1654 "id": 17,
1655 "title": "Iostat await",
1656 "description": "",
1657 "links": [],
1658 "data": {
1659 "kind": "QueryGroup",
1660 "spec": {
1661 "queries": [
1662 {
1663 "kind": "PanelQuery",
1664 "spec": {
1665 "query": {
1666 "kind": "DataQuery",
1667 "group": "influxdb",
1668 "version": "v0",
1669 "spec": {
1670 "alias": "$tag_device f_await",
1671 "groupBy": [
1672 {
1673 "params": [
1674 "$interval"
1675 ],
1676 "type": "time"
1677 },
1678 {
1679 "params": [
1680 "device::tag"
1681 ],
1682 "type": "tag"
1683 },
1684 {
1685 "params": [
1686 "null"
1687 ],
1688 "type": "fill"
1689 }
1690 ],
1691 "measurement": "host_iostat",
1692 "orderByTime": "ASC",
1693 "policy": "default",
1694 "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)",
1695 "rawQuery": false,
1696 "resultFormat": "time_series",
1697 "select": [
1698 [
1699 {
1700 "params": [
1701 "f_await"
1702 ],
1703 "type": "field"
1704 },
1705 {
1706 "params": [],
1707 "type": "mean"
1708 }
1709 ]
1710 ],
1711 "tags": []
1712 },
1713 "labels": {
1714 "grafana.app/export-label": "influxdb-1"
1715 }
1716 },
1717 "refId": "A",
1718 "hidden": false
1719 }
1720 },
1721 {
1722 "kind": "PanelQuery",
1723 "spec": {
1724 "query": {
1725 "kind": "DataQuery",
1726 "group": "influxdb",
1727 "version": "v0",
1728 "spec": {
1729 "alias": "$tag_device r_await",
1730 "groupBy": [
1731 {
1732 "params": [
1733 "$interval"
1734 ],
1735 "type": "time"
1736 },
1737 {
1738 "params": [
1739 "device::tag"
1740 ],
1741 "type": "tag"
1742 },
1743 {
1744 "params": [
1745 "null"
1746 ],
1747 "type": "fill"
1748 }
1749 ],
1750 "measurement": "host_iostat",
1751 "orderByTime": "ASC",
1752 "policy": "default",
1753 "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)",
1754 "rawQuery": false,
1755 "resultFormat": "time_series",
1756 "select": [
1757 [
1758 {
1759 "params": [
1760 "r_await"
1761 ],
1762 "type": "field"
1763 },
1764 {
1765 "params": [],
1766 "type": "mean"
1767 }
1768 ]
1769 ],
1770 "tags": []
1771 },
1772 "labels": {
1773 "grafana.app/export-label": "influxdb-1"
1774 }
1775 },
1776 "refId": "B",
1777 "hidden": false
1778 }
1779 },
1780 {
1781 "kind": "PanelQuery",
1782 "spec": {
1783 "query": {
1784 "kind": "DataQuery",
1785 "group": "influxdb",
1786 "version": "v0",
1787 "spec": {
1788 "alias": "$tag_device w_await",
1789 "groupBy": [
1790 {
1791 "params": [
1792 "$interval"
1793 ],
1794 "type": "time"
1795 },
1796 {
1797 "params": [
1798 "device::tag"
1799 ],
1800 "type": "tag"
1801 },
1802 {
1803 "params": [
1804 "null"
1805 ],
1806 "type": "fill"
1807 }
1808 ],
1809 "measurement": "host_iostat",
1810 "orderByTime": "ASC",
1811 "policy": "default",
1812 "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)",
1813 "rawQuery": false,
1814 "resultFormat": "time_series",
1815 "select": [
1816 [
1817 {
1818 "params": [
1819 "w_await"
1820 ],
1821 "type": "field"
1822 },
1823 {
1824 "params": [],
1825 "type": "mean"
1826 }
1827 ]
1828 ],
1829 "tags": []
1830 },
1831 "labels": {
1832 "grafana.app/export-label": "influxdb-1"
1833 }
1834 },
1835 "refId": "C",
1836 "hidden": false
1837 }
1838 }
1839 ],
1840 "transformations": [],
1841 "queryOptions": {}
1842 }
1843 },
1844 "vizConfig": {
1845 "kind": "VizConfig",
1846 "group": "timeseries",
1847 "version": "13.0.1+security-01",
1848 "spec": {
1849 "options": {
1850 "annotations": {
1851 "clustering": -1,
1852 "multiLane": false
1853 },
1854 "legend": {
1855 "calcs": [],
1856 "displayMode": "list",
1857 "placement": "bottom",
1858 "showLegend": true
1859 },
1860 "tooltip": {
1861 "hideZeros": false,
1862 "mode": "single",
1863 "sort": "none"
1864 }
1865 },
1866 "fieldConfig": {
1867 "defaults": {
1868 "thresholds": {
1869 "mode": "absolute",
1870 "steps": [
1871 {
1872 "value": 0,
1873 "color": "green"
1874 },
1875 {
1876 "value": 80,
1877 "color": "red"
1878 }
1879 ]
1880 },
1881 "color": {
1882 "mode": "palette-classic"
1883 },
1884 "custom": {
1885 "axisBorderShow": false,
1886 "axisCenteredZero": false,
1887 "axisColorMode": "text",
1888 "axisLabel": "",
1889 "axisPlacement": "auto",
1890 "barAlignment": 0,
1891 "barWidthFactor": 0.6,
1892 "drawStyle": "line",
1893 "fillOpacity": 0,
1894 "gradientMode": "none",
1895 "hideFrom": {
1896 "legend": false,
1897 "tooltip": false,
1898 "viz": false
1899 },
1900 "insertNulls": false,
1901 "lineInterpolation": "linear",
1902 "lineWidth": 1,
1903 "pointSize": 5,
1904 "scaleDistribution": {
1905 "type": "linear"
1906 },
1907 "showPoints": "auto",
1908 "showValues": false,
1909 "spanNulls": false,
1910 "stacking": {
1911 "group": "A",
1912 "mode": "none"
1913 },
1914 "thresholdsStyle": {
1915 "mode": "off"
1916 }
1917 }
1918 },
1919 "overrides": []
1920 }
1921 }
1922 }
1923 }
1924 },
1925 "panel-18": {
1926 "kind": "Panel",
1927 "spec": {
1928 "id": 18,
1929 "title": "pidstat mem",
1930 "description": "minflt/s = Скорость работы с ОЗУ. Сколько раз в секунду процесс запрашивал данные, \n которые ядро Linux успешно выдало из оперативной памяти (из кэша).\n Высокое значение — это норма при активных вычислениях или LDAP-запросах.\n\nmajflt/s = Скорость просадки на диск. Сколько раз в секунду процесс лез за данными \n на физический диск (или в SWAP), потому что их не оказалость в ОЗУ.\n В идеале должно быть равно 0. Если число растет — сервер сильно тормозит.\n\n%MEM = Процент ОЗУ. Доля оперативной памяти сервера, которую съел этот PID.",
1931 "links": [],
1932 "data": {
1933 "kind": "QueryGroup",
1934 "spec": {
1935 "queries": [
1936 {
1937 "kind": "PanelQuery",
1938 "spec": {
1939 "query": {
1940 "kind": "DataQuery",
1941 "group": "influxdb",
1942 "version": "v0",
1943 "spec": {
1944 "alias": "%MEM",
1945 "groupBy": [
1946 {
1947 "params": [
1948 "$interval"
1949 ],
1950 "type": "time"
1951 },
1952 {
1953 "params": [
1954 "comm::tag"
1955 ],
1956 "type": "tag"
1957 },
1958 {
1959 "params": [
1960 "null"
1961 ],
1962 "type": "fill"
1963 }
1964 ],
1965 "measurement": "samba_pidstat",
1966 "orderByTime": "ASC",
1967 "policy": "default",
1968 "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)",
1969 "rawQuery": false,
1970 "resultFormat": "time_series",
1971 "select": [
1972 [
1973 {
1974 "params": [
1975 "mem"
1976 ],
1977 "type": "field"
1978 },
1979 {
1980 "params": [],
1981 "type": "median"
1982 }
1983 ]
1984 ],
1985 "tags": []
1986 },
1987 "labels": {
1988 "grafana.app/export-label": "influxdb-1"
1989 }
1990 },
1991 "refId": "C",
1992 "hidden": false
1993 }
1994 }
1995 ],
1996 "transformations": [],
1997 "queryOptions": {}
1998 }
1999 },
2000 "vizConfig": {
2001 "kind": "VizConfig",
2002 "group": "timeseries",
2003 "version": "13.0.1+security-01",
2004 "spec": {
2005 "options": {
2006 "annotations": {
2007 "clustering": -1,
2008 "multiLane": false
2009 },
2010 "legend": {
2011 "calcs": [],
2012 "displayMode": "list",
2013 "placement": "bottom",
2014 "showLegend": true
2015 },
2016 "tooltip": {
2017 "hideZeros": false,
2018 "mode": "single",
2019 "sort": "none"
2020 }
2021 },
2022 "fieldConfig": {
2023 "defaults": {
2024 "thresholds": {
2025 "mode": "absolute",
2026 "steps": [
2027 {
2028 "value": 0,
2029 "color": "green"
2030 },
2031 {
2032 "value": 80,
2033 "color": "red"
2034 }
2035 ]
2036 },
2037 "color": {
2038 "mode": "palette-classic"
2039 },
2040 "custom": {
2041 "axisBorderShow": false,
2042 "axisCenteredZero": false,
2043 "axisColorMode": "text",
2044 "axisLabel": "",
2045 "axisPlacement": "auto",
2046 "barAlignment": 0,
2047 "barWidthFactor": 0.6,
2048 "drawStyle": "line",
2049 "fillOpacity": 10,
2050 "gradientMode": "none",
2051 "hideFrom": {
2052 "legend": false,
2053 "tooltip": false,
2054 "viz": false
2055 },
2056 "insertNulls": false,
2057 "lineInterpolation": "smooth",
2058 "lineWidth": 1,
2059 "pointSize": 5,
2060 "scaleDistribution": {
2061 "type": "linear"
2062 },
2063 "showPoints": "auto",
2064 "showValues": false,
2065 "spanNulls": false,
2066 "stacking": {
2067 "group": "A",
2068 "mode": "none"
2069 },
2070 "thresholdsStyle": {
2071 "mode": "off"
2072 }
2073 }
2074 },
2075 "overrides": []
2076 }
2077 }
2078 }
2079 }
2080 },
2081 "panel-19": {
2082 "kind": "Panel",
2083 "spec": {
2084 "id": 19,
2085 "title": "RSS",
2086 "description": "minflt/s = Скорость работы с ОЗУ. Сколько раз в секунду процесс запрашивал данные, \n которые ядро Linux успешно выдало из оперативной памяти (из кэша).\n Высокое значение — это норма при активных вычислениях или LDAP-запросах.\n\nmajflt/s = Скорость просадки на диск. Сколько раз в секунду процесс лез за данными \n на физический диск (или в SWAP), потому что их не оказалость в ОЗУ.\n В идеале должно быть равно 0. Если число растет — сервер сильно тормозит.\n\n%MEM = Процент ОЗУ. Доля оперативной памяти сервера, которую съел этот PID.",
2087 "links": [],
2088 "data": {
2089 "kind": "QueryGroup",
2090 "spec": {
2091 "queries": [
2092 {
2093 "kind": "PanelQuery",
2094 "spec": {
2095 "query": {
2096 "kind": "DataQuery",
2097 "group": "influxdb",
2098 "version": "v0",
2099 "spec": {
2100 "alias": "RSS",
2101 "groupBy": [
2102 {
2103 "params": [
2104 "$interval"
2105 ],
2106 "type": "time"
2107 },
2108 {
2109 "params": [
2110 "comm::tag"
2111 ],
2112 "type": "tag"
2113 },
2114 {
2115 "params": [
2116 "null"
2117 ],
2118 "type": "fill"
2119 }
2120 ],
2121 "measurement": "samba_pidstat",
2122 "orderByTime": "ASC",
2123 "policy": "default",
2124 "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)",
2125 "rawQuery": false,
2126 "resultFormat": "time_series",
2127 "select": [
2128 [
2129 {
2130 "params": [
2131 "rss"
2132 ],
2133 "type": "field"
2134 },
2135 {
2136 "params": [],
2137 "type": "median"
2138 }
2139 ]
2140 ],
2141 "tags": []
2142 },
2143 "labels": {
2144 "grafana.app/export-label": "influxdb-1"
2145 }
2146 },
2147 "refId": "C",
2148 "hidden": false
2149 }
2150 }
2151 ],
2152 "transformations": [],
2153 "queryOptions": {}
2154 }
2155 },
2156 "vizConfig": {
2157 "kind": "VizConfig",
2158 "group": "timeseries",
2159 "version": "13.0.1+security-01",
2160 "spec": {
2161 "options": {
2162 "annotations": {
2163 "clustering": -1,
2164 "multiLane": false
2165 },
2166 "legend": {
2167 "calcs": [],
2168 "displayMode": "list",
2169 "placement": "bottom",
2170 "showLegend": true
2171 },
2172 "tooltip": {
2173 "hideZeros": false,
2174 "mode": "single",
2175 "sort": "none"
2176 }
2177 },
2178 "fieldConfig": {
2179 "defaults": {
2180 "thresholds": {
2181 "mode": "absolute",
2182 "steps": [
2183 {
2184 "value": 0,
2185 "color": "green"
2186 },
2187 {
2188 "value": 80,
2189 "color": "red"
2190 }
2191 ]
2192 },
2193 "color": {
2194 "mode": "palette-classic"
2195 },
2196 "custom": {
2197 "axisBorderShow": false,
2198 "axisCenteredZero": false,
2199 "axisColorMode": "text",
2200 "axisLabel": "",
2201 "axisPlacement": "auto",
2202 "barAlignment": 0,
2203 "barWidthFactor": 0.6,
2204 "drawStyle": "line",
2205 "fillOpacity": 10,
2206 "gradientMode": "none",
2207 "hideFrom": {
2208 "legend": false,
2209 "tooltip": false,
2210 "viz": false
2211 },
2212 "insertNulls": false,
2213 "lineInterpolation": "smooth",
2214 "lineWidth": 1,
2215 "pointSize": 5,
2216 "scaleDistribution": {
2217 "type": "linear"
2218 },
2219 "showPoints": "auto",
2220 "showValues": false,
2221 "spanNulls": false,
2222 "stacking": {
2223 "group": "A",
2224 "mode": "none"
2225 },
2226 "thresholdsStyle": {
2227 "mode": "off"
2228 }
2229 }
2230 },
2231 "overrides": []
2232 }
2233 }
2234 }
2235 }
2236 },
2237 "panel-2": {
2238 "kind": "Panel",
2239 "spec": {
2240 "id": 2,
2241 "title": "DSDB: изменения по операциям",
2242 "description": "Число изменений объектов каталога (samba_dsdb), разбивка по типу операции.",
2243 "links": [],
2244 "data": {
2245 "kind": "QueryGroup",
2246 "spec": {
2247 "queries": [
2248 {
2249 "kind": "PanelQuery",
2250 "spec": {
2251 "query": {
2252 "kind": "DataQuery",
2253 "group": "influxdb",
2254 "version": "v0",
2255 "spec": {
2256 "groupBy": [],
2257 "measurement": "samba_dsdb",
2258 "orderByTime": "ASC",
2259 "policy": "default",
2260 "query": "SELECT count(\"status_code\") FROM \"samba_dsdb\" WHERE $timeFilter GROUP BY time($interval), \"operation\"::tag fill(null)",
2261 "rawQuery": true,
2262 "resultFormat": "time_series",
2263 "select": [],
2264 "tags": []
2265 },
2266 "labels": {
2267 "grafana.app/export-label": "influxdb-1"
2268 }
2269 },
2270 "refId": "A",
2271 "hidden": false
2272 }
2273 }
2274 ],
2275 "transformations": [],
2276 "queryOptions": {}
2277 }
2278 },
2279 "vizConfig": {
2280 "kind": "VizConfig",
2281 "group": "timeseries",
2282 "version": "13.0.1+security-01",
2283 "spec": {
2284 "options": {
2285 "annotations": {
2286 "clustering": -1,
2287 "multiLane": false
2288 },
2289 "legend": {
2290 "calcs": [],
2291 "displayMode": "list",
2292 "placement": "bottom",
2293 "showLegend": true
2294 },
2295 "tooltip": {
2296 "hideZeros": false,
2297 "mode": "multi",
2298 "sort": "desc"
2299 }
2300 },
2301 "fieldConfig": {
2302 "defaults": {
2303 "thresholds": {
2304 "mode": "absolute",
2305 "steps": [
2306 {
2307 "value": 0,
2308 "color": "green"
2309 },
2310 {
2311 "value": 80,
2312 "color": "red"
2313 }
2314 ]
2315 },
2316 "color": {
2317 "mode": "palette-classic"
2318 },
2319 "custom": {
2320 "axisBorderShow": false,
2321 "axisCenteredZero": false,
2322 "axisColorMode": "text",
2323 "axisLabel": "",
2324 "axisPlacement": "auto",
2325 "barAlignment": 0,
2326 "barWidthFactor": 0.6,
2327 "drawStyle": "bars",
2328 "fillOpacity": 50,
2329 "gradientMode": "none",
2330 "hideFrom": {
2331 "legend": false,
2332 "tooltip": false,
2333 "viz": false
2334 },
2335 "insertNulls": false,
2336 "lineInterpolation": "linear",
2337 "lineWidth": 1,
2338 "pointSize": 5,
2339 "scaleDistribution": {
2340 "type": "linear"
2341 },
2342 "showPoints": "auto",
2343 "showValues": false,
2344 "spanNulls": false,
2345 "stacking": {
2346 "group": "A",
2347 "mode": "normal"
2348 },
2349 "thresholdsStyle": {
2350 "mode": "off"
2351 }
2352 }
2353 },
2354 "overrides": []
2355 }
2356 }
2357 }
2358 }
2359 },
2360 "panel-20": {
2361 "kind": "Panel",
2362 "spec": {
2363 "id": 20,
2364 "title": "ldb ops",
2365 "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 (Фиксация транзакции и принудительный сброс на диск)",
2366 "links": [],
2367 "data": {
2368 "kind": "QueryGroup",
2369 "spec": {
2370 "queries": [
2371 {
2372 "kind": "PanelQuery",
2373 "spec": {
2374 "query": {
2375 "kind": "DataQuery",
2376 "group": "influxdb",
2377 "version": "v0",
2378 "spec": {
2379 "groupBy": [
2380 {
2381 "params": [
2382 "$interval"
2383 ],
2384 "type": "time"
2385 },
2386 {
2387 "params": [
2388 "null"
2389 ],
2390 "type": "fill"
2391 }
2392 ],
2393 "measurement": "samba_file_access",
2394 "orderByTime": "ASC",
2395 "policy": "default",
2396 "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)",
2397 "rawQuery": false,
2398 "resultFormat": "time_series",
2399 "select": [
2400 [
2401 {
2402 "params": [
2403 "path"
2404 ],
2405 "type": "field"
2406 },
2407 {
2408 "params": [],
2409 "type": "count"
2410 }
2411 ]
2412 ],
2413 "tags": []
2414 },
2415 "labels": {
2416 "grafana.app/export-label": "influxdb-1"
2417 }
2418 },
2419 "refId": "A",
2420 "hidden": false
2421 }
2422 }
2423 ],
2424 "transformations": [],
2425 "queryOptions": {}
2426 }
2427 },
2428 "vizConfig": {
2429 "kind": "VizConfig",
2430 "group": "timeseries",
2431 "version": "13.0.1+security-01",
2432 "spec": {
2433 "options": {
2434 "annotations": {
2435 "clustering": -1,
2436 "multiLane": false
2437 },
2438 "legend": {
2439 "calcs": [],
2440 "displayMode": "list",
2441 "placement": "bottom",
2442 "showLegend": true
2443 },
2444 "tooltip": {
2445 "hideZeros": false,
2446 "mode": "single",
2447 "sort": "none"
2448 }
2449 },
2450 "fieldConfig": {
2451 "defaults": {
2452 "thresholds": {
2453 "mode": "absolute",
2454 "steps": [
2455 {
2456 "value": 0,
2457 "color": "green"
2458 },
2459 {
2460 "value": 80,
2461 "color": "red"
2462 }
2463 ]
2464 },
2465 "color": {
2466 "mode": "palette-classic"
2467 },
2468 "custom": {
2469 "axisBorderShow": false,
2470 "axisCenteredZero": false,
2471 "axisColorMode": "text",
2472 "axisLabel": "",
2473 "axisPlacement": "auto",
2474 "barAlignment": 0,
2475 "barWidthFactor": 0.6,
2476 "drawStyle": "line",
2477 "fillOpacity": 10,
2478 "gradientMode": "none",
2479 "hideFrom": {
2480 "legend": false,
2481 "tooltip": false,
2482 "viz": false
2483 },
2484 "insertNulls": false,
2485 "lineInterpolation": "smooth",
2486 "lineWidth": 1,
2487 "pointSize": 5,
2488 "scaleDistribution": {
2489 "type": "linear"
2490 },
2491 "showPoints": "auto",
2492 "showValues": false,
2493 "spanNulls": false,
2494 "stacking": {
2495 "group": "A",
2496 "mode": "none"
2497 },
2498 "thresholdsStyle": {
2499 "mode": "off"
2500 }
2501 }
2502 },
2503 "overrides": []
2504 }
2505 }
2506 }
2507 }
2508 },
2509 "panel-21": {
2510 "kind": "Panel",
2511 "spec": {
2512 "id": 21,
2513 "title": "ldb ops summ",
2514 "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 (Фиксация транзакции и принудительный сброс на диск)",
2515 "links": [],
2516 "data": {
2517 "kind": "QueryGroup",
2518 "spec": {
2519 "queries": [
2520 {
2521 "kind": "PanelQuery",
2522 "spec": {
2523 "query": {
2524 "kind": "DataQuery",
2525 "group": "influxdb",
2526 "version": "v0",
2527 "spec": {
2528 "groupBy": [
2529 {
2530 "params": [
2531 "$interval"
2532 ],
2533 "type": "time"
2534 },
2535 {
2536 "params": [
2537 "null"
2538 ],
2539 "type": "fill"
2540 }
2541 ],
2542 "measurement": "samba_file_access",
2543 "orderByTime": "ASC",
2544 "policy": "default",
2545 "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)",
2546 "rawQuery": false,
2547 "resultFormat": "time_series",
2548 "select": [
2549 [
2550 {
2551 "params": [
2552 "path"
2553 ],
2554 "type": "field"
2555 },
2556 {
2557 "params": [],
2558 "type": "count"
2559 },
2560 {
2561 "params": [],
2562 "type": "cumulative_sum"
2563 }
2564 ]
2565 ],
2566 "tags": []
2567 },
2568 "labels": {
2569 "grafana.app/export-label": "influxdb-1"
2570 }
2571 },
2572 "refId": "A",
2573 "hidden": false
2574 }
2575 }
2576 ],
2577 "transformations": [],
2578 "queryOptions": {}
2579 }
2580 },
2581 "vizConfig": {
2582 "kind": "VizConfig",
2583 "group": "stat",
2584 "version": "13.0.1+security-01",
2585 "spec": {
2586 "options": {
2587 "colorMode": "value",
2588 "graphMode": "area",
2589 "justifyMode": "auto",
2590 "orientation": "auto",
2591 "percentChangeColorMode": "standard",
2592 "reduceOptions": {
2593 "calcs": [
2594 "lastNotNull"
2595 ],
2596 "fields": "",
2597 "values": false
2598 },
2599 "showPercentChange": false,
2600 "textMode": "auto",
2601 "wideLayout": true
2602 },
2603 "fieldConfig": {
2604 "defaults": {
2605 "thresholds": {
2606 "mode": "absolute",
2607 "steps": [
2608 {
2609 "value": 0,
2610 "color": "green"
2611 },
2612 {
2613 "value": 80,
2614 "color": "red"
2615 }
2616 ]
2617 },
2618 "color": {
2619 "mode": "palette-classic"
2620 }
2621 },
2622 "overrides": []
2623 }
2624 }
2625 }
2626 }
2627 },
2628 "panel-22": {
2629 "kind": "Panel",
2630 "spec": {
2631 "id": 22,
2632 "title": "Iostat kb/s",
2633 "description": "",
2634 "links": [],
2635 "data": {
2636 "kind": "QueryGroup",
2637 "spec": {
2638 "queries": [
2639 {
2640 "kind": "PanelQuery",
2641 "spec": {
2642 "query": {
2643 "kind": "DataQuery",
2644 "group": "influxdb",
2645 "version": "v0",
2646 "spec": {
2647 "alias": "$tag_device d kb/s",
2648 "groupBy": [
2649 {
2650 "params": [
2651 "$interval"
2652 ],
2653 "type": "time"
2654 },
2655 {
2656 "params": [
2657 "device::tag"
2658 ],
2659 "type": "tag"
2660 },
2661 {
2662 "params": [
2663 "null"
2664 ],
2665 "type": "fill"
2666 }
2667 ],
2668 "measurement": "host_iostat",
2669 "orderByTime": "ASC",
2670 "policy": "default",
2671 "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)",
2672 "rawQuery": false,
2673 "resultFormat": "time_series",
2674 "select": [
2675 [
2676 {
2677 "params": [
2678 "dkb_s"
2679 ],
2680 "type": "field"
2681 },
2682 {
2683 "params": [],
2684 "type": "mean"
2685 }
2686 ]
2687 ],
2688 "tags": []
2689 },
2690 "labels": {
2691 "grafana.app/export-label": "influxdb-1"
2692 }
2693 },
2694 "refId": "A",
2695 "hidden": false
2696 }
2697 },
2698 {
2699 "kind": "PanelQuery",
2700 "spec": {
2701 "query": {
2702 "kind": "DataQuery",
2703 "group": "influxdb",
2704 "version": "v0",
2705 "spec": {
2706 "alias": "$tag_device r kb/s",
2707 "groupBy": [
2708 {
2709 "params": [
2710 "$interval"
2711 ],
2712 "type": "time"
2713 },
2714 {
2715 "params": [
2716 "device::tag"
2717 ],
2718 "type": "tag"
2719 },
2720 {
2721 "params": [
2722 "null"
2723 ],
2724 "type": "fill"
2725 }
2726 ],
2727 "measurement": "host_iostat",
2728 "orderByTime": "ASC",
2729 "policy": "default",
2730 "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)",
2731 "rawQuery": false,
2732 "resultFormat": "time_series",
2733 "select": [
2734 [
2735 {
2736 "params": [
2737 "rkb_s"
2738 ],
2739 "type": "field"
2740 },
2741 {
2742 "params": [],
2743 "type": "mean"
2744 }
2745 ]
2746 ],
2747 "tags": []
2748 },
2749 "labels": {
2750 "grafana.app/export-label": "influxdb-1"
2751 }
2752 },
2753 "refId": "B",
2754 "hidden": false
2755 }
2756 },
2757 {
2758 "kind": "PanelQuery",
2759 "spec": {
2760 "query": {
2761 "kind": "DataQuery",
2762 "group": "influxdb",
2763 "version": "v0",
2764 "spec": {
2765 "alias": "$tag_device w kb/s",
2766 "groupBy": [
2767 {
2768 "params": [
2769 "$interval"
2770 ],
2771 "type": "time"
2772 },
2773 {
2774 "params": [
2775 "device::tag"
2776 ],
2777 "type": "tag"
2778 },
2779 {
2780 "params": [
2781 "null"
2782 ],
2783 "type": "fill"
2784 }
2785 ],
2786 "measurement": "host_iostat",
2787 "orderByTime": "ASC",
2788 "policy": "default",
2789 "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)",
2790 "rawQuery": false,
2791 "resultFormat": "time_series",
2792 "select": [
2793 [
2794 {
2795 "params": [
2796 "wkb_s"
2797 ],
2798 "type": "field"
2799 },
2800 {
2801 "params": [],
2802 "type": "mean"
2803 }
2804 ]
2805 ],
2806 "tags": []
2807 },
2808 "labels": {
2809 "grafana.app/export-label": "influxdb-1"
2810 }
2811 },
2812 "refId": "C",
2813 "hidden": false
2814 }
2815 }
2816 ],
2817 "transformations": [],
2818 "queryOptions": {}
2819 }
2820 },
2821 "vizConfig": {
2822 "kind": "VizConfig",
2823 "group": "timeseries",
2824 "version": "13.0.1+security-01",
2825 "spec": {
2826 "options": {
2827 "annotations": {
2828 "clustering": -1,
2829 "multiLane": false
2830 },
2831 "legend": {
2832 "calcs": [],
2833 "displayMode": "list",
2834 "placement": "bottom",
2835 "showLegend": true
2836 },
2837 "tooltip": {
2838 "hideZeros": false,
2839 "mode": "single",
2840 "sort": "none"
2841 }
2842 },
2843 "fieldConfig": {
2844 "defaults": {
2845 "thresholds": {
2846 "mode": "absolute",
2847 "steps": [
2848 {
2849 "value": 0,
2850 "color": "green"
2851 },
2852 {
2853 "value": 80,
2854 "color": "red"
2855 }
2856 ]
2857 },
2858 "color": {
2859 "mode": "palette-classic"
2860 },
2861 "custom": {
2862 "axisBorderShow": false,
2863 "axisCenteredZero": false,
2864 "axisColorMode": "text",
2865 "axisLabel": "",
2866 "axisPlacement": "auto",
2867 "barAlignment": 0,
2868 "barWidthFactor": 0.6,
2869 "drawStyle": "line",
2870 "fillOpacity": 0,
2871 "gradientMode": "none",
2872 "hideFrom": {
2873 "legend": false,
2874 "tooltip": false,
2875 "viz": false
2876 },
2877 "insertNulls": false,
2878 "lineInterpolation": "linear",
2879 "lineWidth": 1,
2880 "pointSize": 5,
2881 "scaleDistribution": {
2882 "type": "linear"
2883 },
2884 "showPoints": "auto",
2885 "showValues": false,
2886 "spanNulls": false,
2887 "stacking": {
2888 "group": "A",
2889 "mode": "none"
2890 },
2891 "thresholdsStyle": {
2892 "mode": "off"
2893 }
2894 }
2895 },
2896 "overrides": []
2897 }
2898 }
2899 }
2900 }
2901 },
2902 "panel-23": {
2903 "kind": "Panel",
2904 "spec": {
2905 "id": 23,
2906 "title": "Iostat util",
2907 "description": "",
2908 "links": [],
2909 "data": {
2910 "kind": "QueryGroup",
2911 "spec": {
2912 "queries": [
2913 {
2914 "kind": "PanelQuery",
2915 "spec": {
2916 "query": {
2917 "kind": "DataQuery",
2918 "group": "influxdb",
2919 "version": "v0",
2920 "spec": {
2921 "alias": "$tag_device util",
2922 "groupBy": [
2923 {
2924 "params": [
2925 "$interval"
2926 ],
2927 "type": "time"
2928 },
2929 {
2930 "params": [
2931 "device::tag"
2932 ],
2933 "type": "tag"
2934 },
2935 {
2936 "params": [
2937 "null"
2938 ],
2939 "type": "fill"
2940 }
2941 ],
2942 "measurement": "host_iostat",
2943 "orderByTime": "ASC",
2944 "policy": "default",
2945 "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)",
2946 "rawQuery": false,
2947 "resultFormat": "time_series",
2948 "select": [
2949 [
2950 {
2951 "params": [
2952 "util"
2953 ],
2954 "type": "field"
2955 },
2956 {
2957 "params": [],
2958 "type": "mean"
2959 }
2960 ]
2961 ],
2962 "tags": []
2963 },
2964 "labels": {
2965 "grafana.app/export-label": "influxdb-1"
2966 }
2967 },
2968 "refId": "A",
2969 "hidden": false
2970 }
2971 }
2972 ],
2973 "transformations": [],
2974 "queryOptions": {}
2975 }
2976 },
2977 "vizConfig": {
2978 "kind": "VizConfig",
2979 "group": "timeseries",
2980 "version": "13.0.1+security-01",
2981 "spec": {
2982 "options": {
2983 "annotations": {
2984 "clustering": -1,
2985 "multiLane": false
2986 },
2987 "legend": {
2988 "calcs": [],
2989 "displayMode": "list",
2990 "placement": "bottom",
2991 "showLegend": true
2992 },
2993 "tooltip": {
2994 "hideZeros": false,
2995 "mode": "single",
2996 "sort": "none"
2997 }
2998 },
2999 "fieldConfig": {
3000 "defaults": {
3001 "thresholds": {
3002 "mode": "absolute",
3003 "steps": [
3004 {
3005 "value": 0,
3006 "color": "green"
3007 },
3008 {
3009 "value": 80,
3010 "color": "red"
3011 }
3012 ]
3013 },
3014 "color": {
3015 "mode": "palette-classic"
3016 },
3017 "custom": {
3018 "axisBorderShow": false,
3019 "axisCenteredZero": false,
3020 "axisColorMode": "text",
3021 "axisLabel": "",
3022 "axisPlacement": "auto",
3023 "barAlignment": 0,
3024 "barWidthFactor": 0.6,
3025 "drawStyle": "line",
3026 "fillOpacity": 0,
3027 "gradientMode": "none",
3028 "hideFrom": {
3029 "legend": false,
3030 "tooltip": false,
3031 "viz": false
3032 },
3033 "insertNulls": false,
3034 "lineInterpolation": "linear",
3035 "lineWidth": 1,
3036 "pointSize": 5,
3037 "scaleDistribution": {
3038 "type": "linear"
3039 },
3040 "showPoints": "auto",
3041 "showValues": false,
3042 "spanNulls": false,
3043 "stacking": {
3044 "group": "A",
3045 "mode": "none"
3046 },
3047 "thresholdsStyle": {
3048 "mode": "off"
3049 }
3050 }
3051 },
3052 "overrides": []
3053 }
3054 }
3055 }
3056 }
3057 },
3058 "panel-24": {
3059 "kind": "Panel",
3060 "spec": {
3061 "id": 24,
3062 "title": "Iostat s",
3063 "description": "",
3064 "links": [],
3065 "data": {
3066 "kind": "QueryGroup",
3067 "spec": {
3068 "queries": [
3069 {
3070 "kind": "PanelQuery",
3071 "spec": {
3072 "query": {
3073 "kind": "DataQuery",
3074 "group": "influxdb",
3075 "version": "v0",
3076 "spec": {
3077 "alias": "$tag_device f/s",
3078 "groupBy": [
3079 {
3080 "params": [
3081 "$interval"
3082 ],
3083 "type": "time"
3084 },
3085 {
3086 "params": [
3087 "device::tag"
3088 ],
3089 "type": "tag"
3090 },
3091 {
3092 "params": [
3093 "null"
3094 ],
3095 "type": "fill"
3096 }
3097 ],
3098 "measurement": "host_iostat",
3099 "orderByTime": "ASC",
3100 "policy": "default",
3101 "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)",
3102 "rawQuery": false,
3103 "resultFormat": "time_series",
3104 "select": [
3105 [
3106 {
3107 "params": [
3108 "f_s"
3109 ],
3110 "type": "field"
3111 },
3112 {
3113 "params": [],
3114 "type": "mean"
3115 }
3116 ]
3117 ],
3118 "tags": []
3119 },
3120 "labels": {
3121 "grafana.app/export-label": "influxdb-1"
3122 }
3123 },
3124 "refId": "A",
3125 "hidden": false
3126 }
3127 },
3128 {
3129 "kind": "PanelQuery",
3130 "spec": {
3131 "query": {
3132 "kind": "DataQuery",
3133 "group": "influxdb",
3134 "version": "v0",
3135 "spec": {
3136 "alias": "$tag_device r/s",
3137 "groupBy": [
3138 {
3139 "params": [
3140 "$interval"
3141 ],
3142 "type": "time"
3143 },
3144 {
3145 "params": [
3146 "device::tag"
3147 ],
3148 "type": "tag"
3149 },
3150 {
3151 "params": [
3152 "null"
3153 ],
3154 "type": "fill"
3155 }
3156 ],
3157 "measurement": "host_iostat",
3158 "orderByTime": "ASC",
3159 "policy": "default",
3160 "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)",
3161 "rawQuery": false,
3162 "resultFormat": "time_series",
3163 "select": [
3164 [
3165 {
3166 "params": [
3167 "r_s"
3168 ],
3169 "type": "field"
3170 },
3171 {
3172 "params": [],
3173 "type": "mean"
3174 }
3175 ]
3176 ],
3177 "tags": []
3178 },
3179 "labels": {
3180 "grafana.app/export-label": "influxdb-1"
3181 }
3182 },
3183 "refId": "B",
3184 "hidden": false
3185 }
3186 },
3187 {
3188 "kind": "PanelQuery",
3189 "spec": {
3190 "query": {
3191 "kind": "DataQuery",
3192 "group": "influxdb",
3193 "version": "v0",
3194 "spec": {
3195 "alias": "$tag_device w/s",
3196 "groupBy": [
3197 {
3198 "params": [
3199 "$interval"
3200 ],
3201 "type": "time"
3202 },
3203 {
3204 "params": [
3205 "device::tag"
3206 ],
3207 "type": "tag"
3208 },
3209 {
3210 "params": [
3211 "null"
3212 ],
3213 "type": "fill"
3214 }
3215 ],
3216 "measurement": "host_iostat",
3217 "orderByTime": "ASC",
3218 "policy": "default",
3219 "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)",
3220 "rawQuery": false,
3221 "resultFormat": "time_series",
3222 "select": [
3223 [
3224 {
3225 "params": [
3226 "w_s"
3227 ],
3228 "type": "field"
3229 },
3230 {
3231 "params": [],
3232 "type": "mean"
3233 }
3234 ]
3235 ],
3236 "tags": []
3237 },
3238 "labels": {
3239 "grafana.app/export-label": "influxdb-1"
3240 }
3241 },
3242 "refId": "C",
3243 "hidden": false
3244 }
3245 }
3246 ],
3247 "transformations": [],
3248 "queryOptions": {}
3249 }
3250 },
3251 "vizConfig": {
3252 "kind": "VizConfig",
3253 "group": "timeseries",
3254 "version": "13.0.1+security-01",
3255 "spec": {
3256 "options": {
3257 "annotations": {
3258 "clustering": -1,
3259 "multiLane": false
3260 },
3261 "legend": {
3262 "calcs": [],
3263 "displayMode": "list",
3264 "placement": "bottom",
3265 "showLegend": true
3266 },
3267 "tooltip": {
3268 "hideZeros": false,
3269 "mode": "single",
3270 "sort": "none"
3271 }
3272 },
3273 "fieldConfig": {
3274 "defaults": {
3275 "thresholds": {
3276 "mode": "absolute",
3277 "steps": [
3278 {
3279 "value": 0,
3280 "color": "green"
3281 },
3282 {
3283 "value": 80,
3284 "color": "red"
3285 }
3286 ]
3287 },
3288 "color": {
3289 "mode": "palette-classic"
3290 },
3291 "custom": {
3292 "axisBorderShow": false,
3293 "axisCenteredZero": false,
3294 "axisColorMode": "text",
3295 "axisLabel": "",
3296 "axisPlacement": "auto",
3297 "barAlignment": 0,
3298 "barWidthFactor": 0.6,
3299 "drawStyle": "line",
3300 "fillOpacity": 0,
3301 "gradientMode": "none",
3302 "hideFrom": {
3303 "legend": false,
3304 "tooltip": false,
3305 "viz": false
3306 },
3307 "insertNulls": false,
3308 "lineInterpolation": "linear",
3309 "lineWidth": 1,
3310 "pointSize": 5,
3311 "scaleDistribution": {
3312 "type": "linear"
3313 },
3314 "showPoints": "auto",
3315 "showValues": false,
3316 "spanNulls": false,
3317 "stacking": {
3318 "group": "A",
3319 "mode": "none"
3320 },
3321 "thresholdsStyle": {
3322 "mode": "off"
3323 }
3324 }
3325 },
3326 "overrides": []
3327 }
3328 }
3329 }
3330 }
3331 },
3332 "panel-25": {
3333 "kind": "Panel",
3334 "spec": {
3335 "id": 25,
3336 "title": "vmstat idle",
3337 "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 — процессор загружен полностью.",
3338 "links": [],
3339 "data": {
3340 "kind": "QueryGroup",
3341 "spec": {
3342 "queries": [
3343 {
3344 "kind": "PanelQuery",
3345 "spec": {
3346 "query": {
3347 "kind": "DataQuery",
3348 "group": "influxdb",
3349 "version": "v0",
3350 "spec": {
3351 "alias": "idle",
3352 "groupBy": [
3353 {
3354 "params": [
3355 "$interval"
3356 ],
3357 "type": "time"
3358 },
3359 {
3360 "params": [
3361 "null"
3362 ],
3363 "type": "fill"
3364 }
3365 ],
3366 "measurement": "host_vmstat",
3367 "orderByTime": "ASC",
3368 "policy": "default",
3369 "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)",
3370 "rawQuery": false,
3371 "resultFormat": "time_series",
3372 "select": [
3373 [
3374 {
3375 "params": [
3376 "idle"
3377 ],
3378 "type": "field"
3379 },
3380 {
3381 "params": [],
3382 "type": "sum"
3383 }
3384 ]
3385 ],
3386 "tags": []
3387 },
3388 "labels": {
3389 "grafana.app/export-label": "influxdb-1"
3390 }
3391 },
3392 "refId": "D",
3393 "hidden": false
3394 }
3395 }
3396 ],
3397 "transformations": [],
3398 "queryOptions": {}
3399 }
3400 },
3401 "vizConfig": {
3402 "kind": "VizConfig",
3403 "group": "timeseries",
3404 "version": "13.0.1+security-01",
3405 "spec": {
3406 "options": {
3407 "annotations": {
3408 "clustering": -1,
3409 "multiLane": false
3410 },
3411 "legend": {
3412 "calcs": [],
3413 "displayMode": "list",
3414 "placement": "bottom",
3415 "showLegend": true
3416 },
3417 "tooltip": {
3418 "hideZeros": false,
3419 "mode": "single",
3420 "sort": "none"
3421 }
3422 },
3423 "fieldConfig": {
3424 "defaults": {
3425 "thresholds": {
3426 "mode": "absolute",
3427 "steps": [
3428 {
3429 "value": 0,
3430 "color": "green"
3431 },
3432 {
3433 "value": 80,
3434 "color": "red"
3435 }
3436 ]
3437 },
3438 "color": {
3439 "mode": "palette-classic"
3440 },
3441 "custom": {
3442 "axisBorderShow": false,
3443 "axisCenteredZero": false,
3444 "axisColorMode": "text",
3445 "axisLabel": "",
3446 "axisPlacement": "auto",
3447 "barAlignment": 0,
3448 "barWidthFactor": 0.6,
3449 "drawStyle": "line",
3450 "fillOpacity": 10,
3451 "gradientMode": "none",
3452 "hideFrom": {
3453 "legend": false,
3454 "tooltip": false,
3455 "viz": false
3456 },
3457 "insertNulls": false,
3458 "lineInterpolation": "smooth",
3459 "lineWidth": 1,
3460 "pointSize": 5,
3461 "scaleDistribution": {
3462 "type": "linear"
3463 },
3464 "showPoints": "auto",
3465 "showValues": false,
3466 "spanNulls": false,
3467 "stacking": {
3468 "group": "A",
3469 "mode": "none"
3470 },
3471 "thresholdsStyle": {
3472 "mode": "off"
3473 }
3474 }
3475 },
3476 "overrides": []
3477 }
3478 }
3479 }
3480 }
3481 },
3482 "panel-26": {
3483 "kind": "Panel",
3484 "spec": {
3485 "id": 26,
3486 "title": "vmstat interrupts",
3487 "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 — процессор загружен полностью.",
3488 "links": [],
3489 "data": {
3490 "kind": "QueryGroup",
3491 "spec": {
3492 "queries": [
3493 {
3494 "kind": "PanelQuery",
3495 "spec": {
3496 "query": {
3497 "kind": "DataQuery",
3498 "group": "influxdb",
3499 "version": "v0",
3500 "spec": {
3501 "alias": "in",
3502 "groupBy": [
3503 {
3504 "params": [
3505 "$interval"
3506 ],
3507 "type": "time"
3508 },
3509 {
3510 "params": [
3511 "null"
3512 ],
3513 "type": "fill"
3514 }
3515 ],
3516 "measurement": "host_vmstat",
3517 "orderByTime": "ASC",
3518 "policy": "default",
3519 "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)",
3520 "rawQuery": false,
3521 "resultFormat": "time_series",
3522 "select": [
3523 [
3524 {
3525 "params": [
3526 "intr"
3527 ],
3528 "type": "field"
3529 },
3530 {
3531 "params": [],
3532 "type": "sum"
3533 }
3534 ]
3535 ],
3536 "tags": []
3537 },
3538 "labels": {
3539 "grafana.app/export-label": "influxdb-1"
3540 }
3541 },
3542 "refId": "C",
3543 "hidden": false
3544 }
3545 }
3546 ],
3547 "transformations": [],
3548 "queryOptions": {}
3549 }
3550 },
3551 "vizConfig": {
3552 "kind": "VizConfig",
3553 "group": "timeseries",
3554 "version": "13.0.1+security-01",
3555 "spec": {
3556 "options": {
3557 "annotations": {
3558 "clustering": -1,
3559 "multiLane": false
3560 },
3561 "legend": {
3562 "calcs": [],
3563 "displayMode": "list",
3564 "placement": "bottom",
3565 "showLegend": true
3566 },
3567 "tooltip": {
3568 "hideZeros": false,
3569 "mode": "single",
3570 "sort": "none"
3571 }
3572 },
3573 "fieldConfig": {
3574 "defaults": {
3575 "thresholds": {
3576 "mode": "absolute",
3577 "steps": [
3578 {
3579 "value": 0,
3580 "color": "green"
3581 },
3582 {
3583 "value": 80,
3584 "color": "red"
3585 }
3586 ]
3587 },
3588 "color": {
3589 "mode": "palette-classic"
3590 },
3591 "custom": {
3592 "axisBorderShow": false,
3593 "axisCenteredZero": false,
3594 "axisColorMode": "text",
3595 "axisLabel": "",
3596 "axisPlacement": "auto",
3597 "barAlignment": 0,
3598 "barWidthFactor": 0.6,
3599 "drawStyle": "line",
3600 "fillOpacity": 10,
3601 "gradientMode": "none",
3602 "hideFrom": {
3603 "legend": false,
3604 "tooltip": false,
3605 "viz": false
3606 },
3607 "insertNulls": false,
3608 "lineInterpolation": "smooth",
3609 "lineWidth": 1,
3610 "pointSize": 5,
3611 "scaleDistribution": {
3612 "type": "linear"
3613 },
3614 "showPoints": "auto",
3615 "showValues": false,
3616 "spanNulls": false,
3617 "stacking": {
3618 "group": "A",
3619 "mode": "none"
3620 },
3621 "thresholdsStyle": {
3622 "mode": "off"
3623 }
3624 }
3625 },
3626 "overrides": []
3627 }
3628 }
3629 }
3630 }
3631 },
3632 "panel-27": {
3633 "kind": "Panel",
3634 "spec": {
3635 "id": 27,
3636 "title": "ebpf",
3637 "description": "",
3638 "links": [],
3639 "data": {
3640 "kind": "QueryGroup",
3641 "spec": {
3642 "queries": [
3643 {
3644 "kind": "PanelQuery",
3645 "spec": {
3646 "query": {
3647 "kind": "DataQuery",
3648 "group": "influxdb",
3649 "version": "v0",
3650 "spec": {
3651 "alias": "fsync",
3652 "groupBy": [
3653 {
3654 "params": [
3655 "$interval"
3656 ],
3657 "type": "time"
3658 },
3659 {
3660 "params": [
3661 "null"
3662 ],
3663 "type": "fill"
3664 }
3665 ],
3666 "measurement": "samba_ebpf",
3667 "orderByTime": "ASC",
3668 "policy": "default",
3669 "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)",
3670 "rawQuery": false,
3671 "resultFormat": "time_series",
3672 "select": [
3673 [
3674 {
3675 "params": [
3676 "fsync"
3677 ],
3678 "type": "field"
3679 },
3680 {
3681 "params": [],
3682 "type": "sum"
3683 }
3684 ]
3685 ],
3686 "tags": []
3687 },
3688 "labels": {
3689 "grafana.app/export-label": "influxdb-1"
3690 }
3691 },
3692 "refId": "A",
3693 "hidden": false
3694 }
3695 },
3696 {
3697 "kind": "PanelQuery",
3698 "spec": {
3699 "query": {
3700 "kind": "DataQuery",
3701 "group": "influxdb",
3702 "version": "v0",
3703 "spec": {
3704 "alias": "ldb",
3705 "groupBy": [
3706 {
3707 "params": [
3708 "$interval"
3709 ],
3710 "type": "time"
3711 },
3712 {
3713 "params": [
3714 "null"
3715 ],
3716 "type": "fill"
3717 }
3718 ],
3719 "measurement": "samba_ebpf",
3720 "orderByTime": "ASC",
3721 "policy": "default",
3722 "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)",
3723 "rawQuery": false,
3724 "resultFormat": "time_series",
3725 "select": [
3726 [
3727 {
3728 "params": [
3729 "ldb"
3730 ],
3731 "type": "field"
3732 },
3733 {
3734 "params": [],
3735 "type": "sum"
3736 }
3737 ]
3738 ],
3739 "tags": []
3740 },
3741 "labels": {
3742 "grafana.app/export-label": "influxdb-1"
3743 }
3744 },
3745 "refId": "B",
3746 "hidden": false
3747 }
3748 }
3749 ],
3750 "transformations": [],
3751 "queryOptions": {}
3752 }
3753 },
3754 "vizConfig": {
3755 "kind": "VizConfig",
3756 "group": "timeseries",
3757 "version": "13.0.1+security-01",
3758 "spec": {
3759 "options": {
3760 "annotations": {
3761 "clustering": -1,
3762 "multiLane": false
3763 },
3764 "legend": {
3765 "calcs": [],
3766 "displayMode": "list",
3767 "placement": "bottom",
3768 "showLegend": true
3769 },
3770 "tooltip": {
3771 "hideZeros": false,
3772 "mode": "single",
3773 "sort": "none"
3774 }
3775 },
3776 "fieldConfig": {
3777 "defaults": {
3778 "thresholds": {
3779 "mode": "absolute",
3780 "steps": [
3781 {
3782 "value": 0,
3783 "color": "green"
3784 },
3785 {
3786 "value": 80,
3787 "color": "red"
3788 }
3789 ]
3790 },
3791 "color": {
3792 "mode": "palette-classic"
3793 },
3794 "custom": {
3795 "axisBorderShow": false,
3796 "axisCenteredZero": false,
3797 "axisColorMode": "text",
3798 "axisLabel": "",
3799 "axisPlacement": "auto",
3800 "barAlignment": 0,
3801 "barWidthFactor": 0.6,
3802 "drawStyle": "line",
3803 "fillOpacity": 10,
3804 "gradientMode": "none",
3805 "hideFrom": {
3806 "legend": false,
3807 "tooltip": false,
3808 "viz": false
3809 },
3810 "insertNulls": false,
3811 "lineInterpolation": "smooth",
3812 "lineWidth": 1,
3813 "pointSize": 5,
3814 "scaleDistribution": {
3815 "type": "linear"
3816 },
3817 "showPoints": "auto",
3818 "showValues": false,
3819 "spanNulls": false,
3820 "stacking": {
3821 "group": "A",
3822 "mode": "none"
3823 },
3824 "thresholdsStyle": {
3825 "mode": "off"
3826 }
3827 }
3828 },
3829 "overrides": []
3830 }
3831 }
3832 }
3833 }
3834 },
3835 "panel-3": {
3836 "kind": "Panel",
3837 "spec": {
3838 "id": 3,
3839 "title": "DSDB: система vs пользователь",
3840 "description": "Изменения каталога с разбивкой по performedAsSystem (true = выполнено системой).",
3841 "links": [],
3842 "data": {
3843 "kind": "QueryGroup",
3844 "spec": {
3845 "queries": [
3846 {
3847 "kind": "PanelQuery",
3848 "spec": {
3849 "query": {
3850 "kind": "DataQuery",
3851 "group": "influxdb",
3852 "version": "v0",
3853 "spec": {
3854 "groupBy": [],
3855 "measurement": "samba_dsdb",
3856 "orderByTime": "ASC",
3857 "policy": "default",
3858 "query": "SELECT count(\"status_code\") FROM \"samba_dsdb\" WHERE $timeFilter GROUP BY time($interval), \"as_system\"::tag fill(null)",
3859 "rawQuery": true,
3860 "resultFormat": "time_series",
3861 "select": [],
3862 "tags": []
3863 },
3864 "labels": {
3865 "grafana.app/export-label": "influxdb-1"
3866 }
3867 },
3868 "refId": "A",
3869 "hidden": false
3870 }
3871 }
3872 ],
3873 "transformations": [],
3874 "queryOptions": {}
3875 }
3876 },
3877 "vizConfig": {
3878 "kind": "VizConfig",
3879 "group": "timeseries",
3880 "version": "13.0.1+security-01",
3881 "spec": {
3882 "options": {
3883 "annotations": {
3884 "clustering": -1,
3885 "multiLane": false
3886 },
3887 "legend": {
3888 "calcs": [],
3889 "displayMode": "list",
3890 "placement": "bottom",
3891 "showLegend": true
3892 },
3893 "tooltip": {
3894 "hideZeros": false,
3895 "mode": "multi",
3896 "sort": "desc"
3897 }
3898 },
3899 "fieldConfig": {
3900 "defaults": {
3901 "thresholds": {
3902 "mode": "absolute",
3903 "steps": [
3904 {
3905 "value": 0,
3906 "color": "green"
3907 },
3908 {
3909 "value": 80,
3910 "color": "red"
3911 }
3912 ]
3913 },
3914 "color": {
3915 "mode": "palette-classic"
3916 },
3917 "custom": {
3918 "axisBorderShow": false,
3919 "axisCenteredZero": false,
3920 "axisColorMode": "text",
3921 "axisLabel": "",
3922 "axisPlacement": "auto",
3923 "barAlignment": 0,
3924 "barWidthFactor": 0.6,
3925 "drawStyle": "line",
3926 "fillOpacity": 20,
3927 "gradientMode": "none",
3928 "hideFrom": {
3929 "legend": false,
3930 "tooltip": false,
3931 "viz": false
3932 },
3933 "insertNulls": false,
3934 "lineInterpolation": "smooth",
3935 "lineWidth": 1,
3936 "pointSize": 5,
3937 "scaleDistribution": {
3938 "type": "linear"
3939 },
3940 "showPoints": "auto",
3941 "showValues": false,
3942 "spanNulls": false,
3943 "stacking": {
3944 "group": "A",
3945 "mode": "none"
3946 },
3947 "thresholdsStyle": {
3948 "mode": "off"
3949 }
3950 }
3951 },
3952 "overrides": []
3953 }
3954 }
3955 }
3956 }
3957 },
3958 "panel-4": {
3959 "kind": "Panel",
3960 "spec": {
3961 "id": 4,
3962 "title": "DSDB: топ инициаторов (SID)",
3963 "description": "Кто инициировал изменения каталога — разбивка по userSid.",
3964 "links": [],
3965 "data": {
3966 "kind": "QueryGroup",
3967 "spec": {
3968 "queries": [
3969 {
3970 "kind": "PanelQuery",
3971 "spec": {
3972 "query": {
3973 "kind": "DataQuery",
3974 "group": "influxdb",
3975 "version": "v0",
3976 "spec": {
3977 "groupBy": [],
3978 "measurement": "samba_dsdb",
3979 "orderByTime": "ASC",
3980 "policy": "default",
3981 "query": "SELECT count(\"status_code\") FROM \"samba_dsdb\" WHERE $timeFilter GROUP BY time($interval), \"user_sid\"::tag fill(null)",
3982 "rawQuery": true,
3983 "resultFormat": "time_series",
3984 "select": [],
3985 "tags": []
3986 },
3987 "labels": {
3988 "grafana.app/export-label": "influxdb-1"
3989 }
3990 },
3991 "refId": "A",
3992 "hidden": false
3993 }
3994 }
3995 ],
3996 "transformations": [],
3997 "queryOptions": {}
3998 }
3999 },
4000 "vizConfig": {
4001 "kind": "VizConfig",
4002 "group": "timeseries",
4003 "version": "13.0.1+security-01",
4004 "spec": {
4005 "options": {
4006 "annotations": {
4007 "clustering": -1,
4008 "multiLane": false
4009 },
4010 "legend": {
4011 "calcs": [
4012 "sum"
4013 ],
4014 "displayMode": "table",
4015 "placement": "right",
4016 "showLegend": true
4017 },
4018 "tooltip": {
4019 "hideZeros": false,
4020 "mode": "multi",
4021 "sort": "desc"
4022 }
4023 },
4024 "fieldConfig": {
4025 "defaults": {
4026 "thresholds": {
4027 "mode": "absolute",
4028 "steps": [
4029 {
4030 "value": 0,
4031 "color": "green"
4032 },
4033 {
4034 "value": 80,
4035 "color": "red"
4036 }
4037 ]
4038 },
4039 "color": {
4040 "mode": "palette-classic"
4041 },
4042 "custom": {
4043 "axisBorderShow": false,
4044 "axisCenteredZero": false,
4045 "axisColorMode": "text",
4046 "axisLabel": "",
4047 "axisPlacement": "auto",
4048 "barAlignment": 0,
4049 "barWidthFactor": 0.6,
4050 "drawStyle": "bars",
4051 "fillOpacity": 50,
4052 "gradientMode": "none",
4053 "hideFrom": {
4054 "legend": false,
4055 "tooltip": false,
4056 "viz": false
4057 },
4058 "insertNulls": false,
4059 "lineInterpolation": "linear",
4060 "lineWidth": 1,
4061 "pointSize": 5,
4062 "scaleDistribution": {
4063 "type": "linear"
4064 },
4065 "showPoints": "auto",
4066 "showValues": false,
4067 "spanNulls": false,
4068 "stacking": {
4069 "group": "A",
4070 "mode": "normal"
4071 },
4072 "thresholdsStyle": {
4073 "mode": "off"
4074 }
4075 }
4076 },
4077 "overrides": []
4078 }
4079 }
4080 }
4081 }
4082 },
4083 "panel-5": {
4084 "kind": "Panel",
4085 "spec": {
4086 "id": 5,
4087 "title": "Транзакции: длительность (mean/max)",
4088 "description": "Длительность транзакций каталога (samba_dsdb_tx) в микросекундах.",
4089 "links": [],
4090 "data": {
4091 "kind": "QueryGroup",
4092 "spec": {
4093 "queries": [
4094 {
4095 "kind": "PanelQuery",
4096 "spec": {
4097 "query": {
4098 "kind": "DataQuery",
4099 "group": "influxdb",
4100 "version": "v0",
4101 "spec": {
4102 "groupBy": [],
4103 "measurement": "samba_dsdb_tx",
4104 "orderByTime": "ASC",
4105 "policy": "default",
4106 "query": "SELECT mean(\"duration\") AS \"mean\", max(\"duration\") AS \"max\" FROM \"samba_dsdb_tx\" WHERE $timeFilter GROUP BY time($interval) fill(null)",
4107 "rawQuery": true,
4108 "resultFormat": "time_series",
4109 "select": [],
4110 "tags": []
4111 },
4112 "labels": {
4113 "grafana.app/export-label": "influxdb-1"
4114 }
4115 },
4116 "refId": "A",
4117 "hidden": false
4118 }
4119 }
4120 ],
4121 "transformations": [],
4122 "queryOptions": {}
4123 }
4124 },
4125 "vizConfig": {
4126 "kind": "VizConfig",
4127 "group": "timeseries",
4128 "version": "13.0.1+security-01",
4129 "spec": {
4130 "options": {
4131 "annotations": {
4132 "clustering": -1,
4133 "multiLane": false
4134 },
4135 "legend": {
4136 "calcs": [
4137 "mean",
4138 "max"
4139 ],
4140 "displayMode": "table",
4141 "placement": "bottom",
4142 "showLegend": true
4143 },
4144 "tooltip": {
4145 "hideZeros": false,
4146 "mode": "multi",
4147 "sort": "desc"
4148 }
4149 },
4150 "fieldConfig": {
4151 "defaults": {
4152 "unit": "µs",
4153 "thresholds": {
4154 "mode": "absolute",
4155 "steps": [
4156 {
4157 "value": 0,
4158 "color": "green"
4159 },
4160 {
4161 "value": 80,
4162 "color": "red"
4163 }
4164 ]
4165 },
4166 "color": {
4167 "mode": "palette-classic"
4168 },
4169 "custom": {
4170 "axisBorderShow": false,
4171 "axisCenteredZero": false,
4172 "axisColorMode": "text",
4173 "axisLabel": "",
4174 "axisPlacement": "auto",
4175 "barAlignment": 0,
4176 "barWidthFactor": 0.6,
4177 "drawStyle": "line",
4178 "fillOpacity": 10,
4179 "gradientMode": "none",
4180 "hideFrom": {
4181 "legend": false,
4182 "tooltip": false,
4183 "viz": false
4184 },
4185 "insertNulls": false,
4186 "lineInterpolation": "smooth",
4187 "lineWidth": 1,
4188 "pointSize": 5,
4189 "scaleDistribution": {
4190 "type": "linear"
4191 },
4192 "showPoints": "auto",
4193 "showValues": false,
4194 "spanNulls": false,
4195 "stacking": {
4196 "group": "A",
4197 "mode": "none"
4198 },
4199 "thresholdsStyle": {
4200 "mode": "off"
4201 }
4202 }
4203 },
4204 "overrides": []
4205 }
4206 }
4207 }
4208 }
4209 },
4210 "panel-6": {
4211 "kind": "Panel",
4212 "spec": {
4213 "id": 6,
4214 "title": "Транзакции по типу действия",
4215 "description": "Число транзакций каталога, разбивка по action (commit / rollback / prepare commit / begin).",
4216 "links": [],
4217 "data": {
4218 "kind": "QueryGroup",
4219 "spec": {
4220 "queries": [
4221 {
4222 "kind": "PanelQuery",
4223 "spec": {
4224 "query": {
4225 "kind": "DataQuery",
4226 "group": "influxdb",
4227 "version": "v0",
4228 "spec": {
4229 "groupBy": [],
4230 "measurement": "samba_dsdb_tx",
4231 "orderByTime": "ASC",
4232 "policy": "default",
4233 "query": "SELECT count(\"duration\") FROM \"samba_dsdb_tx\" WHERE $timeFilter GROUP BY time($interval), \"action\"::tag fill(null)",
4234 "rawQuery": true,
4235 "resultFormat": "time_series",
4236 "select": [],
4237 "tags": []
4238 },
4239 "labels": {
4240 "grafana.app/export-label": "influxdb-1"
4241 }
4242 },
4243 "refId": "A",
4244 "hidden": false
4245 }
4246 }
4247 ],
4248 "transformations": [],
4249 "queryOptions": {}
4250 }
4251 },
4252 "vizConfig": {
4253 "kind": "VizConfig",
4254 "group": "timeseries",
4255 "version": "13.0.1+security-01",
4256 "spec": {
4257 "options": {
4258 "annotations": {
4259 "clustering": -1,
4260 "multiLane": false
4261 },
4262 "legend": {
4263 "calcs": [],
4264 "displayMode": "list",
4265 "placement": "bottom",
4266 "showLegend": true
4267 },
4268 "tooltip": {
4269 "hideZeros": false,
4270 "mode": "multi",
4271 "sort": "desc"
4272 }
4273 },
4274 "fieldConfig": {
4275 "defaults": {
4276 "thresholds": {
4277 "mode": "absolute",
4278 "steps": [
4279 {
4280 "value": 0,
4281 "color": "green"
4282 },
4283 {
4284 "value": 80,
4285 "color": "red"
4286 }
4287 ]
4288 },
4289 "color": {
4290 "mode": "palette-classic"
4291 },
4292 "custom": {
4293 "axisBorderShow": false,
4294 "axisCenteredZero": false,
4295 "axisColorMode": "text",
4296 "axisLabel": "",
4297 "axisPlacement": "auto",
4298 "barAlignment": 0,
4299 "barWidthFactor": 0.6,
4300 "drawStyle": "bars",
4301 "fillOpacity": 50,
4302 "gradientMode": "none",
4303 "hideFrom": {
4304 "legend": false,
4305 "tooltip": false,
4306 "viz": false
4307 },
4308 "insertNulls": false,
4309 "lineInterpolation": "linear",
4310 "lineWidth": 1,
4311 "pointSize": 5,
4312 "scaleDistribution": {
4313 "type": "linear"
4314 },
4315 "showPoints": "auto",
4316 "showValues": false,
4317 "spanNulls": false,
4318 "stacking": {
4319 "group": "A",
4320 "mode": "normal"
4321 },
4322 "thresholdsStyle": {
4323 "mode": "off"
4324 }
4325 }
4326 },
4327 "overrides": []
4328 }
4329 }
4330 }
4331 }
4332 },
4333 "panel-7": {
4334 "kind": "Panel",
4335 "spec": {
4336 "id": 7,
4337 "title": "SMB activity",
4338 "description": "",
4339 "links": [],
4340 "data": {
4341 "kind": "QueryGroup",
4342 "spec": {
4343 "queries": [
4344 {
4345 "kind": "PanelQuery",
4346 "spec": {
4347 "query": {
4348 "kind": "DataQuery",
4349 "group": "influxdb",
4350 "version": "v0",
4351 "spec": {
4352 "alias": "user_smb",
4353 "groupBy": [
4354 {
4355 "params": [
4356 "$interval"
4357 ],
4358 "type": "time"
4359 },
4360 {
4361 "params": [
4362 "domain::tag"
4363 ],
4364 "type": "tag"
4365 },
4366 {
4367 "params": [
4368 "null"
4369 ],
4370 "type": "fill"
4371 }
4372 ],
4373 "measurement": "samba_authz",
4374 "orderByTime": "ASC",
4375 "policy": "default",
4376 "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)",
4377 "rawQuery": false,
4378 "resultFormat": "time_series",
4379 "select": [
4380 [
4381 {
4382 "params": [
4383 "auth_type"
4384 ],
4385 "type": "field"
4386 },
4387 {
4388 "params": [],
4389 "type": "count"
4390 }
4391 ]
4392 ],
4393 "tags": [
4394 {
4395 "key": "service::tag",
4396 "operator": "=",
4397 "value": "SMB2"
4398 },
4399 {
4400 "condition": "AND",
4401 "key": "auth_type::field",
4402 "operator": "=",
4403 "value": "krb5"
4404 },
4405 {
4406 "condition": "AND",
4407 "key": "account::tag",
4408 "operator": "=~",
4409 "value": "/^user-/"
4410 }
4411 ]
4412 },
4413 "labels": {
4414 "grafana.app/export-label": "influxdb-1"
4415 }
4416 },
4417 "refId": "A",
4418 "hidden": false
4419 }
4420 },
4421 {
4422 "kind": "PanelQuery",
4423 "spec": {
4424 "query": {
4425 "kind": "DataQuery",
4426 "group": "influxdb",
4427 "version": "v0",
4428 "spec": {
4429 "alias": "machine_smb",
4430 "groupBy": [
4431 {
4432 "params": [
4433 "$interval"
4434 ],
4435 "type": "time"
4436 },
4437 {
4438 "params": [
4439 "domain::tag"
4440 ],
4441 "type": "tag"
4442 },
4443 {
4444 "params": [
4445 "null"
4446 ],
4447 "type": "fill"
4448 }
4449 ],
4450 "measurement": "samba_authz",
4451 "orderByTime": "ASC",
4452 "policy": "default",
4453 "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)",
4454 "rawQuery": false,
4455 "resultFormat": "time_series",
4456 "select": [
4457 [
4458 {
4459 "params": [
4460 "auth_type"
4461 ],
4462 "type": "field"
4463 },
4464 {
4465 "params": [],
4466 "type": "count"
4467 }
4468 ]
4469 ],
4470 "tags": [
4471 {
4472 "key": "service::tag",
4473 "operator": "=",
4474 "value": "SMB2"
4475 },
4476 {
4477 "condition": "AND",
4478 "key": "auth_type::field",
4479 "operator": "=",
4480 "value": "krb5"
4481 },
4482 {
4483 "condition": "AND",
4484 "key": "account::tag",
4485 "operator": "=~",
4486 "value": "/^MACHINE/"
4487 }
4488 ]
4489 },
4490 "labels": {
4491 "grafana.app/export-label": "influxdb-1"
4492 }
4493 },
4494 "refId": "B",
4495 "hidden": false
4496 }
4497 }
4498 ],
4499 "transformations": [],
4500 "queryOptions": {}
4501 }
4502 },
4503 "vizConfig": {
4504 "kind": "VizConfig",
4505 "group": "timeseries",
4506 "version": "13.0.1+security-01",
4507 "spec": {
4508 "options": {
4509 "annotations": {
4510 "clustering": -1,
4511 "multiLane": false
4512 },
4513 "legend": {
4514 "calcs": [],
4515 "displayMode": "list",
4516 "placement": "bottom",
4517 "showLegend": true
4518 },
4519 "tooltip": {
4520 "hideZeros": false,
4521 "mode": "single",
4522 "sort": "none"
4523 }
4524 },
4525 "fieldConfig": {
4526 "defaults": {
4527 "thresholds": {
4528 "mode": "absolute",
4529 "steps": [
4530 {
4531 "value": 0,
4532 "color": "green"
4533 },
4534 {
4535 "value": 80,
4536 "color": "red"
4537 }
4538 ]
4539 },
4540 "color": {
4541 "mode": "palette-classic"
4542 },
4543 "custom": {
4544 "axisBorderShow": false,
4545 "axisCenteredZero": false,
4546 "axisColorMode": "text",
4547 "axisLabel": "",
4548 "axisPlacement": "auto",
4549 "barAlignment": 0,
4550 "barWidthFactor": 0.6,
4551 "drawStyle": "line",
4552 "fillOpacity": 10,
4553 "gradientMode": "none",
4554 "hideFrom": {
4555 "legend": false,
4556 "tooltip": false,
4557 "viz": false
4558 },
4559 "insertNulls": false,
4560 "lineInterpolation": "smooth",
4561 "lineWidth": 1,
4562 "pointSize": 5,
4563 "scaleDistribution": {
4564 "type": "linear"
4565 },
4566 "showPoints": "auto",
4567 "showValues": false,
4568 "spanNulls": false,
4569 "stacking": {
4570 "group": "A",
4571 "mode": "none"
4572 },
4573 "thresholdsStyle": {
4574 "mode": "off"
4575 }
4576 }
4577 },
4578 "overrides": []
4579 }
4580 }
4581 }
4582 }
4583 },
4584 "panel-8": {
4585 "kind": "Panel",
4586 "spec": {
4587 "id": 8,
4588 "title": "DNS activity",
4589 "description": "",
4590 "links": [],
4591 "data": {
4592 "kind": "QueryGroup",
4593 "spec": {
4594 "queries": [
4595 {
4596 "kind": "PanelQuery",
4597 "spec": {
4598 "query": {
4599 "kind": "DataQuery",
4600 "group": "influxdb",
4601 "version": "v0",
4602 "spec": {
4603 "alias": "rcode=0",
4604 "groupBy": [
4605 {
4606 "params": [
4607 "$interval"
4608 ],
4609 "type": "time"
4610 },
4611 {
4612 "params": [
4613 "null"
4614 ],
4615 "type": "fill"
4616 }
4617 ],
4618 "measurement": "samba_dns_rcode",
4619 "orderByTime": "ASC",
4620 "policy": "default",
4621 "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)",
4622 "rawQuery": false,
4623 "resultFormat": "time_series",
4624 "select": [
4625 [
4626 {
4627 "params": [
4628 "rcode"
4629 ],
4630 "type": "field"
4631 },
4632 {
4633 "params": [],
4634 "type": "count"
4635 }
4636 ]
4637 ],
4638 "tags": [
4639 {
4640 "key": "rcode::field",
4641 "operator": "=",
4642 "value": "0"
4643 },
4644 {
4645 "condition": "AND",
4646 "key": "direction::tag",
4647 "operator": "=",
4648 "value": "out_packet"
4649 }
4650 ]
4651 },
4652 "labels": {
4653 "grafana.app/export-label": "influxdb-1"
4654 }
4655 },
4656 "refId": "A",
4657 "hidden": false
4658 }
4659 },
4660 {
4661 "kind": "PanelQuery",
4662 "spec": {
4663 "query": {
4664 "kind": "DataQuery",
4665 "group": "influxdb",
4666 "version": "v0",
4667 "spec": {
4668 "alias": "rcode=3",
4669 "groupBy": [
4670 {
4671 "params": [
4672 "$interval"
4673 ],
4674 "type": "time"
4675 },
4676 {
4677 "params": [
4678 "null"
4679 ],
4680 "type": "fill"
4681 }
4682 ],
4683 "measurement": "samba_dns_rcode",
4684 "orderByTime": "ASC",
4685 "policy": "default",
4686 "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)",
4687 "rawQuery": false,
4688 "resultFormat": "time_series",
4689 "select": [
4690 [
4691 {
4692 "params": [
4693 "rcode"
4694 ],
4695 "type": "field"
4696 },
4697 {
4698 "params": [],
4699 "type": "count"
4700 }
4701 ]
4702 ],
4703 "tags": [
4704 {
4705 "key": "rcode::field",
4706 "operator": "=",
4707 "value": "3"
4708 },
4709 {
4710 "condition": "AND",
4711 "key": "direction::tag",
4712 "operator": "=",
4713 "value": "out_packet"
4714 }
4715 ]
4716 },
4717 "labels": {
4718 "grafana.app/export-label": "influxdb-1"
4719 }
4720 },
4721 "refId": "B",
4722 "hidden": false
4723 }
4724 }
4725 ],
4726 "transformations": [],
4727 "queryOptions": {}
4728 }
4729 },
4730 "vizConfig": {
4731 "kind": "VizConfig",
4732 "group": "timeseries",
4733 "version": "13.0.1+security-01",
4734 "spec": {
4735 "options": {
4736 "annotations": {
4737 "clustering": -1,
4738 "multiLane": false
4739 },
4740 "legend": {
4741 "calcs": [],
4742 "displayMode": "list",
4743 "placement": "bottom",
4744 "showLegend": true
4745 },
4746 "tooltip": {
4747 "hideZeros": false,
4748 "mode": "single",
4749 "sort": "none"
4750 }
4751 },
4752 "fieldConfig": {
4753 "defaults": {
4754 "thresholds": {
4755 "mode": "absolute",
4756 "steps": [
4757 {
4758 "value": 0,
4759 "color": "green"
4760 },
4761 {
4762 "value": 80,
4763 "color": "red"
4764 }
4765 ]
4766 },
4767 "color": {
4768 "mode": "palette-classic"
4769 },
4770 "custom": {
4771 "axisBorderShow": false,
4772 "axisCenteredZero": false,
4773 "axisColorMode": "text",
4774 "axisLabel": "",
4775 "axisPlacement": "auto",
4776 "barAlignment": 0,
4777 "barWidthFactor": 0.6,
4778 "drawStyle": "line",
4779 "fillOpacity": 10,
4780 "gradientMode": "none",
4781 "hideFrom": {
4782 "legend": false,
4783 "tooltip": false,
4784 "viz": false
4785 },
4786 "insertNulls": false,
4787 "lineInterpolation": "smooth",
4788 "lineWidth": 1,
4789 "pointSize": 5,
4790 "scaleDistribution": {
4791 "type": "linear"
4792 },
4793 "showPoints": "auto",
4794 "showValues": false,
4795 "spanNulls": false,
4796 "stacking": {
4797 "group": "A",
4798 "mode": "none"
4799 },
4800 "thresholdsStyle": {
4801 "mode": "off"
4802 }
4803 }
4804 },
4805 "overrides": []
4806 }
4807 }
4808 }
4809 }
4810 },
4811 "panel-9": {
4812 "kind": "Panel",
4813 "spec": {
4814 "id": 9,
4815 "title": "Samba: клиентов сейчас",
4816 "description": "Текущее число подключённых SMB-клиентов (последний опрос smbstatus -v, первый блок).",
4817 "links": [],
4818 "data": {
4819 "kind": "QueryGroup",
4820 "spec": {
4821 "queries": [
4822 {
4823 "kind": "PanelQuery",
4824 "spec": {
4825 "query": {
4826 "kind": "DataQuery",
4827 "group": "influxdb",
4828 "version": "v0",
4829 "spec": {
4830 "alias": "clients",
4831 "groupBy": [
4832 {
4833 "params": [
4834 "$interval"
4835 ],
4836 "type": "time"
4837 },
4838 {
4839 "params": [
4840 "null"
4841 ],
4842 "type": "fill"
4843 }
4844 ],
4845 "measurement": "samba_clients",
4846 "orderByTime": "ASC",
4847 "policy": "default",
4848 "query": "SELECT last(\"count\") FROM \"samba_clients\" WHERE $timeFilter GROUP BY time($interval) fill(null)",
4849 "rawQuery": false,
4850 "resultFormat": "time_series",
4851 "select": [
4852 [
4853 {
4854 "params": [
4855 "count"
4856 ],
4857 "type": "field"
4858 },
4859 {
4860 "params": [],
4861 "type": "last"
4862 }
4863 ]
4864 ],
4865 "tags": []
4866 },
4867 "labels": {
4868 "grafana.app/export-label": "influxdb-1"
4869 }
4870 },
4871 "refId": "A",
4872 "hidden": false
4873 }
4874 }
4875 ],
4876 "transformations": [],
4877 "queryOptions": {}
4878 }
4879 },
4880 "vizConfig": {
4881 "kind": "VizConfig",
4882 "group": "stat",
4883 "version": "13.0.1+security-01",
4884 "spec": {
4885 "options": {
4886 "colorMode": "value",
4887 "graphMode": "area",
4888 "justifyMode": "auto",
4889 "orientation": "auto",
4890 "percentChangeColorMode": "standard",
4891 "reduceOptions": {
4892 "calcs": [
4893 "lastNotNull"
4894 ],
4895 "fields": "",
4896 "values": false
4897 },
4898 "showPercentChange": false,
4899 "textMode": "auto",
4900 "wideLayout": true
4901 },
4902 "fieldConfig": {
4903 "defaults": {
4904 "unit": "none",
4905 "thresholds": {
4906 "mode": "absolute",
4907 "steps": [
4908 {
4909 "value": 0,
4910 "color": "green"
4911 },
4912 {
4913 "value": null,
4914 "color": "red"
4915 }
4916 ]
4917 },
4918 "color": {
4919 "mode": "palette-classic"
4920 }
4921 },
4922 "overrides": []
4923 }
4924 }
4925 }
4926 }
4927 }
4928 },
4929 "layout": {
4930 "kind": "GridLayout",
4931 "spec": {
4932 "items": [
4933 {
4934 "kind": "GridLayoutItem",
4935 "spec": {
4936 "x": 0,
4937 "y": 0,
4938 "width": 11,
4939 "height": 10,
4940 "element": {
4941 "kind": "ElementReference",
4942 "name": "panel-11"
4943 }
4944 }
4945 },
4946 {
4947 "kind": "GridLayoutItem",
4948 "spec": {
4949 "x": 11,
4950 "y": 0,
4951 "width": 13,
4952 "height": 10,
4953 "element": {
4954 "kind": "ElementReference",
4955 "name": "panel-1"
4956 }
4957 }
4958 },
4959 {
4960 "kind": "GridLayoutItem",
4961 "spec": {
4962 "x": 0,
4963 "y": 10,
4964 "width": 24,
4965 "height": 10,
4966 "element": {
4967 "kind": "ElementReference",
4968 "name": "panel-12"
4969 }
4970 }
4971 },
4972 {
4973 "kind": "GridLayoutItem",
4974 "spec": {
4975 "x": 0,
4976 "y": 20,
4977 "width": 24,
4978 "height": 10,
4979 "element": {
4980 "kind": "ElementReference",
4981 "name": "panel-27"
4982 }
4983 }
4984 },
4985 {
4986 "kind": "GridLayoutItem",
4987 "spec": {
4988 "x": 0,
4989 "y": 30,
4990 "width": 8,
4991 "height": 11,
4992 "element": {
4993 "kind": "ElementReference",
4994 "name": "panel-21"
4995 }
4996 }
4997 },
4998 {
4999 "kind": "GridLayoutItem",
5000 "spec": {
5001 "x": 8,
5002 "y": 30,
5003 "width": 16,
5004 "height": 11,
5005 "element": {
5006 "kind": "ElementReference",
5007 "name": "panel-20"
5008 }
5009 }
5010 },
5011 {
5012 "kind": "GridLayoutItem",
5013 "spec": {
5014 "x": 0,
5015 "y": 41,
5016 "width": 11,
5017 "height": 11,
5018 "element": {
5019 "kind": "ElementReference",
5020 "name": "panel-16"
5021 }
5022 }
5023 },
5024 {
5025 "kind": "GridLayoutItem",
5026 "spec": {
5027 "x": 11,
5028 "y": 41,
5029 "width": 13,
5030 "height": 11,
5031 "element": {
5032 "kind": "ElementReference",
5033 "name": "panel-13"
5034 }
5035 }
5036 },
5037 {
5038 "kind": "GridLayoutItem",
5039 "spec": {
5040 "x": 0,
5041 "y": 52,
5042 "width": 11,
5043 "height": 10,
5044 "element": {
5045 "kind": "ElementReference",
5046 "name": "panel-17"
5047 }
5048 }
5049 },
5050 {
5051 "kind": "GridLayoutItem",
5052 "spec": {
5053 "x": 11,
5054 "y": 52,
5055 "width": 13,
5056 "height": 10,
5057 "element": {
5058 "kind": "ElementReference",
5059 "name": "panel-22"
5060 }
5061 }
5062 },
5063 {
5064 "kind": "GridLayoutItem",
5065 "spec": {
5066 "x": 0,
5067 "y": 62,
5068 "width": 16,
5069 "height": 10,
5070 "element": {
5071 "kind": "ElementReference",
5072 "name": "panel-24"
5073 }
5074 }
5075 },
5076 {
5077 "kind": "GridLayoutItem",
5078 "spec": {
5079 "x": 16,
5080 "y": 62,
5081 "width": 8,
5082 "height": 10,
5083 "element": {
5084 "kind": "ElementReference",
5085 "name": "panel-23"
5086 }
5087 }
5088 },
5089 {
5090 "kind": "GridLayoutItem",
5091 "spec": {
5092 "x": 0,
5093 "y": 72,
5094 "width": 8,
5095 "height": 9,
5096 "element": {
5097 "kind": "ElementReference",
5098 "name": "panel-14"
5099 }
5100 }
5101 },
5102 {
5103 "kind": "GridLayoutItem",
5104 "spec": {
5105 "x": 8,
5106 "y": 72,
5107 "width": 9,
5108 "height": 9,
5109 "element": {
5110 "kind": "ElementReference",
5111 "name": "panel-26"
5112 }
5113 }
5114 },
5115 {
5116 "kind": "GridLayoutItem",
5117 "spec": {
5118 "x": 17,
5119 "y": 72,
5120 "width": 7,
5121 "height": 9,
5122 "element": {
5123 "kind": "ElementReference",
5124 "name": "panel-25"
5125 }
5126 }
5127 },
5128 {
5129 "kind": "GridLayoutItem",
5130 "spec": {
5131 "x": 0,
5132 "y": 81,
5133 "width": 8,
5134 "height": 8,
5135 "element": {
5136 "kind": "ElementReference",
5137 "name": "panel-15"
5138 }
5139 }
5140 },
5141 {
5142 "kind": "GridLayoutItem",
5143 "spec": {
5144 "x": 8,
5145 "y": 81,
5146 "width": 8,
5147 "height": 8,
5148 "element": {
5149 "kind": "ElementReference",
5150 "name": "panel-18"
5151 }
5152 }
5153 },
5154 {
5155 "kind": "GridLayoutItem",
5156 "spec": {
5157 "x": 16,
5158 "y": 81,
5159 "width": 8,
5160 "height": 8,
5161 "element": {
5162 "kind": "ElementReference",
5163 "name": "panel-19"
5164 }
5165 }
5166 },
5167 {
5168 "kind": "GridLayoutItem",
5169 "spec": {
5170 "x": 0,
5171 "y": 89,
5172 "width": 12,
5173 "height": 7,
5174 "element": {
5175 "kind": "ElementReference",
5176 "name": "panel-7"
5177 }
5178 }
5179 },
5180 {
5181 "kind": "GridLayoutItem",
5182 "spec": {
5183 "x": 12,
5184 "y": 89,
5185 "width": 12,
5186 "height": 7,
5187 "element": {
5188 "kind": "ElementReference",
5189 "name": "panel-8"
5190 }
5191 }
5192 },
5193 {
5194 "kind": "GridLayoutItem",
5195 "spec": {
5196 "x": 0,
5197 "y": 96,
5198 "width": 12,
5199 "height": 8,
5200 "element": {
5201 "kind": "ElementReference",
5202 "name": "panel-2"
5203 }
5204 }
5205 },
5206 {
5207 "kind": "GridLayoutItem",
5208 "spec": {
5209 "x": 12,
5210 "y": 96,
5211 "width": 12,
5212 "height": 8,
5213 "element": {
5214 "kind": "ElementReference",
5215 "name": "panel-3"
5216 }
5217 }
5218 },
5219 {
5220 "kind": "GridLayoutItem",
5221 "spec": {
5222 "x": 0,
5223 "y": 104,
5224 "width": 12,
5225 "height": 8,
5226 "element": {
5227 "kind": "ElementReference",
5228 "name": "panel-4"
5229 }
5230 }
5231 },
5232 {
5233 "kind": "GridLayoutItem",
5234 "spec": {
5235 "x": 12,
5236 "y": 104,
5237 "width": 12,
5238 "height": 8,
5239 "element": {
5240 "kind": "ElementReference",
5241 "name": "panel-5"
5242 }
5243 }
5244 },
5245 {
5246 "kind": "GridLayoutItem",
5247 "spec": {
5248 "x": 0,
5249 "y": 112,
5250 "width": 12,
5251 "height": 8,
5252 "element": {
5253 "kind": "ElementReference",
5254 "name": "panel-6"
5255 }
5256 }
5257 },
5258 {
5259 "kind": "GridLayoutItem",
5260 "spec": {
5261 "x": 0,
5262 "y": 120,
5263 "width": 6,
5264 "height": 8,
5265 "element": {
5266 "kind": "ElementReference",
5267 "name": "panel-9"
5268 }
5269 }
5270 },
5271 {
5272 "kind": "GridLayoutItem",
5273 "spec": {
5274 "x": 6,
5275 "y": 120,
5276 "width": 18,
5277 "height": 8,
5278 "element": {
5279 "kind": "ElementReference",
5280 "name": "panel-10"
5281 }
5282 }
5283 }
5284 ]
5285 }
5286 },
5287 "links": [],
5288 "liveNow": false,
5289 "preload": false,
5290 "tags": [
5291 "samba",
5292 "ad",
5293 "audit"
5294 ],
5295 "timeSettings": {
5296 "timezone": "browser",
5297 "from": "now-6h",
5298 "to": "now",
5299 "autoRefresh": "",
5300 "autoRefreshIntervals": [
5301 "5s",
5302 "10s",
5303 "30s",
5304 "1m",
5305 "5m",
5306 "15m",
5307 "30m",
5308 "1h",
5309 "2h",
5310 "1d"
5311 ],
5312 "hideTimepicker": false,
5313 "fiscalYearStartMonth": 0
5314 },
5315 "title": "Samba AD audit2",
5316 "variables": [
5317 {
5318 "kind": "IntervalVariable",
5319 "spec": {
5320 "name": "interval",
5321 "query": "1s,3s,5s,10s,30s,1m,10m,30m,1h,6h,12h,1d,7d,14d,30d",
5322 "current": {
5323 "text": "1m",
5324 "value": "1m"
5325 },
5326 "options": [
5327 {
5328 "selected": true,
5329 "text": "1m",
5330 "value": "1m"
5331 },
5332 {
5333 "selected": false,
5334 "text": "10m",
5335 "value": "10m"
5336 },
5337 {
5338 "selected": false,
5339 "text": "30m",
5340 "value": "30m"
5341 },
5342 {
5343 "selected": false,
5344 "text": "1h",
5345 "value": "1h"
5346 },
5347 {
5348 "selected": false,
5349 "text": "6h",
5350 "value": "6h"
5351 },
5352 {
5353 "selected": false,
5354 "text": "12h",
5355 "value": "12h"
5356 },
5357 {
5358 "selected": false,
5359 "text": "1d",
5360 "value": "1d"
5361 }
5362 ],
5363 "auto": false,
5364 "auto_min": "10s",
5365 "auto_count": 30,
5366 "refresh": "onTimeRangeChanged",
5367 "hide": "dontHide",
5368 "skipUrlSync": false
5369 }
5370 }
5371 ],
5372 "preferences": {
5373 "layout": {
5374 "kind": "GridLayout",
5375 "spec": {
5376 "items": []
5377 }
5378 }
5379 }
5380 }
5381}