New templates - IPMI, Mikrotik, MSSQL

The article was written based on the report of Maxim Chudinov, Zabbix integrator engineer.

In this article, we will discuss some of the new templates added in Zabbix 5.0.

IPMI

IPMI Zabbix, impi.get, -. IMPI JSON. . - JSONPath.

JSON

, - , . .

. Zabbix 5.0 Overrides, , .

Override

: , . , , . .

, : , . , .

. , . - .

MikroTik

MikroTik .

Net Mikrotik SNMP

WiFi. 71 1 . , object ID. , , .

. SSID, . — . 'running-ap' , . , , .

standalone, SSID, , , , .

. Zabbix , , - , WiFi .

MikroTik . . .

MikroTik

MSSQL

Zabbix , Microsoft SQL Server 2016 Linux Windows . , , :

— , , ,

— ,

— , ,

— ,

— .

, readme- Zabbix.

.

• ODBC Microsoft SQL Server : Driver Server.
• — IP- — , .
• , .

1. odbc.ini

[\]

Driver = ODBC Driver 17 for SQL Server

Server = <IP FQDN>, <TCP >

{\$MSSQL.DSN} = <…>

{\$MSSQL.USER} = <…>

{\$MSSQL.PASSWORD} = <…>

{\$MSSQL.PORT} = 1433

{$MSSQL.INSTANCE} = SQLServer MSSQL$< >

SQL Server .

SQL Server, TCP . SQL Server TCP-.

: DSN, USER (), PASSWORD, PORT INSTANCE. PORT . SQL Server , INSTANCE SQLServer MSSQL\$< >.

— 67 . - db.odbc.get, JSON JSONPath.

dm_os_performance_counter. , «» , — .

() net.tcp.service, , , , {\$MSSQL.PORT}.

LLD, , : , , . , , . — .

DB MSSQL by ODBC

Zabbix .

, Zabbix, , , .

, . .

. Microsoft SQL Zabbix 5.0?

. .

. ODBC- - ? , ?

. , SQL Server . readme- .

. WiFi- UBQUITI?

. . , , , Zabbix .

. Microsoft SQL?

. , TCP- . SQL Server. TCP. ODBC, Zabbix .

. Microsoft SQL?

. , . ZBXNEXT .

. '' (pollers) Microsoft SQL?

. , , .

. , . , ?

. , . , . ZBXNEXT .

, , , . .

. Microsoft SQL - perf_counter[]?

. share.zabbix.com MS SQL. , . , perf_counter[], SQL Server Windows, Unix .