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

Variable name fullInstance doent exist #32

Open Fabian1976 opened 4 years ago

Fabian1976 commented 4 years ago

https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/blob/fd95591d5b16c99c8bec8e65d7d36739f4696e05/With%20SQL%20instance%20discovery/Scripts/Discovery.mssql.databasestatus.ps1#L62

It should be $fullInstanceName.

Error message is:

Error executing query on !

And should be:

Error executing query on <INSTANCENAME>!
MantasTumenas commented 4 years ago

You are right. The error handling is not polished as it could be. I will look into it. Will check all scripts.