-
Problem report
-
Resolution: Fixed
-
Major
-
None
-
Zabbix 5.4.11
-
Sprint 89 (Jun 2022)
-
0.5
The template 'Template - Database Microsoft SQLServer General ODBC' discovery rule 'Job discovery' filter 'Type of calculation' should be 'AND' rather than 'And/Or'.
Otherwise it will discovery any Jobnames that match the the included OR excluded macros {$MSSQL.JOB.MATCHES} OR {$MSSQL.JOB.NOT_MATCHES}.
As a result of the 'Type of calculation' any job that does not match {$MSSQL.JOB.NOT_MATCHES} will be discovered regardless of matching {$MSSQL.JOB.MATCHES}.
This aligns with the filter logic for 'Database discovery'.
Also just a note in general for any templates using Regular expressions for filtering specific fields; to ensure critical fields that are used in item/trigger/graph prototypes are not 'Blank' it probably should be '.' or '^.$' otherwise you may end up with a whole bunch of blank information where ever you use the discovery macro with '.*'.