MSSQL SQL Agent 2 - is it possible to monitor 2+ ports?

[mike_a]

Hi all,

We are on Zabbix 7.0 and am using the "MSSQL by Zabbix agent 2" template to monitor our SQL Server instances. Currently, we have the template to monitor our mssql servers where the tcp port is 1433, and we have a second copy of the template, but we monitor a different port. I wanted to see if it was possible to use 1 template, but check against 1 or more different ports? Not sure if it could be a change made to the {$MSSQL.PORT} macro or URI. Ideally, we would use 1 template to monitor all of our sql server instead of using a template per MSSQL port to avoid making changes to multiple templates.

Thanks in advance

[mike_a]

Following up. Managed to find a solution. Instead of using the template level MSSQL.URI, I created a macro at for the host and put in the URI there.