Hi,
My unixODBC connection on zabbix server works fine and was able to get single db.odbc.select values with Database Discovery Item.
The problem is that I can not get multiple values/columns from SQL select statement.
This is what I did:
1. Created new Template with Discovery Rule:
Type - Database Monitor
Key - db.odbc.discovery[description,MSSQL]
SQL query - select TOP 2 name, version FROM master.dbo.sysdatabases
Macro - {#NAME} matches NAME
2. Item Prototype in new Template:
Type - Database Monitor
Key - db.odbc.select[{#NAME},MSSQL]
SQL query - select TOP 2 name, version FROM master.dbo.sysdatabases
I don't see any error in Status column for particular Host, but also can not get any data in Latest Data section.
How to display simple MSSQL select in Zabbix?
Many thanks
My unixODBC connection on zabbix server works fine and was able to get single db.odbc.select values with Database Discovery Item.
The problem is that I can not get multiple values/columns from SQL select statement.
This is what I did:
1. Created new Template with Discovery Rule:
Type - Database Monitor
Key - db.odbc.discovery[description,MSSQL]
SQL query - select TOP 2 name, version FROM master.dbo.sysdatabases
Macro - {#NAME} matches NAME
2. Item Prototype in new Template:
Type - Database Monitor
Key - db.odbc.select[{#NAME},MSSQL]
SQL query - select TOP 2 name, version FROM master.dbo.sysdatabases
I don't see any error in Status column for particular Host, but also can not get any data in Latest Data section.
How to display simple MSSQL select in Zabbix?
Many thanks