[ZBX-26170] LDD Filter for MSSQL by ODBC template not applied Created: 2025 Mar 14  Updated: 2025 Mar 14

Status: Open
Project: ZABBIX BUGS AND ISSUES
Component/s: Templates (T)
Affects Version/s: 6.0.39, 7.0.10
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Aurélien Py Assignee: Zabbix Support Team
Resolution: Unresolved Votes: 0
Labels: database, lld, macros
Remaining Estimate: 8h
Time Spent: Not Specified
Original Estimate: 8h
Environment:

Monitoring MSSQL by ODBC


Attachments: PNG File image-2025-03-14-08-23-01-289.png    

 Description   

Hello,

 

I'm using the template MSSQL by ODBC. The filter in the Database does not works as exepted:

{$MSSQL.DBNAME.NOT_MATCHES} This macro is used in database discovery. It can be overridden on the host or linked template level. master|tempdb|model|msdb

 

 I add my database name in the string at host level : master|tempdb|model|msdb|TESTDATABASE

After that I execute again the item "Get performance counters" and the discovery  "Database discovery" but my database TESTDATABASE is still monitored.

Delete lost ressources option is immediately  

If I reload the template on my host with this value in my filter database is not discovered so I know that filter works BUT why the filter is not applied directly ? Do you have any idea ?

 

Kind regards,

 


Generated at Wed Apr 02 18:16:12 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.