search

MantasTumenas / Zabbix-template-for-Microsoft-SQL-Server

Zabbix templates for Microsoft SQL Server. Features MS SQL performance counters. MS SQL instance Low Level Discovery. MS SQL database Low Level Discovery. MS SQL agent job Low Level Discovery. MS SQL database mirroring monitoring. MS SQL Always On monitoring. MS SQL Log Shipping monitoring. Supported versions Tested on Microsoft SQL Server 2012, 2014 and 2016. It may work with earlier versions, but some items (with missing performance counters) may be unsupported. For the extensive overview on the performance counters difference between MS SQL 2008 and MS SQL 2012 you can read here (https://blog.dbi-services.com/sql-server-2012-new-perfmon-counters/). Tested on Zabbix 3.4.0. It may work with earlier versions, but some items (for example service.info[service,]) may be unsupported. The template was started on Zabbix 2.4.0 but after each new Zabbix version, objects were modified or new things were added.
GNU General Public License v3.0
49 stars 27 forks source link

Issue on mssql express 2019 server 2022 #43

Closed killmasta93 closed 2 years ago

killmasta93 commented 2 years ago

Hi Currently trying to install on server 2022 with mssql but the data is not coming in on zabbix it shows unsupported data key I run the powershell manually and it works with no issue

I placed the scripts in the the zabbix folder

image

image

image

  4976:20220512:060803.271 active check "tier3.instances.mssql.discovery" is not supported: Unsupported item key.
  4976:20220512:060803.272 active check "tier3.sysdatabases.mssql.discovery" is not supported: Unsupported item key.
  4976:20220512:060803.273 active check "tier3.userdatabases.mssql.discovery" is not supported: Unsupported item key.
  4976:20220512:100804.117 active check "tier1.databases.mssql.discovery" is not supported: Unsupported item key.
  4976:20220512:100804.117 active check "tier1.instances.mssql.discovery" is not supported: Unsupported item key.
  4976:20220512:100804.118 active check "tier2.databases.mssql.discovery" is not supported: Unsupported item key.
  4976:20220512:100804.119 active check "tier2.instances.mssql.discovery" is not supported: Unsupported item key.
  4976:20220512:100804.119 active check "tier3.instances.mssql.discovery" is not supported: Unsupported item key.
  4976:20220512:100804.120 active check "tier3.sysdatabases.mssql.discovery" is not supported: Unsupported item key.
  4976:20220512:100804.120 active check "tier3.userdatabases.mssql.discovery" is not supported: Unsupported item key.

Thank you

killmasta93 commented 2 years ago

solved: an issue was with the config of zabbix

MantasTumenas commented 2 years ago

My guess is your issue was with different path for scripts.