Automated Certificate Management Environment(ACME)プロトコルはインターネットセキュリティを向上させるために開発されたプロトコルで、Let's Encryptサービスでの使用を念頭に設定されています。セキュリティエンジニアのChristophe Brocas氏は自身のブログにてACMEプロトコルの歴史を振り返り、ACMEの起源・概念・標準化・エコシステム・進化の課題について概説しています。
◆インターネットの興隆期
1990年代にインターネットが世界的に普及し、コンピューターが相互接続された広大なネットの世界の中でユーザーは垣根なく通信できるようになりました。
IP・TCP・UDP・DNSなどといったプロトコルを基盤に構築されたHTTPとHTMLの組み合わせが、以後30年間にわたりインターネットの主要な通信プラットフォームとしてウェブを推進し続けています。
しかしながら、インターネットによるコミュニケーションの発展の陰で、認証・完全性・機密性といったものは軽んじられてきました。2015年の時点ですら、ウェブサイトの中でHTTPS接続を行っていたものはせいぜい40%程度です。
◆Let’s Encryptの誕生
Let’s Encryptの設計者の一人であり、Firefoxの暗号化チームを率いた後、現在はFirefoxのSRE(Site Reliability Engineer)を務めるJ.C. Jones氏は、暗号化の普及における主な障壁について尋ねられた際に「ウェブ上を流れる情報は増え続ける一方で、転送データのほとんどはTLSによる完全性や機密性の保護を受けていませんでした。あらゆる場面でTLSを利用する際の最大の障壁は、サーバー側の証明書の取得と管理でした。そこで生まれたのがLet’s Encryptです」と答えています。
◆証明書発行の自動化
Let's EncryptはACMEプロトコルを用いて自動で証明書を発行しています。2020年代半ばの視点に立てばLet's Encryptの核である自動化は当然のものであるように見えるものの、2010年代前半では決して普通ではありませんでした。
◆ACMEの誕生
ACMEは当初からLet’s Encryptの中核を成しており、どんなユースケースに対しても可能な限りカバーできるよう改良されてきました。ACMEとLet's EncryptのルーツについてはACM CCS 2019で発表されたLet's Encryptに関する論文によると、「証明書を自動的に発行・更新するプロトコルを開発しているチーム」と「無料かつ自動化された証明書認証局を作成するチーム」があったことが窺えます。二つのチームが互いの研究を発見し協力したことがACMEプロトコルとLet's Encryptにおける実装に結びついています。
◆標準化とオープンソース
ACMEは当初からオープンにドキュメント化されており、最初のオープンソースACMEクライアントであるCertbotがクライアント側の参照実装として機能しました。またIETFを通じた標準化プロセスにより2019年3月にはRFC 8555が制定されています。オープンで標準化されたプロトコルとした結果として、非常に幅広いユースケースをカバーする多数のACMEクライアントが誕生しました。J.C. Jones氏は「これが我々が予見した、あるいは少なくとも望んでいたことだ」と、当初からの目標だったことを述懐しています。
⇧ とりあえず、「多数のACMEクライアント」は標準的な仕様に準拠しているということで良いんだろうか？
独自仕様で乱立しているとしたら、混沌を極めた状態と言わざるを得ないのだが...
いずれにしろ、「自動化」を実現するには「コスト」がかかるということですかね...
兎にも角にも、学習コストがネックなのですな...
Zabbix APIの実行したSQLのクエリはデータベース側の設定で取得するしか無さそうだが...
前に、
⇧ 上記の記事の時に、「Zabbix API」を「Python」から実行したのだが、「Zabbix API」の実行した「SQL」の「クエリ」が、「Zabbix」の「ログ」として取得が難しそうであると。
ちなみに、
⇧ 上記の内容に、「Zabbix API」が実行した「SQL」の「クエリ」は含まれない模様。
少なくとも、今回、検証した「template.get」が実行した「SQL」の「クエリ」は出力されなかった...
ネットの情報を漁っていたところ、
⇧ 上記サイト様にありますように、「MySQL」側で「クエリーログ」を取得する設定を有効にするしか無さそう。
試してみる。
[vagrant@database ~]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1091 Server version: 8.0.44 MySQL Community Server - GPL Copyright (c) 2000, 2025, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like 'general_log%'; +------------------+-----------------------------+ | Variable_name | Value | +------------------+-----------------------------+ | general_log | OFF | | general_log_file | /var/lib/mysql/database.log | +------------------+-----------------------------+ 2 rows in set (0.00 sec) mysql> set global general_log = on; Query OK, 0 rows affected (0.03 sec) mysql> show variables like 'general_log%'; +------------------+-----------------------------+ | Variable_name | Value | +------------------+-----------------------------+ | general_log | ON | | general_log_file | /var/lib/mysql/database.log | +------------------+-----------------------------+ 2 rows in set (0.01 sec) mysql> show variables like 'general_log%'; +------------------+-----------------------------+ | Variable_name | Value | +------------------+-----------------------------+ | general_log | ON | | general_log_file | /var/lib/mysql/database.log | +------------------+-----------------------------+ 2 rows in set (0.01 sec) mysql> exit Bye
[vagrant@database ~]$ sudo ls -la /var/lib/mysql total 145412 drwxr-x--x. 8 mysql mysql 4096 Jan 8 20:51 . drwxr-xr-x. 46 root root 4096 Jan 3 11:03 .. -rw-r-----. 1 mysql mysql 56 Jan 3 11:03 auto.cnf -rw-r-----. 1 mysql mysql 180 Jan 3 11:03 binlog.000001 -rw-r-----. 1 mysql mysql 34092917 Jan 8 14:28 binlog.000002 -rw-r-----. 1 mysql mysql 6004 Jan 8 20:32 binlog.000003 -rw-r-----. 1 mysql mysql 48 Jan 8 14:28 binlog.index -rw-------. 1 mysql mysql 1680 Jan 3 11:03 ca-key.pem -rw-r--r--. 1 mysql mysql 1112 Jan 3 11:03 ca.pem -rw-r--r--. 1 mysql mysql 1112 Jan 3 11:03 client-cert.pem -rw-------. 1 mysql mysql 1680 Jan 3 11:03 client-key.pem -rw-r-----. 1 mysql mysql 15966 Jan 8 20:54 database.log -rw-r-----. 1 mysql mysql 196608 Jan 8 20:54 '#ib_16384_0.dblwr' -rw-r-----. 1 mysql mysql 8585216 Jan 3 11:03 '#ib_16384_1.dblwr' -rw-r-----. 1 mysql mysql 3587 Jan 3 11:03 ib_buffer_pool -rw-r-----. 1 mysql mysql 12582912 Jan 8 20:54 ibdata1 -rw-r-----. 1 mysql mysql 12582912 Jan 8 14:28 ibtmp1 drwxr-x---. 2 mysql mysql 4096 Jan 8 14:28 '#innodb_redo' drwxr-x---. 2 mysql mysql 187 Jan 8 14:28 '#innodb_temp' drwxr-x---. 2 mysql mysql 143 Jan 3 11:03 mysql -rw-r-----. 1 mysql mysql 30408704 Jan 8 20:13 mysql.ibd srwxrwxrwx. 1 mysql mysql 0 Jan 8 14:28 mysql.sock -rw-------. 1 mysql mysql 5 Jan 8 14:28 mysql.sock.lock drwxr-x---. 2 mysql mysql 8192 Jan 3 11:03 performance_schema -rw-------. 1 mysql mysql 1676 Jan 3 11:03 private_key.pem -rw-r--r--. 1 mysql mysql 452 Jan 3 11:03 public_key.pem -rw-r--r--. 1 mysql mysql 1112 Jan 3 11:03 server-cert.pem -rw-------. 1 mysql mysql 1680 Jan 3 11:03 server-key.pem drwxr-x---. 2 mysql mysql 28 Jan 3 11:03 sys -rw-r-----. 1 mysql mysql 16777216 Jan 8 20:32 undo_001 -rw-r-----. 1 mysql mysql 33554432 Jan 8 20:34 undo_002 drwxr-x---. 2 mysql mysql 8192 Jan 3 11:20 zabbix
で、「Zabbix」が稼働している「仮想マシン」にログインし、「ポート」をマッピングし、「Dev Containers」で稼働している「Dockerコンテナ」で稼働している「Python」の「アプリケーション」と疎通できるようにしておく。
sudo iptables -t nat -A DOCKER ! -i docker0 -p tcp -m tcp --dport 8000 -j DNAT --to-destination 172.17.0.2:8000 sudo iptables -A FORWARD -d 172.17.0.2/32 ! -i docker0 -o docker0 -p tcp -m tcp --dport 8000 -j ACCEPT
⇧「Dev Containers」の初回起動時に「ポート」をマッピングしておけば不要になるのだが、初回起動時の「ポート」のマッピングの方法が分からないので暫定対応としてる。
毎回思うが、「Dockerコンテナ」の「ポート」のマッピングが初回作成時のみ設定可能で、後から変更できない仕様なのは鬼畜過ぎますな...
そしたらば、「Zabbix API」のリクエストを実行する。
curl -X POST \
-H "Content-Type: application/json" \
-d '{
"jsonrpc": "2.0",
"method": "template.get",
"params": {
"output": ["hostid"],
"selectTemplateGroups": "extend",
"filter": {
"host": ["Linux by Zabbix agent"]
}
},
"id": 1
}' \
http://192.168.56.211:8000/api/info
そしたらば、「MySQL」の「クエリーログ」を確認する。
[vagrant@database ~]$ sudo less /var/lib/mysql/database.log
クエリーログのファイルの中身を抜粋。
2026-01-08T11:59:16.556728Z 1126 Connect zabbix@192.168.111.211 on zabbix using TCP/IP
2026-01-08T11:59:16.558178Z 1126 Query SET NAMES utf8mb4
2026-01-08T11:59:16.559878Z 1126 Query SET autocommit=1
2026-01-08T11:59:16.561938Z 1126 Init DB zabbix
2026-01-08T11:59:16.564798Z 1126 Query select userid from users limit 1
2026-01-08T11:59:16.567258Z 1126 Query select default_character_set_name,default_collation_name from information_schema.SCHEMATA where schema_name='zabbix'
2026-01-08T11:59:16.569150Z 1126 Query select count(*) from information_schema.`COLUMNS` where table_schema='zabbix' and data_type in ('text','varchar','longtext') and (character_set_name not in ('utf8','utf8mb3','utf8mb4') or collation_name not in ('utf8_bin','utf8mb3_bin','utf8mb4_bin'))
2026-01-08T11:59:16.577063Z 1126 Query show tables like 'dbversion'
2026-01-08T11:59:16.579612Z 1126 Query select mandatory,optional from dbversion
2026-01-08T11:59:16.581651Z 1126 Query show columns from config like 'dbversion_status'
2026-01-08T11:59:16.584635Z 1126 Query show index from history where key_name='PRIMARY'
2026-01-08T11:59:16.586817Z 1126 Query update config set dbversion_status='[{"database":"MySQL","current_version":"8.00.44","min_version":"5.07.28","max_version":"9.05.x","history_pk":1,"min_supported_version":"8.00.30","flag":0}]'
2026-01-08T11:59:16.588567Z 1126 Query select software_update_checkid from config
2026-01-08T11:59:16.590474Z 1126 Query update config set server_status='{"version":"7.0.22","configuration":{"enable_global_scripts":false,"allow_software_update_check":true}}'
2026-01-08T11:59:16.591899Z 1126 Query select configid,instanceid from config order by configid
2026-01-08T11:59:16.594710Z 1126 Quit
2026-01-08T11:59:37.785572Z 1127 Connect zabbix@192.168.111.211 on zabbix using TCP/IP
2026-01-08T11:59:37.786997Z 1127 Query SET NAMES utf8mb4
2026-01-08T11:59:37.788688Z 1127 Query SET autocommit=1
2026-01-08T11:59:37.790158Z 1127 Init DB zabbix
2026-01-08T11:59:37.791650Z 1127 Query select userid from users limit 1
2026-01-08T11:59:37.793628Z 1127 Query select default_character_set_name,default_collation_name from information_schema.SCHEMATA where schema_name='zabbix'
2026-01-08T11:59:37.795651Z 1127 Query select count(*) from information_schema.`COLUMNS` where table_schema='zabbix' and data_type in ('text','varchar','longtext') and (character_set_name not in ('utf8','utf8mb3','utf8mb4') or collation_name not in ('utf8_bin','utf8mb3_bin','utf8mb4_bin'))
2026-01-08T11:59:37.806010Z 1127 Query show tables like 'dbversion'
2026-01-08T11:59:37.808859Z 1127 Query select mandatory,optional from dbversion
2026-01-08T11:59:37.810761Z 1127 Query show columns from config like 'dbversion_status'
2026-01-08T11:59:37.817277Z 1127 Query show index from history where key_name='PRIMARY'
2026-01-08T11:59:37.821696Z 1127 Query update config set dbversion_status='[{"database":"MySQL","current_version":"8.00.44","min_version":"5.07.28","max_version":"9.05.x","history_pk":1,"min_supported_version":"8.00.30","flag":0}]'
2026-01-08T11:59:37.823601Z 1127 Query select software_update_checkid from config
2026-01-08T11:59:37.825626Z 1127 Query update config set server_status='{"version":"7.0.22","configuration":{"enable_global_scripts":false,"allow_software_update_check":true}}'
2026-01-08T11:59:37.827671Z 1127 Query select configid,instanceid from config order by configid
2026-01-08T11:59:37.829114Z 1127 Quit
2026-01-08T11:59:49.685345Z 1128 Connect zabbix@192.168.111.211 on zabbix using SSL/TLS
2026-01-08T11:59:49.699316Z 1128 Query SET AUTOCOMMIT=1
2026-01-08T11:59:49.707036Z 1128 Query SHOW VARIABLES LIKE 'innodb_snapshot_isolation'
2026-01-08T11:59:49.717755Z 1128 Query SET NAMES utf8mb4
2026-01-08T11:59:49.755218Z 1128 Query SHOW STATUS LIKE 'ssl_cipher'
2026-01-08T11:59:49.772922Z 1128 Query SELECT NULL FROM dbversion LIMIT 1
2026-01-08T11:59:49.781428Z 1128 Query SELECT dv.mandatory FROM dbversion dv
2026-01-08T11:59:49.783735Z 1128 Query SELECT NULL FROM config c
2026-01-08T11:59:49.806763Z 1128 Query SELECT han.ha_nodeid,han.address,han.port,han.status FROM ha_node han ORDER BY han.lastaccess DESC
2026-01-08T11:59:49.814995Z 1128 Query SELECT configid,session_key,dbversion_status,server_status,software_update_checkid,software_update_check_data FROM config
2026-01-08T11:59:49.820304Z 1128 Query BEGIN
2026-01-08T11:59:49.823086Z 1128 Query COMMIT
2026-01-08T11:59:49.827281Z 1128 Quit
2026-01-08T11:59:49.881760Z 1129 Connect zabbix@192.168.111.211 on zabbix using SSL/TLS
2026-01-08T11:59:49.884104Z 1129 Query SET AUTOCOMMIT=1
2026-01-08T11:59:49.885804Z 1129 Query SHOW VARIABLES LIKE 'innodb_snapshot_isolation'
2026-01-08T11:59:49.890238Z 1129 Query SET NAMES utf8mb4
2026-01-08T11:59:49.891628Z 1129 Query SHOW STATUS LIKE 'ssl_cipher'
2026-01-08T11:59:49.894716Z 1129 Query SELECT NULL FROM dbversion LIMIT 1
2026-01-08T11:59:49.896166Z 1129 Query SELECT dv.mandatory FROM dbversion dv
2026-01-08T11:59:49.898686Z 1129 Query SELECT NULL FROM config c
2026-01-08T11:59:49.925716Z 1129 Query SELECT han.ha_nodeid,han.address,han.port,han.status FROM ha_node han ORDER BY han.lastaccess DESC
2026-01-08T11:59:49.936090Z 1129 Query SELECT configid,session_key,dbversion_status,server_status,software_update_checkid,software_update_check_data FROM config
2026-01-08T11:59:49.949823Z 1129 Query BEGIN
2026-01-08T11:59:49.971906Z 1129 Query SELECT c.configid,c.authentication_type,c.ldap_auth_enabled,c.ldap_case_sensitive,c.ldap_userdirectoryid,c.saml_auth_enabled,c.saml_case_sensitive,c.passwd_min_length,c.passwd_check_rules,c.disabled_usrgrpid,c.jit_provision_interval,c.saml_jit_status,c.ldap_jit_status,c.mfa_status,c.mfaid,c.http_auth_enabled,c.http_login_form,c.http_strip_domains,c.http_case_sensitive FROM config c
2026-01-08T11:59:49.978716Z 1129 Query SELECT userid,username,name,surname,url,autologin,autologout,lang,refresh,theme,attempt_failed,attempt_ip,attempt_clock,rows_per_page,timezone,roleid,userdirectoryid,ts_provisioned FROM users WHERE username='Admin'
2026-01-08T11:59:49.983682Z 1129 Query SELECT configid,authentication_type,http_auth_enabled,http_login_form,http_strip_domains,http_case_sensitive,saml_auth_enabled,saml_case_sensitive,saml_jit_status,disabled_usrgrpid,mfa_status,mfaid,ldap_userdirectoryid FROM config
2026-01-08T11:59:49.998953Z 1129 Query SELECT g.usrgrpid,g.debug_mode,g.users_status,g.gui_access,g.userdirectoryid,g.mfa_status,g.mfaid FROM users_groups ug,usrgrp g WHERE ug.usrgrpid=g.usrgrpid AND ug.userid=1
2026-01-08T11:59:50.000967Z 1129 Query SELECT configid,default_theme,server_check_interval,show_technical_errors,severity_color_0,severity_color_1,severity_color_2,severity_color_3,severity_color_4,severity_color_5,custom_color,problem_unack_color,problem_ack_color,ok_unack_color,ok_ack_color,default_lang,default_timezone,login_attempts,login_block,x_frame_options,auditlog_enabled FROM config
2026-01-08T11:59:50.004319Z 1129 Query SELECT userid,passwd FROM users WHERE userid=1
2026-01-08T11:59:50.070949Z 1129 Query SELECT type FROM role WHERE roleid='3'
2026-01-08T11:59:50.073806Z 1129 Query INSERT INTO sessions (sessionid,userid,lastaccess,status,secret) VALUES ('5b805e8d39feb2478f7c99b6a9cb9f54','1','1767873590','0','b7a5f3bce6d0d0c874b62f15ed3b8da4')
2026-01-08T11:59:50.082920Z 1129 Query INSERT INTO auditlog (auditid,userid,username,clock,ip,action,resourcetype,resourceid,resourcename,recordsetid,details) VALUES ('cmk5eagch0001newi39rffdt4','1','Admin','1767873590','172.17.0.2','8','0','1','','cmk5eagch0000newidb7431x6','')
2026-01-08T11:59:50.096751Z 1129 Query COMMIT
2026-01-08T11:59:50.114255Z 1129 Quit
2026-01-08T11:59:50.219259Z 1130 Connect zabbix@192.168.111.211 on zabbix using SSL/TLS
2026-01-08T11:59:50.221205Z 1130 Query SET AUTOCOMMIT=1
2026-01-08T11:59:50.222148Z 1130 Query SHOW VARIABLES LIKE 'innodb_snapshot_isolation'
2026-01-08T11:59:50.229709Z 1130 Query SET NAMES utf8mb4
2026-01-08T11:59:50.231352Z 1130 Query SHOW STATUS LIKE 'ssl_cipher'
2026-01-08T11:59:50.234720Z 1130 Query SELECT NULL FROM dbversion LIMIT 1
2026-01-08T11:59:50.236329Z 1130 Query SELECT dv.mandatory FROM dbversion dv
2026-01-08T11:59:50.238624Z 1130 Query SELECT NULL FROM config c
2026-01-08T11:59:50.266728Z 1130 Query SELECT han.ha_nodeid,han.address,han.port,han.status FROM ha_node han ORDER BY han.lastaccess DESC
2026-01-08T11:59:50.292919Z 1130 Query SELECT sessionid,userid,lastaccess,secret FROM sessions WHERE sessionid='5b805e8d39feb2478f7c99b6a9cb9f54' AND status=0
2026-01-08T11:59:50.312140Z 1130 Query SELECT userid,username,name,surname,url,autologin,autologout,lang,refresh,theme,attempt_failed,attempt_ip,attempt_clock,rows_per_page,timezone,roleid,userdirectoryid,ts_provisioned FROM users WHERE userid=1
2026-01-08T11:59:50.317745Z 1130 Query SELECT configid,authentication_type,http_auth_enabled,http_login_form,http_strip_domains,http_case_sensitive,saml_auth_enabled,saml_case_sensitive,saml_jit_status,disabled_usrgrpid,mfa_status,mfaid,ldap_userdirectoryid FROM config
2026-01-08T11:59:50.320188Z 1130 Query SELECT g.usrgrpid,g.debug_mode,g.users_status,g.gui_access,g.userdirectoryid,g.mfa_status,g.mfaid FROM users_groups ug,usrgrp g WHERE ug.usrgrpid=g.usrgrpid AND ug.userid=1
2026-01-08T11:59:50.322806Z 1130 Query SELECT c.configid,c.authentication_type,c.ldap_auth_enabled,c.ldap_case_sensitive,c.ldap_userdirectoryid,c.saml_auth_enabled,c.saml_case_sensitive,c.passwd_min_length,c.passwd_check_rules,c.disabled_usrgrpid,c.jit_provision_interval,c.saml_jit_status,c.ldap_jit_status,c.mfa_status,c.mfaid,c.http_auth_enabled,c.http_login_form,c.http_strip_domains,c.http_case_sensitive FROM config c
2026-01-08T11:59:50.324351Z 1130 Query SELECT type FROM role WHERE roleid='3'
2026-01-08T11:59:50.328959Z 1130 Query SELECT configid,default_theme,server_check_interval,show_technical_errors,severity_color_0,severity_color_1,severity_color_2,severity_color_3,severity_color_4,severity_color_5,custom_color,problem_unack_color,problem_ack_color,ok_unack_color,ok_ack_color,default_lang,default_timezone,login_attempts,login_block,x_frame_options,auditlog_enabled FROM config
2026-01-08T11:59:50.331114Z 1130 Query SELECT type,name,value_str,value_int FROM role_rule WHERE roleid='3' AND name LIKE 'api%' ORDER by name
2026-01-08T11:59:50.334690Z 1130 Query BEGIN
2026-01-08T11:59:50.335926Z 1130 Query SELECT h.hostid FROM hosts h WHERE h.status=3 AND h.host='Linux by Zabbix agent'
2026-01-08T11:59:50.338669Z 1130 Query SELECT t.hostgroupid,t.hostid,t.groupid FROM hosts_groups t WHERE t.hostid=10001
2026-01-08T11:59:50.341797Z 1130 Query SELECT g.groupid,g.name,g.uuid FROM hstgrp g WHERE g.type=1 AND g.groupid=10
2026-01-08T11:59:50.344760Z 1130 Query COMMIT
2026-01-08T11:59:50.369680Z 1130 Quit
2026-01-08T11:59:59.099413Z 1131 Connect zabbix@192.168.111.211 on zabbix using TCP/IP
2026-01-08T11:59:59.102453Z 1131 Query SET NAMES utf8mb4
2026-01-08T11:59:59.104541Z 1131 Query SET autocommit=1
2026-01-08T11:59:59.106843Z 1131 Init DB zabbix
2026-01-08T11:59:59.108455Z 1131 Query select userid from users limit 1
2026-01-08T11:59:59.110088Z 1131 Query select default_character_set_name,default_collation_name from information_schema.SCHEMATA where schema_name='zabbix'
2026-01-08T11:59:59.112029Z 1131 Query select count(*) from information_schema.`COLUMNS` where table_schema='zabbix' and data_type in ('text','varchar','longtext') and (character_set_name not in ('utf8','utf8mb3','utf8mb4') or collation_name not in ('utf8_bin','utf8mb3_bin','utf8mb4_bin'))
2026-01-08T11:59:59.119698Z 1131 Query show tables like 'dbversion'
2026-01-08T11:59:59.123735Z 1131 Query select mandatory,optional from dbversion
2026-01-08T11:59:59.125620Z 1131 Query show columns from config like 'dbversion_status'
2026-01-08T11:59:59.128414Z 1131 Query show index from history where key_name='PRIMARY'
2026-01-08T11:59:59.130606Z 1131 Query update config set dbversion_status='[{"database":"MySQL","current_version":"8.00.44","min_version":"5.07.28","max_version":"9.05.x","history_pk":1,"min_supported_version":"8.00.30","flag":0}]'
2026-01-08T11:59:59.132578Z 1131 Query select software_update_checkid from config
2026-01-08T11:59:59.134621Z 1131 Query update config set server_status='{"version":"7.0.22","configuration":{"enable_global_scripts":false,"allow_software_update_check":true}}'
2026-01-08T11:59:59.136060Z 1131 Query select configid,instanceid from config order by configid
2026-01-08T11:59:59.137640Z 1131 Quit
⇧ 非常に分かり辛いのだが、「Zabbix API」によって実行された「SQL」の「クエリ」がログに出力されていそう。
一応、「テーブル」などを確認する
[vagrant@database ~]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1161
Server version: 8.0.44 MySQL Community Server - GPL
Copyright (c) 2000, 2025, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| zabbix |
+--------------------+
5 rows in set (0.01 sec)
mysql> use zabbix
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SHOW TABLES;
+----------------------------+
| Tables_in_zabbix |
+----------------------------+
| acknowledges |
| actions |
| alerts |
| auditlog |
| autoreg_host |
| changelog |
| conditions |
| config |
| config_autoreg_tls |
| connector |
| connector_tag |
| corr_condition |
| corr_condition_group |
| corr_condition_tag |
| corr_condition_tagpair |
| corr_condition_tagvalue |
| corr_operation |
| correlation |
| dashboard |
| dashboard_page |
| dashboard_user |
| dashboard_usrgrp |
| dbversion |
| dchecks |
| dhosts |
| drules |
| dservices |
| escalations |
| event_recovery |
| event_suppress |
| event_symptom |
| event_tag |
| events |
| expressions |
| functions |
| globalmacro |
| globalvars |
| graph_discovery |
| graph_theme |
| graphs |
| graphs_items |
| group_discovery |
| group_prototype |
| ha_node |
| hgset |
| hgset_group |
| history |
| history_bin |
| history_log |
| history_str |
| history_text |
| history_uint |
| host_discovery |
| host_hgset |
| host_inventory |
| host_proxy |
| host_rtdata |
| host_tag |
| hostmacro |
| hosts |
| hosts_groups |
| hosts_templates |
| housekeeper |
| hstgrp |
| httpstep |
| httpstep_field |
| httpstepitem |
| httptest |
| httptest_field |
| httptest_tag |
| httptestitem |
| icon_map |
| icon_mapping |
| ids |
| images |
| interface |
| interface_discovery |
| interface_snmp |
| item_condition |
| item_discovery |
| item_parameter |
| item_preproc |
| item_rtdata |
| item_rtname |
| item_tag |
| items |
| lld_macro_path |
| lld_override |
| lld_override_condition |
| lld_override_opdiscover |
| lld_override_operation |
| lld_override_ophistory |
| lld_override_opinventory |
| lld_override_opperiod |
| lld_override_opseverity |
| lld_override_opstatus |
| lld_override_optag |
| lld_override_optemplate |
| lld_override_optrends |
| maintenance_tag |
| maintenances |
| maintenances_groups |
| maintenances_hosts |
| maintenances_windows |
| media |
| media_type |
| media_type_message |
| media_type_param |
| mfa |
| mfa_totp_secret |
| module |
| opcommand |
| opcommand_grp |
| opcommand_hst |
| opconditions |
| operations |
| opgroup |
| opinventory |
| opmessage |
| opmessage_grp |
| opmessage_usr |
| optag |
| optemplate |
| permission |
| problem |
| problem_tag |
| profiles |
| proxy |
| proxy_autoreg_host |
| proxy_dhistory |
| proxy_group |
| proxy_group_rtdata |
| proxy_history |
| proxy_rtdata |
| regexps |
| report |
| report_param |
| report_user |
| report_usrgrp |
| rights |
| role |
| role_rule |
| scim_group |
| script_param |
| scripts |
| service_alarms |
| service_problem |
| service_problem_tag |
| service_status_rule |
| service_tag |
| services |
| services_links |
| sessions |
| sla |
| sla_excluded_downtime |
| sla_schedule |
| sla_service_tag |
| sysmap_element_trigger |
| sysmap_element_url |
| sysmap_shape |
| sysmap_url |
| sysmap_user |
| sysmap_usrgrp |
| sysmaps |
| sysmaps_element_tag |
| sysmaps_elements |
| sysmaps_link_triggers |
| sysmaps_links |
| tag_filter |
| task |
| task_acknowledge |
| task_check_now |
| task_close_problem |
| task_data |
| task_remote_command |
| task_remote_command_result |
| task_result |
| timeperiods |
| token |
| trends |
| trends_uint |
| trigger_depends |
| trigger_discovery |
| trigger_queue |
| trigger_tag |
| triggers |
| ugset |
| ugset_group |
| user_scim_group |
| user_ugset |
| userdirectory |
| userdirectory_idpgroup |
| userdirectory_ldap |
| userdirectory_media |
| userdirectory_saml |
| userdirectory_usrgrp |
| users |
| users_groups |
| usrgrp |
| valuemap |
| valuemap_mapping |
| widget |
| widget_field |
+----------------------------+
203 rows in set (0.00 sec)
mysql> SELECT
-> TABLE_SCHEMA,
-> TABLE_NAME,
-> TABLE_ROWS
-> FROM
-> information_schema.TABLES
-> WHERE
-> TABLE_SCHEMA = 'zabbix' -- 対象のデータベース名
-> ORDER BY
-> TABLE_ROWS DESC;
+--------------+----------------------------+------------+
| TABLE_SCHEMA | TABLE_NAME | TABLE_ROWS |
+--------------+----------------------------+------------+
| zabbix | valuemap_mapping | 34501 |
| zabbix | item_tag | 28315 |
| zabbix | item_preproc | 23302 |
| zabbix | items | 17480 |
| zabbix | widget_field | 15980 |
| zabbix | functions | 10527 |
| zabbix | trigger_tag | 8520 |
| zabbix | item_discovery | 7425 |
| zabbix | triggers | 6708 |
| zabbix | hostmacro | 6384 |
| zabbix | graphs_items | 4910 |
| zabbix | item_condition | 3153 |
| zabbix | widget | 2640 |
| zabbix | graphs | 1940 |
| zabbix | trigger_depends | 1876 |
| zabbix | item_parameter | 1482 |
| zabbix | valuemap | 1417 |
| zabbix | host_tag | 1108 |
| zabbix | lld_macro_path | 983 |
| zabbix | media_type_param | 647 |
| zabbix | dashboard_page | 573 |
| zabbix | hosts | 385 |
| zabbix | hosts_groups | 361 |
| zabbix | dashboard | 355 |
| zabbix | host_hgset | 355 |
| zabbix | media_type_message | 252 |
| zabbix | lld_override_operation | 189 |
| zabbix | lld_override | 173 |
| zabbix | lld_override_condition | 173 |
| zabbix | lld_override_opdiscover | 158 |
| zabbix | images | 142 |
| zabbix | item_rtdata | 127 |
| zabbix | item_rtname | 121 |
| zabbix | group_prototype | 71 |
| zabbix | host_discovery | 50 |
| zabbix | hosts_templates | 46 |
| zabbix | media_type | 31 |
| zabbix | module | 30 |
| zabbix | role_rule | 27 |
| zabbix | interface | 26 |
| zabbix | hstgrp | 19 |
| zabbix | lld_override_opstatus | 16 |
| zabbix | hgset_group | 15 |
| zabbix | lld_override_optemplate | 15 |
| zabbix | auditlog | 14 |
| zabbix | sessions | 14 |
| zabbix | hgset | 13 |
| zabbix | lld_override_optag | 13 |
| zabbix | expressions | 10 |
| zabbix | operations | 10 |
| zabbix | opmessage | 8 |
| zabbix | conditions | 6 |
| zabbix | lld_override_opseverity | 6 |
| zabbix | usrgrp | 6 |
| zabbix | actions | 5 |
| zabbix | regexps | 5 |
| zabbix | users_groups | 5 |
| zabbix | graph_theme | 4 |
| zabbix | opmessage_grp | 4 |
| zabbix | role | 4 |
| zabbix | host_inventory | 3 |
| zabbix | scripts | 3 |
| zabbix | ugset_group | 3 |
| zabbix | users | 2 |
| zabbix | acknowledges | 0 |
| zabbix | alerts | 0 |
| zabbix | autoreg_host | 0 |
| zabbix | changelog | 0 |
| zabbix | config | 0 |
| zabbix | config_autoreg_tls | 0 |
| zabbix | connector | 0 |
| zabbix | connector_tag | 0 |
| zabbix | corr_condition | 0 |
| zabbix | corr_condition_group | 0 |
| zabbix | corr_condition_tag | 0 |
| zabbix | corr_condition_tagpair | 0 |
| zabbix | corr_condition_tagvalue | 0 |
| zabbix | corr_operation | 0 |
| zabbix | correlation | 0 |
| zabbix | dashboard_user | 0 |
| zabbix | dashboard_usrgrp | 0 |
| zabbix | dbversion | 0 |
| zabbix | dchecks | 0 |
| zabbix | dhosts | 0 |
| zabbix | drules | 0 |
| zabbix | dservices | 0 |
| zabbix | escalations | 0 |
| zabbix | event_recovery | 0 |
| zabbix | event_suppress | 0 |
| zabbix | event_symptom | 0 |
| zabbix | event_tag | 0 |
| zabbix | events | 0 |
| zabbix | globalmacro | 0 |
| zabbix | globalvars | 0 |
| zabbix | graph_discovery | 0 |
| zabbix | group_discovery | 0 |
| zabbix | ha_node | 0 |
| zabbix | history | 0 |
| zabbix | history_bin | 0 |
| zabbix | history_log | 0 |
| zabbix | history_str | 0 |
| zabbix | history_text | 0 |
| zabbix | history_uint | 0 |
| zabbix | host_proxy | 0 |
| zabbix | host_rtdata | 0 |
| zabbix | housekeeper | 0 |
| zabbix | httpstep | 0 |
| zabbix | httpstep_field | 0 |
| zabbix | httpstepitem | 0 |
| zabbix | httptest | 0 |
| zabbix | httptest_field | 0 |
| zabbix | httptest_tag | 0 |
| zabbix | httptestitem | 0 |
| zabbix | icon_map | 0 |
| zabbix | icon_mapping | 0 |
| zabbix | ids | 0 |
| zabbix | interface_discovery | 0 |
| zabbix | interface_snmp | 0 |
| zabbix | lld_override_ophistory | 0 |
| zabbix | lld_override_opinventory | 0 |
| zabbix | lld_override_opperiod | 0 |
| zabbix | lld_override_optrends | 0 |
| zabbix | maintenance_tag | 0 |
| zabbix | maintenances | 0 |
| zabbix | maintenances_groups | 0 |
| zabbix | maintenances_hosts | 0 |
| zabbix | maintenances_windows | 0 |
| zabbix | media | 0 |
| zabbix | mfa | 0 |
| zabbix | mfa_totp_secret | 0 |
| zabbix | opcommand | 0 |
| zabbix | opcommand_grp | 0 |
| zabbix | opcommand_hst | 0 |
| zabbix | opconditions | 0 |
| zabbix | opgroup | 0 |
| zabbix | opinventory | 0 |
| zabbix | opmessage_usr | 0 |
| zabbix | optag | 0 |
| zabbix | optemplate | 0 |
| zabbix | permission | 0 |
| zabbix | problem | 0 |
| zabbix | problem_tag | 0 |
| zabbix | profiles | 0 |
| zabbix | proxy | 0 |
| zabbix | proxy_autoreg_host | 0 |
| zabbix | proxy_dhistory | 0 |
| zabbix | proxy_group | 0 |
| zabbix | proxy_group_rtdata | 0 |
| zabbix | proxy_history | 0 |
| zabbix | proxy_rtdata | 0 |
| zabbix | report | 0 |
| zabbix | report_param | 0 |
| zabbix | report_user | 0 |
| zabbix | report_usrgrp | 0 |
| zabbix | rights | 0 |
| zabbix | scim_group | 0 |
| zabbix | script_param | 0 |
| zabbix | service_alarms | 0 |
| zabbix | service_problem | 0 |
| zabbix | service_problem_tag | 0 |
| zabbix | service_status_rule | 0 |
| zabbix | service_tag | 0 |
| zabbix | services | 0 |
| zabbix | services_links | 0 |
| zabbix | sla | 0 |
| zabbix | sla_excluded_downtime | 0 |
| zabbix | sla_schedule | 0 |
| zabbix | sla_service_tag | 0 |
| zabbix | sysmap_element_trigger | 0 |
| zabbix | sysmap_element_url | 0 |
| zabbix | sysmap_shape | 0 |
| zabbix | sysmap_url | 0 |
| zabbix | sysmap_user | 0 |
| zabbix | sysmap_usrgrp | 0 |
| zabbix | sysmaps | 0 |
| zabbix | sysmaps_element_tag | 0 |
| zabbix | sysmaps_elements | 0 |
| zabbix | sysmaps_link_triggers | 0 |
| zabbix | sysmaps_links | 0 |
| zabbix | tag_filter | 0 |
| zabbix | task | 0 |
| zabbix | task_acknowledge | 0 |
| zabbix | task_check_now | 0 |
| zabbix | task_close_problem | 0 |
| zabbix | task_data | 0 |
| zabbix | task_remote_command | 0 |
| zabbix | task_remote_command_result | 0 |
| zabbix | task_result | 0 |
| zabbix | timeperiods | 0 |
| zabbix | token | 0 |
| zabbix | trends | 0 |
| zabbix | trends_uint | 0 |
| zabbix | trigger_discovery | 0 |
| zabbix | trigger_queue | 0 |
| zabbix | ugset | 0 |
| zabbix | user_scim_group | 0 |
| zabbix | user_ugset | 0 |
| zabbix | userdirectory | 0 |
| zabbix | userdirectory_idpgroup | 0 |
| zabbix | userdirectory_ldap | 0 |
| zabbix | userdirectory_media | 0 |
| zabbix | userdirectory_saml | 0 |
| zabbix | userdirectory_usrgrp | 0 |
+--------------+----------------------------+------------+
203 rows in set (1.09 sec)
⇧ 用途が分からない「テーブル」が203個とか地獄なんだが...
「クエリーログ」はサイズが肥大し続けるようなので、無効に戻しておく。
mysql> set global general_log = off;
Query OK, 0 rows affected (0.01 sec)
mysql> show variables like 'general_log%';
+------------------+-----------------------------+
| Variable_name | Value |
+------------------+-----------------------------+
| general_log | OFF |
| general_log_file | /var/lib/mysql/database.log |
+------------------+-----------------------------+
2 rows in set (0.00 sec)
とりあえず、「Zabbix API」の処理の対象となる「テーブル」を特定する作業が地獄でしかないことは分かった...
「PHP」に詳しければ、
⇧ 上記の「ソースコード」を読解して、対象の「テーブル」を特定する方法もあるが...
ちなみに、「ChatGPT」氏に「Zabbix」がデフォルトで用意している「テンプレート」はどこで管理されているのか質問してみたところ、以下のような回答が返ってきた。
デフォルトテンプレートは
hostsテーブルでstatus = 3になっています：
🔎 補足：status = 3 がテンプレートであること
公式ドキュメントには直接の説明はありませんが、Zabbix コミュニティや実装レベルでは次のように扱われていることが確認できます：
hosts.statusの値- 0 = 監視ホスト
- 1 = 無効ホスト
- 3 = テンプレート（Template）
- 5 = Active Proxy 等の用途
- 6 = Passive Proxy
→ これを確認した forum の投稿
https://www.zabbix.com/forum/zabbix-help/36891-question-about-the-hosts-table
結局のところ、公式の「ドキュメント」では言及されていないというね...
mysql> SELECT hostid, host, name
-> FROM hosts
-> WHERE status = 3;
+--------+-------------------------------------------------------+-------------------------------------------------------+
| hostid | host | name |
+--------+-------------------------------------------------------+-------------------------------------------------------+
| 10001 | Linux by Zabbix agent | Linux by Zabbix agent |
| 10047 | Zabbix server health | Zabbix server health |
| 10048 | Zabbix proxy health | Zabbix proxy health |
| 10074 | OpenBSD by Zabbix agent | OpenBSD by Zabbix agent |
| 10075 | FreeBSD by Zabbix agent | FreeBSD by Zabbix agent |
| 10076 | AIX by Zabbix agent | AIX by Zabbix agent |
| 10077 | HP-UX by Zabbix agent | HP-UX by Zabbix agent |
| 10078 | Solaris by Zabbix agent | Solaris by Zabbix agent |
| 10079 | macOS by Zabbix agent | macOS by Zabbix agent |
| 10081 | Windows by Zabbix agent | Windows by Zabbix agent |
| 10169 | Generic Java JMX | Generic Java JMX |
| 10171 | Intel SR1530 IPMI | Intel SR1530 IPMI |
| 10172 | Intel SR1630 IPMI | Intel SR1630 IPMI |
| 10173 | VMware | VMware |
| 10174 | VMware Guest | VMware Guest |
| 10175 | VMware Hypervisor | VMware Hypervisor |
| 10207 | Alcatel Timetra TiMOS by SNMP | Alcatel Timetra TiMOS by SNMP |
| 10208 | Brocade FC by SNMP | Brocade FC by SNMP |
| 10210 | Brocade_Foundry Nonstackable by SNMP | Brocade_Foundry Nonstackable by SNMP |
| 10211 | Brocade_Foundry Stackable by SNMP | Brocade_Foundry Stackable by SNMP |
| 10218 | Cisco IOS by SNMP | Cisco IOS by SNMP |
| 10220 | Cisco IOS prior to 12.0_3_T by SNMP | Cisco IOS prior to 12.0_3_T by SNMP |
| 10221 | Dell Force S-Series by SNMP | Dell Force S-Series by SNMP |
| 10222 | D-Link DES 7200 by SNMP | D-Link DES 7200 by SNMP |
| 10223 | D-Link DES_DGS Switch by SNMP | D-Link DES_DGS Switch by SNMP |
| 10224 | Extreme EXOS by SNMP | Extreme EXOS by SNMP |
| 10226 | Network Generic Device by SNMP | Network Generic Device by SNMP |
| 10227 | HP Comware HH3C by SNMP | HP Comware HH3C by SNMP |
| 10229 | Huawei VRP by SNMP | Huawei VRP by SNMP |
| 10230 | Intel_Qlogic Infiniband by SNMP | Intel_Qlogic Infiniband by SNMP |
| 10231 | Juniper by SNMP | Juniper by SNMP |
| 10233 | Mikrotik by SNMP | Mikrotik by SNMP |
| 10234 | Netgear Fastpath by SNMP | Netgear Fastpath by SNMP |
| 10235 | QTech QSW by SNMP | QTech QSW by SNMP |
| 10236 | TP-LINK by SNMP | TP-LINK by SNMP |
| 10237 | Ubiquiti AirOS by SNMP | Ubiquiti AirOS by SNMP |
| 10248 | Linux by SNMP | Linux by SNMP |
| 10249 | Windows by SNMP | Windows by SNMP |
| 10250 | HP Enterprise Switch by SNMP | HP Enterprise Switch by SNMP |
| 10251 | Mellanox by SNMP | Mellanox by SNMP |
| 10253 | Cisco IOS versions 12.0_3_T-12.2_3.5 by SNMP | Cisco IOS versions 12.0_3_T-12.2_3.5 by SNMP |
| 10254 | Arista by SNMP | Arista by SNMP |
| 10255 | Dell iDRAC by SNMP | Dell iDRAC by SNMP |
| 10256 | HP iLO by SNMP | HP iLO by SNMP |
| 10258 | IBM IMM by SNMP | IBM IMM by SNMP |
| 10259 | Supermicro Aten by SNMP | Supermicro Aten by SNMP |
| 10260 | Apache Tomcat by JMX | Apache Tomcat by JMX |
| 10261 | Remote Zabbix server health | Remote Zabbix server health |
| 10262 | Remote Zabbix proxy health | Remote Zabbix proxy health |
| 10264 | Apache by Zabbix agent | Apache by Zabbix agent |
| 10265 | Apache by HTTP | Apache by HTTP |
| 10266 | Nginx by Zabbix agent | Nginx by Zabbix agent |
| 10267 | Nginx by HTTP | Nginx by HTTP |
| 10285 | Linux by Prom | Linux by Prom |
| 10300 | RabbitMQ cluster by Zabbix agent | RabbitMQ cluster by Zabbix agent |
| 10301 | RabbitMQ node by Zabbix agent | RabbitMQ node by Zabbix agent |
| 10302 | RabbitMQ cluster by HTTP | RabbitMQ cluster by HTTP |
| 10303 | RabbitMQ node by HTTP | RabbitMQ node by HTTP |
| 10304 | Cisco UCS by SNMP | Cisco UCS by SNMP |
| 10308 | HAProxy by Zabbix agent | HAProxy by Zabbix agent |
| 10309 | HAProxy by HTTP | HAProxy by HTTP |
| 10310 | Redis by Zabbix agent 2 | Redis by Zabbix agent 2 |
| 10316 | MySQL by Zabbix agent | MySQL by Zabbix agent |
| 10317 | MySQL by ODBC | MySQL by ODBC |
| 10318 | Docker by Zabbix agent 2 | Docker by Zabbix agent 2 |
| 10319 | Memcached by Zabbix agent 2 | Memcached by Zabbix agent 2 |
| 10320 | MySQL by Zabbix agent 2 | MySQL by Zabbix agent 2 |
| 10321 | Chassis by IPMI | Chassis by IPMI |
| 10322 | Elasticsearch Cluster by HTTP | Elasticsearch Cluster by HTTP |
| 10323 | ClickHouse by HTTP | ClickHouse by HTTP |
| 10324 | Etcd by HTTP | Etcd by HTTP |
| 10325 | IIS by Zabbix agent | IIS by Zabbix agent |
| 10326 | IIS by Zabbix agent active | IIS by Zabbix agent active |
| 10327 | MSSQL by ODBC | MSSQL by ODBC |
| 10328 | Oracle by ODBC | Oracle by ODBC |
| 10329 | PostgreSQL by Zabbix agent 2 | PostgreSQL by Zabbix agent 2 |
| 10330 | PHP-FPM by Zabbix agent | PHP-FPM by Zabbix agent |
| 10331 | PHP-FPM by HTTP | PHP-FPM by HTTP |
| 10335 | Oracle by Zabbix agent 2 | Oracle by Zabbix agent 2 |
| 10336 | Asterisk by HTTP | Asterisk by HTTP |
| 10343 | Linux by Zabbix agent active | Linux by Zabbix agent active |
| 10351 | Windows by Zabbix agent active | Windows by Zabbix agent active |
| 10353 | Ceph by Zabbix agent 2 | Ceph by Zabbix agent 2 |
| 10355 | Squid by SNMP | Squid by SNMP |
| 10357 | PostgreSQL by Zabbix agent | PostgreSQL by Zabbix agent |
| 10358 | Apache ActiveMQ by JMX | Apache ActiveMQ by JMX |
| 10359 | Aranet Cloud | Aranet Cloud |
| 10360 | Microsoft Exchange Server 2016 by Zabbix agent | Microsoft Exchange Server 2016 by Zabbix agent |
| 10361 | Microsoft Exchange Server 2016 by Zabbix agent active | Microsoft Exchange Server 2016 by Zabbix agent active |
| 10362 | GitLab by HTTP | GitLab by HTTP |
| 10363 | Hadoop by HTTP | Hadoop by HTTP |
| 10364 | Apache Kafka by JMX | Apache Kafka by JMX |
| 10365 | HashiCorp Vault by HTTP | HashiCorp Vault by HTTP |
| 10366 | VMware FQDN | VMware FQDN |
| 10369 | Zookeeper by HTTP | Zookeeper by HTTP |
| 10370 | Apache Cassandra by JMX | Apache Cassandra by JMX |
| 10371 | Morningstar ProStar MPPT by SNMP | Morningstar ProStar MPPT by SNMP |
| 10372 | Morningstar ProStar PWM by SNMP | Morningstar ProStar PWM by SNMP |
| 10373 | Morningstar SunSaver MPPT by SNMP | Morningstar SunSaver MPPT by SNMP |
| 10374 | Morningstar SureSine by SNMP | Morningstar SureSine by SNMP |
| 10375 | Morningstar TriStar MPPT 600V by SNMP | Morningstar TriStar MPPT 600V by SNMP |
| 10376 | Morningstar TriStar MPPT by SNMP | Morningstar TriStar MPPT by SNMP |
| 10377 | Morningstar TriStar PWM by SNMP | Morningstar TriStar PWM by SNMP |
| 10378 | NetApp FAS3220 by SNMP | NetApp FAS3220 by SNMP |
| 10379 | Jenkins by HTTP | Jenkins by HTTP |
| 10380 | Hikvision camera by HTTP | Hikvision camera by HTTP |
| 10381 | Ignite by JMX | Ignite by JMX |
| 10382 | Microsoft SharePoint by HTTP | Microsoft SharePoint by HTTP |
| 10385 | Huawei OceanStor 5300 V5 by SNMP | Huawei OceanStor 5300 V5 by SNMP |
| 10386 | MongoDB node by Zabbix agent 2 | MongoDB node by Zabbix agent 2 |
| 10387 | MongoDB cluster by Zabbix agent 2 | MongoDB cluster by Zabbix agent 2 |
| 10390 | Cisco Catalyst 3750V2-24FS by SNMP | Cisco Catalyst 3750V2-24FS by SNMP |
| 10391 | Cisco Catalyst 3750V2-24PS by SNMP | Cisco Catalyst 3750V2-24PS by SNMP |
| 10392 | Cisco Catalyst 3750V2-24TS by SNMP | Cisco Catalyst 3750V2-24TS by SNMP |
| 10393 | Cisco Catalyst 3750V2-48PS by SNMP | Cisco Catalyst 3750V2-48PS by SNMP |
| 10394 | Cisco Catalyst 3750V2-48TS by SNMP | Cisco Catalyst 3750V2-48TS by SNMP |
| 10395 | APC UPS by SNMP | APC UPS by SNMP |
| 10396 | NetApp AFF A700 by HTTP | NetApp AFF A700 by HTTP |
| 10397 | TiDB PD by HTTP | TiDB PD by HTTP |
| 10398 | TiDB by HTTP | TiDB by HTTP |
| 10399 | TiDB TiKV by HTTP | TiDB TiKV by HTTP |
| 10400 | APC UPS Galaxy 3500 by SNMP | APC UPS Galaxy 3500 by SNMP |
| 10401 | APC Smart-UPS 2200 RM by SNMP | APC Smart-UPS 2200 RM by SNMP |
| 10402 | APC Smart-UPS 3000 XLM by SNMP | APC Smart-UPS 3000 XLM by SNMP |
| 10403 | APC Smart-UPS RT 1000 RM XL by SNMP | APC Smart-UPS RT 1000 RM XL by SNMP |
| 10404 | APC Smart-UPS RT 1000 XL by SNMP | APC Smart-UPS RT 1000 XL by SNMP |
| 10406 | APC Smart-UPS SRT 8000 by SNMP | APC Smart-UPS SRT 8000 by SNMP |
| 10407 | APC UPS Symmetra LX by SNMP | APC UPS Symmetra LX by SNMP |
| 10408 | APC UPS Symmetra RM by SNMP | APC UPS Symmetra RM by SNMP |
| 10409 | APC UPS Symmetra RX by SNMP | APC UPS Symmetra RX by SNMP |
| 10410 | WildFly Domain by JMX | WildFly Domain by JMX |
| 10411 | WildFly Server by JMX | WildFly Server by JMX |
| 10412 | APC Smart-UPS SRT 5000 by SNMP | APC Smart-UPS SRT 5000 by SNMP |
| 10413 | Website certificate by Zabbix agent 2 | Website certificate by Zabbix agent 2 |
| 10414 | Cloudflare by HTTP | Cloudflare by HTTP |
| 10415 | NGINX Plus by HTTP | NGINX Plus by HTTP |
| 10416 | Systemd by Zabbix agent 2 | Systemd by Zabbix agent 2 |
| 10417 | GridGain by JMX | GridGain by JMX |
| 10418 | Cisco ASAv by SNMP | Cisco ASAv by SNMP |
| 10419 | F5 Big-IP by SNMP | F5 Big-IP by SNMP |
| 10420 | ZYXEL AAM1212-51 IES-612 by SNMP | ZYXEL AAM1212-51 IES-612 by SNMP |
| 10421 | ZYXEL ES3500-8PD by SNMP | ZYXEL ES3500-8PD by SNMP |
| 10422 | ZYXEL GS-4012F by SNMP | ZYXEL GS-4012F by SNMP |
| 10423 | ZYXEL IES-500x by SNMP | ZYXEL IES-500x by SNMP |
| 10424 | ZYXEL IES-6000 by SNMP | ZYXEL IES-6000 by SNMP |
| 10425 | ZYXEL IES1248-51 by SNMP | ZYXEL IES1248-51 by SNMP |
| 10426 | ZYXEL MES-3528 by SNMP | ZYXEL MES-3528 by SNMP |
| 10427 | ZYXEL MES3500-10 by SNMP | ZYXEL MES3500-10 by SNMP |
| 10428 | ZYXEL MES3500-24 by SNMP | ZYXEL MES3500-24 by SNMP |
| 10429 | ZYXEL MGS-3712 by SNMP | ZYXEL MGS-3712 by SNMP |
| 10430 | ZYXEL MGS-3712F by SNMP | ZYXEL MGS-3712F by SNMP |
| 10431 | ZYXEL MES3500-24S by SNMP | ZYXEL MES3500-24S by SNMP |
| 10432 | ZYXEL MGS3520-28x by SNMP | ZYXEL MGS3520-28x by SNMP |
| 10433 | ZYXEL XGS-4728F by SNMP | ZYXEL XGS-4728F by SNMP |
| 10434 | Cisco UCS Manager by SNMP | Cisco UCS Manager by SNMP |
| 10435 | DELL PowerEdge R720 by HTTP | DELL PowerEdge R720 by HTTP |
| 10436 | DELL PowerEdge R720 by SNMP | DELL PowerEdge R720 by SNMP |
| 10437 | DELL PowerEdge R740 by HTTP | DELL PowerEdge R740 by HTTP |
| 10438 | DELL PowerEdge R740 by SNMP | DELL PowerEdge R740 by SNMP |
| 10439 | DELL PowerEdge R820 by HTTP | DELL PowerEdge R820 by HTTP |
| 10440 | DELL PowerEdge R820 by SNMP | DELL PowerEdge R820 by SNMP |
| 10441 | DELL PowerEdge R840 by HTTP | DELL PowerEdge R840 by HTTP |
| 10442 | DELL PowerEdge R840 by SNMP | DELL PowerEdge R840 by SNMP |
| 10443 | HPE ProLiant BL460 by SNMP | HPE ProLiant BL460 by SNMP |
| 10444 | HPE ProLiant BL920 by SNMP | HPE ProLiant BL920 by SNMP |
| 10445 | HPE ProLiant DL360 by SNMP | HPE ProLiant DL360 by SNMP |
| 10446 | HPE ProLiant DL380 by SNMP | HPE ProLiant DL380 by SNMP |
| 10447 | Travis CI by HTTP | Travis CI by HTTP |
| 10448 | InfluxDB by HTTP | InfluxDB by HTTP |
| 10449 | MikroTik CCR1009-7G-1C-1SPC by SNMP | MikroTik CCR1009-7G-1C-1S+PC by SNMP |
| 10450 | MikroTik CCR1009-7G-1C-1S by SNMP | MikroTik CCR1009-7G-1C-1S+ by SNMP |
| 10451 | MikroTik CCR1009-7G-1C-PC by SNMP | MikroTik CCR1009-7G-1C-PC by SNMP |
| 10452 | MikroTik CCR1016-12G by SNMP | MikroTik CCR1016-12G by SNMP |
| 10453 | MikroTik CCR1016-12S-1S by SNMP | MikroTik CCR1016-12S-1S+ by SNMP |
| 10454 | MikroTik CCR1036-12G-4S-EM by SNMP | MikroTik CCR1036-12G-4S-EM by SNMP |
| 10455 | MikroTik CCR1036-12G-4S by SNMP | MikroTik CCR1036-12G-4S by SNMP |
| 10456 | MikroTik CCR1036-8G-2SEM by SNMP | MikroTik CCR1036-8G-2S+EM by SNMP |
| 10457 | MikroTik CCR1036-8G-2S by SNMP | MikroTik CCR1036-8G-2S+ by SNMP |
| 10458 | MikroTik CCR1072-1G-8S by SNMP | MikroTik CCR1072-1G-8S+ by SNMP |
| 10459 | MikroTik CCR2004-16G-2S by SNMP | MikroTik CCR2004-16G-2S+ by SNMP |
| 10460 | MikroTik CCR2004-1G-12S2XS by SNMP | MikroTik CCR2004-1G-12S+2XS by SNMP |
| 10461 | MikroTik CRS106-1C-5S by SNMP | MikroTik CRS106-1C-5S by SNMP |
| 10462 | MikroTik CRS109-8G-1S-2HnD-IN by SNMP | MikroTik CRS109-8G-1S-2HnD-IN by SNMP |
| 10463 | MikroTik CRS112-8G-4S-IN by SNMP | MikroTik CRS112-8G-4S-IN by SNMP |
| 10464 | MikroTik CRS112-8P-4S-IN by SNMP | MikroTik CRS112-8P-4S-IN by SNMP |
| 10465 | MikroTik CRS125-24G-1S-2HnD-IN by SNMP | MikroTik CRS125-24G-1S-2HnD-IN by SNMP |
| 10466 | MikroTik CRS212-1G-10S-1SIN by SNMP | MikroTik CRS212-1G-10S-1S+IN by SNMP |
| 10467 | MikroTik CRS305-1G-4SIN by SNMP | MikroTik CRS305-1G-4S+IN by SNMP |
| 10468 | MikroTik CRS309-1G-8SIN by SNMP | MikroTik CRS309-1G-8S+IN by SNMP |
| 10469 | MikroTik CRS312-4C8XG-RM by SNMP | MikroTik CRS312-4C+8XG-RM by SNMP |
| 10470 | MikroTik CRS317-1G-16SRM by SNMP | MikroTik CRS317-1G-16S+RM by SNMP |
| 10471 | MikroTik CRS326-24G-2SIN by SNMP | MikroTik CRS326-24G-2S+IN by SNMP |
| 10472 | MikroTik CRS326-24G-2SRM by SNMP | MikroTik CRS326-24G-2S+RM by SNMP |
| 10473 | MikroTik CRS326-24S2QRM by SNMP | MikroTik CRS326-24S+2Q+RM by SNMP |
| 10474 | MikroTik CRS328-24P-4SRM by SNMP | MikroTik CRS328-24P-4S+RM by SNMP |
| 10475 | MikroTik CRS328-4C-20S-4SRM by SNMP | MikroTik CRS328-4C-20S-4S+RM by SNMP |
| 10476 | MikroTik CRS354-48G-4S2QRM by SNMP | MikroTik CRS354-48G-4S+2Q+RM by SNMP |
| 10477 | MikroTik CRS354-48P-4S2QRM by SNMP | MikroTik CRS354-48P-4S+2Q+RM by SNMP |
| 10478 | MikroTik CSS326-24G-2SRM by SNMP | MikroTik CSS326-24G-2S+RM by SNMP |
| 10479 | MikroTik CSS610-8G-2SIN by SNMP | MikroTik CSS610-8G-2S+IN by SNMP |
| 10480 | MikroTik FiberBox by SNMP | MikroTik FiberBox by SNMP |
| 10481 | MikroTik PowerBox Pro by SNMP | MikroTik PowerBox Pro by SNMP |
| 10482 | MikroTik PowerBox by SNMP | MikroTik PowerBox by SNMP |
| 10483 | MikroTik RB1100AHx4 Dude Edition by SNMP | MikroTik RB1100AHx4 Dude Edition by SNMP |
| 10484 | MikroTik RB1100AHx4 by SNMP | MikroTik RB1100AHx4 by SNMP |
| 10485 | MikroTik RB2011UiAS-IN by SNMP | MikroTik RB2011UiAS-IN by SNMP |
| 10486 | MikroTik RB2011UiAS-RM by SNMP | MikroTik RB2011UiAS-RM by SNMP |
| 10487 | MikroTik RB2011iL-IN by SNMP | MikroTik RB2011iL-IN by SNMP |
| 10488 | MikroTik RB2011iL-RM by SNMP | MikroTik RB2011iL-RM by SNMP |
| 10489 | MikroTik RB2011iLS-IN by SNMP | MikroTik RB2011iLS-IN by SNMP |
| 10490 | MikroTik RB260GSP by SNMP | MikroTik RB260GSP by SNMP |
| 10491 | MikroTik RB260GS by SNMP | MikroTik RB260GS by SNMP |
| 10492 | MikroTik RB3011UiAS-RM by SNMP | MikroTik RB3011UiAS-RM by SNMP |
| 10493 | MikroTik RB4011iGSRM by SNMP | MikroTik RB4011iGS+RM by SNMP |
| 10494 | MikroTik RB5009UGSIN by SNMP | MikroTik RB5009UG+S+IN by SNMP |
| 10495 | MikroTik hEX PoE lite by SNMP | MikroTik hEX PoE lite by SNMP |
| 10496 | MikroTik hEX PoE by SNMP | MikroTik hEX PoE by SNMP |
| 10497 | MikroTik hEX S by SNMP | MikroTik hEX S by SNMP |
| 10498 | MikroTik hEX lite by SNMP | MikroTik hEX lite by SNMP |
| 10499 | MikroTik hEX by SNMP | MikroTik hEX by SNMP |
| 10500 | MikroTik netPower 15FR by SNMP | MikroTik netPower 15FR by SNMP |
| 10501 | MikroTik netPower 16P by SNMP | MikroTik netPower 16P by SNMP |
| 10502 | MikroTik netPower Lite 7R by SNMP | MikroTik netPower Lite 7R by SNMP |
| 10503 | VeloCloud SD-WAN by HTTP | VeloCloud SD-WAN by HTTP |
| 10504 | Kubernetes API server by HTTP | Kubernetes API server by HTTP |
| 10505 | Kubernetes Controller manager by HTTP | Kubernetes Controller manager by HTTP |
| 10506 | Kubernetes Kubelet by HTTP | Kubernetes Kubelet by HTTP |
| 10507 | Kubernetes nodes by HTTP | Kubernetes nodes by HTTP |
| 10509 | Kubernetes Scheduler by HTTP | Kubernetes Scheduler by HTTP |
| 10510 | Kubernetes cluster state by HTTP | Kubernetes cluster state by HTTP |
| 10515 | PFSense by SNMP | PFSense by SNMP |
| 10516 | OpenWeatherMap by HTTP | OpenWeatherMap by HTTP |
| 10517 | Proxmox VE by HTTP | Proxmox VE by HTTP |
| 10518 | TrueNAS CORE by SNMP | TrueNAS CORE by SNMP |
| 10519 | CockroachDB by HTTP | CockroachDB by HTTP |
| 10520 | Envoy Proxy by HTTP | Envoy Proxy by HTTP |
| 10521 | HashiCorp Consul Node by HTTP | HashiCorp Consul Node by HTTP |
| 10522 | HashiCorp Consul Cluster by HTTP | HashiCorp Consul Cluster by HTTP |
| 10524 | HPE MSA 2040 Storage by HTTP | HPE MSA 2040 Storage by HTTP |
| 10525 | HPE MSA 2060 Storage by HTTP | HPE MSA 2060 Storage by HTTP |
| 10526 | HPE Primera by HTTP | HPE Primera by HTTP |
| 10527 | AWS EC2 by HTTP | AWS EC2 by HTTP |
| 10528 | OPNsense by SNMP | OPNsense by SNMP |
| 10529 | AWS RDS instance by HTTP | AWS RDS instance by HTTP |
| 10530 | AWS S3 bucket by HTTP | AWS S3 bucket by HTTP |
| 10531 | Azure by HTTP | Azure by HTTP |
| 10532 | Azure Virtual Machine by HTTP | Azure Virtual Machine by HTTP |
| 10534 | HPE Synergy by HTTP | HPE Synergy by HTTP |
| 10535 | AWS by HTTP | AWS by HTTP |
| 10539 | Azure MySQL Flexible Server by HTTP | Azure MySQL Flexible Server by HTTP |
| 10540 | Azure MySQL Single Server by HTTP | Azure MySQL Single Server by HTTP |
| 10543 | Azure PostgreSQL Flexible Server by HTTP | Azure PostgreSQL Flexible Server by HTTP |
| 10544 | Azure PostgreSQL Single Server by HTTP | Azure PostgreSQL Single Server by HTTP |
| 10546 | Cisco Meraki dashboard by HTTP | Cisco Meraki dashboard by HTTP |
| 10547 | Cisco Meraki device by HTTP | Cisco Meraki device by HTTP |
| 10548 | Cisco Meraki organization by HTTP | Cisco Meraki organization by HTTP |
| 10551 | Cisco Nexus 9000 Series by SNMP | Cisco Nexus 9000 Series by SNMP |
| 10552 | Control-M enterprise manager by HTTP | Control-M enterprise manager by HTTP |
| 10553 | Control-M server by HTTP | Control-M server by HTTP |
| 10555 | Veeam Backup and Replication by HTTP | Veeam Backup and Replication by HTTP |
| 10556 | Veeam Backup Enterprise Manager by HTTP | Veeam Backup Enterprise Manager by HTTP |
| 10557 | Azure Microsoft SQL Database by HTTP | Azure Microsoft SQL Database by HTTP |
| 10558 | Azure Microsoft SQL Serverless Database by HTTP | Azure Microsoft SQL Serverless Database by HTTP |
| 10560 | OS processes by Zabbix agent | OS processes by Zabbix agent |
| 10561 | Zabbix agent | Zabbix agent |
| 10562 | Zabbix agent active | Zabbix agent active |
| 10563 | Generic by SNMP | Generic by SNMP |
| 10564 | ICMP Ping | ICMP Ping |
| 10565 | SMART by Zabbix agent 2 | SMART by Zabbix agent 2 |
| 10566 | SMART by Zabbix agent 2 active | SMART by Zabbix agent 2 active |
| 10568 | Azure Cosmos DB for MongoDB by HTTP | Azure Cosmos DB for MongoDB by HTTP |
| 10570 | GCP by HTTP | GCP by HTTP |
| 10571 | GCP Cloud SQL MSSQL by HTTP | GCP Cloud SQL MSSQL by HTTP |
| 10572 | GCP Cloud SQL MSSQL Replica by HTTP | GCP Cloud SQL MSSQL Replica by HTTP |
| 10573 | GCP Cloud SQL MySQL by HTTP | GCP Cloud SQL MySQL by HTTP |
| 10574 | GCP Cloud SQL MySQL Replica by HTTP | GCP Cloud SQL MySQL Replica by HTTP |
| 10575 | GCP Cloud SQL PostgreSQL by HTTP | GCP Cloud SQL PostgreSQL by HTTP |
| 10576 | GCP Cloud SQL PostgreSQL Replica by HTTP | GCP Cloud SQL PostgreSQL Replica by HTTP |
| 10577 | GCP Compute Engine Instance by HTTP | GCP Compute Engine Instance by HTTP |
| 10582 | AWS Cost Explorer by HTTP | AWS Cost Explorer by HTTP |
| 10583 | AWS ECS Cluster by HTTP | AWS ECS Cluster by HTTP |
| 10584 | AWS ECS Serverless Cluster by HTTP | AWS ECS Serverless Cluster by HTTP |
| 10586 | OpenStack by HTTP | OpenStack by HTTP |
| 10587 | OpenStack Nova by HTTP | OpenStack Nova by HTTP |
| 10589 | PostgreSQL by ODBC | PostgreSQL by ODBC |
| 10590 | Cisco SD-WAN by HTTP | Cisco SD-WAN by HTTP |
| 10591 | Cisco SD-WAN device by HTTP | Cisco SD-WAN device by HTTP |
| 10593 | Mantis BT by HTTP | Mantis BT by HTTP |
| 10594 | HashiCorp Nomad by HTTP | HashiCorp Nomad by HTTP |
| 10595 | HashiCorp Nomad Client by HTTP | HashiCorp Nomad Client by HTTP |
| 10596 | HashiCorp Nomad Server by HTTP | HashiCorp Nomad Server by HTTP |
| 10599 | Acronis Cyber Protect Cloud by HTTP | Acronis Cyber Protect Cloud by HTTP |
| 10600 | Acronis Cyber Protect Cloud MSP by HTTP | Acronis Cyber Protect Cloud MSP by HTTP |
| 10602 | Nextcloud by HTTP | Nextcloud by HTTP |
| 10603 | FortiGate by HTTP | FortiGate by HTTP |
| 10604 | FortiGate by SNMP | FortiGate by SNMP |
| 10605 | HPE iLO by HTTP | HPE iLO by HTTP |
| 10606 | Azure Cost Management by HTTP | Azure Cost Management by HTTP |
| 10607 | AWS ELB Application Load Balancer by HTTP | AWS ELB Application Load Balancer by HTTP |
| 10609 | MSSQL by Zabbix agent 2 | MSSQL by Zabbix agent 2 |
| 10610 | YugabyteDB by HTTP | YugabyteDB by HTTP |
| 10611 | YugabyteDB Cluster by HTTP | YugabyteDB Cluster by HTTP |
| 10613 | Check Point Next Generation Firewall by SNMP | Check Point Next Generation Firewall by SNMP |
| 10614 | Oracle Cloud Autonomous Database by HTTP | Oracle Cloud Autonomous Database by HTTP |
| 10615 | Oracle Cloud Block Volume by HTTP | Oracle Cloud Block Volume by HTTP |
| 10616 | Oracle Cloud Boot Volume by HTTP | Oracle Cloud Boot Volume by HTTP |
| 10617 | Oracle Cloud by HTTP | Oracle Cloud by HTTP |
| 10618 | Oracle Cloud Compute by HTTP | Oracle Cloud Compute by HTTP |
| 10619 | Oracle Cloud Networking by HTTP | Oracle Cloud Networking by HTTP |
| 10620 | Oracle Cloud Object Storage by HTTP | Oracle Cloud Object Storage by HTTP |
| 10627 | AWS ELB Network Load Balancer by HTTP | AWS ELB Network Load Balancer by HTTP |
| 10628 | Website by Browser | Website by Browser |
| 10629 | Jira Data Center by JMX | Jira Data Center by JMX |
| 10630 | Azure VM Scale Set by HTTP | Azure VM Scale Set by HTTP |
| 10632 | AWS Lambda by HTTP | AWS Lambda by HTTP |
| 10634 | GitHub repository by HTTP | GitHub repository by HTTP |
| 10635 | Microsoft 365 reports by HTTP | Microsoft 365 reports by HTTP |
| 10636 | Huawei OceanStor Dorado by SNMP | Huawei OceanStor Dorado by SNMP |
| 10637 | Apache by Zabbix agent active | Apache by Zabbix agent active |
| 10638 | Website certificate by Zabbix agent 2 active | Website certificate by Zabbix agent 2 active |
| 10639 | Nginx by Zabbix agent active | Nginx by Zabbix agent active |
| 10640 | Nutanix Cluster Prism Element by HTTP | Nutanix Cluster Prism Element by HTTP |
| 10641 | Nutanix Host Prism Element by HTTP | Nutanix Host Prism Element by HTTP |
| 10642 | Nutanix Prism Element by HTTP | Nutanix Prism Element by HTTP |
| 10645 | PHP-FPM by Zabbix agent active | PHP-FPM by Zabbix agent active |
| 10646 | MySQL by Zabbix agent 2 active | MySQL by Zabbix agent 2 active |
| 10647 | MySQL by Zabbix agent active | MySQL by Zabbix agent active |
| 10648 | PostgreSQL by Zabbix agent 2 active | PostgreSQL by Zabbix agent 2 active |
| 10649 | PostgreSQL by Zabbix agent active | PostgreSQL by Zabbix agent active |
| 10650 | Juniper MX by SNMP | Juniper MX by SNMP |
| 10651 | Azure SQL Managed Instance by HTTP | Azure SQL Managed Instance by HTTP |
| 10653 | Palo Alto PA-440 by HTTP | Palo Alto PA-440 by HTTP |
| 10654 | DELL PowerEdge R660 by HTTP | DELL PowerEdge R660 by HTTP |
| 10655 | DELL PowerEdge R660 by SNMP | DELL PowerEdge R660 by SNMP |
| 10656 | DELL PowerEdge R750 by HTTP | DELL PowerEdge R750 by HTTP |
| 10657 | DELL PowerEdge R750 by SNMP | DELL PowerEdge R750 by SNMP |
| 10658 | Zabbix proxy health by Zabbix agent | Zabbix proxy health by Zabbix agent |
| 10659 | Zabbix proxy health by Zabbix agent active | Zabbix proxy health by Zabbix agent active |
| 10660 | Zabbix server health by Zabbix agent | Zabbix server health by Zabbix agent |
| 10661 | Zabbix server health by Zabbix agent active | Zabbix server health by Zabbix agent active |
| 10662 | Azure Microsoft SQL DTU Database by HTTP | Azure Microsoft SQL DTU Database by HTTP |
| 10663 | Pure Storage FlashArray v1 by HTTP | Pure Storage FlashArray v1 by HTTP |
| 10664 | Pure Storage FlashArray v2 by HTTP | Pure Storage FlashArray v2 by HTTP |
| 10665 | Azure Backup Jobs by HTTP | Azure Backup Jobs by HTTP |
| 10667 | Cisco Secure Firewall Threat Defense by HTTP | Cisco Secure Firewall Threat Defense by HTTP |
| 10668 | AWS Backup Vault by HTTP | AWS Backup Vault by HTTP |
| 10670 | Aruba CX 8300s by SNMP | Aruba CX 8300s by SNMP |
| 10671 | Ciena 3906 by SNMP | Ciena 3906 by SNMP |
| 10672 | Vyatta Virtual Router by SNMP | Vyatta Virtual Router by SNMP |
| 10673 | Stormshield SNS by SNMP | Stormshield SNS by SNMP |
| 10674 | Ribbon SBC Edge by HTTP | Ribbon SBC Edge by HTTP |
| 10675 | Ribbon SBC SWe CE by HTTP | Ribbon SBC SWe CE by HTTP |
| 10676 | Ribbon SBC SWe Core by HTTP | Ribbon SBC SWe Core by HTTP |
| 10678 | VeloCloud SD-WAN Edge by HTTP | VeloCloud SD-WAN Edge by HTTP |
+--------+-------------------------------------------------------+-------------------------------------------------------+
354 rows in set (0.00 sec)
mysql> SHOW FULL COLUMNS FROM hosts;
+--------------------+-----------------+-------------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+--------------------+-----------------+-------------+------+-----+---------+-------+---------------------------------+---------+
| hostid | bigint unsigned | NULL | NO | PRI | NULL | | select,insert,update,references | |
| proxyid | bigint unsigned | NULL | YES | MUL | NULL | | select,insert,update,references | |
| host | varchar(128) | utf8mb4_bin | NO | MUL | | | select,insert,update,references | |
| status | int | NULL | NO | MUL | 0 | | select,insert,update,references | |
| ipmi_authtype | int | NULL | NO | | -1 | | select,insert,update,references | |
| ipmi_privilege | int | NULL | NO | | 2 | | select,insert,update,references | |
| ipmi_username | varchar(16) | utf8mb4_bin | NO | | | | select,insert,update,references | |
| ipmi_password | varchar(20) | utf8mb4_bin | NO | | | | select,insert,update,references | |
| maintenanceid | bigint unsigned | NULL | YES | MUL | NULL | | select,insert,update,references | |
| maintenance_status | int | NULL | NO | | 0 | | select,insert,update,references | |
| maintenance_type | int | NULL | NO | | 0 | | select,insert,update,references | |
| maintenance_from | int | NULL | NO | | 0 | | select,insert,update,references | |
| name | varchar(128) | utf8mb4_bin | NO | MUL | | | select,insert,update,references | |
| flags | int | NULL | NO | | 0 | | select,insert,update,references | |
| templateid | bigint unsigned | NULL | YES | MUL | NULL | | select,insert,update,references | |
| description | text | utf8mb4_bin | NO | | NULL | | select,insert,update,references | |
| tls_connect | int | NULL | NO | | 1 | | select,insert,update,references | |
| tls_accept | int | NULL | NO | | 1 | | select,insert,update,references | |
| tls_issuer | varchar(1024) | utf8mb4_bin | NO | | | | select,insert,update,references | |
| tls_subject | varchar(1024) | utf8mb4_bin | NO | | | | select,insert,update,references | |
| tls_psk_identity | varchar(128) | utf8mb4_bin | NO | | | | select,insert,update,references | |
| tls_psk | varchar(512) | utf8mb4_bin | NO | | | | select,insert,update,references | |
| discover | int | NULL | NO | | 0 | | select,insert,update,references | |
| custom_interfaces | int | NULL | NO | | 0 | | select,insert,update,references | |
| uuid | varchar(32) | utf8mb4_bin | NO | MUL | | | select,insert,update,references | |
| name_upper | varchar(128) | utf8mb4_bin | NO | MUL | | | select,insert,update,references | |
| vendor_name | varchar(64) | utf8mb4_bin | NO | | | | select,insert,update,references | |
| vendor_version | varchar(32) | utf8mb4_bin | NO | | | | select,insert,update,references | |
| proxy_groupid | bigint unsigned | NULL | YES | MUL | NULL | | select,insert,update,references | |
| monitored_by | int | NULL | NO | | 0 | | select,insert,update,references | |
+--------------------+-----------------+-------------+------+-----+---------+-------+---------------------------------+---------+
30 rows in set (0.02 sec)
⇧ とりあえず、「テーブル」の「列（カラム）」の説明が無い当たり、「設計」が破綻しているとしか思えない...
「ER図」とかも無いですしな...
「Zabbix」は、悉く「SQLアンチパターン 第2版 ―データベースプログラミングで陥りがちな失敗とその対策（著：Bill Karwin）」で駄目だとされる事柄を盛り込んでいるように思えてならない...
まぁ、
Zabbix はアレクセイ・ウラジシェフ(Alexei Vladishev)によって作られた、ネットワーク管理ソフトウェアである。様々なネットワークサービス、サーバ 、その他のネットワークハードウェアのステータスを監視・追跡できる。現在はウラジシェフが設立したZabbix社によって開発が継続されている。
⇧ 上記が正しいとすると、元々は個人で開発・メンテナンスされていたようなので、不特定多数の人間が理解できるような「設計」になっていないということなんでしょうね...
「Zabbix」の「情報」は、「ファインダビリティ（Findability）」の欠片も無く、カオス過ぎるのよな...
一般公開されたのが、2001年らしいので、25年は経とうしているわけで、枯れた技術と言えるのだと思われるのだが、「情報」が錯綜し過ぎていて地獄でしかない...
そもそも、公式の「ドキュメント」で「Zabbix」の環境構築に関する正確な「情報」が公開されていないものな...
一次情報が全く役に立たない...
今日も今日とて、ストレスが蓄積されるだけの日々ですな...
毎度モヤモヤ感が半端ない…
今回はこのへんで。
