Plugins.MSSQL.Sessions.MSSQLINST1.User=

[baramann]

Hello All,

need some help and hope someone can give me a hint :-)

I have some Windows-Clusters with multiple MSSQL instances installations in each cluster. The goal is, to monitor all of them with only one installation per cluster of the zabbix_agent2 incl. the mssql-plugin.

My actual setup is: i configured in Zabbix a host, set the macro data for the first instance and it works fine and i get all monitoring data.

I saw in the msql.conf that it is possible to configure sessions like
Plugins.MSSQL.Sessions.*.User=

So, can I for example setup some Zabbix Host-Object (One for each database instance) pointing them to one agent2 and then reference the mssql-instance via the configured session in the mssql.conf). Or do I need for each mssql instance one zabbix host-object pointing to a own zabbix-agent?

Used Zabbix: 6.0.35

Thanks!
Bjoern

[cyber]

It should be possible with all those hosts pointing to same agent.

[baramann]

Hi,
pointing from different host to the some agent should be no problem.
But do I get the result back to the correct calling host? In my understanding, the agent will mask the result with the hostname as configured in the zabbix_agent2.conf)? Or is there a way to address different sections in the mssql.conf with different macros on the host?
example:
zabbix host objekt name: host_mssql1 (for MSSQL Instance MSSQL1)
zabbix host objekt name: host_mssql2 (for MSSQL Instance MSSQL2)
zabbix agent hostname: host_mssql1

Can I use "host_mssql2" point to zabbix agent "host_mssql1" to monitor MSSQL2?

Thanks!