Steps to reproduce:

1. Use the Zabbix offical MSSQL ODBC monitoring on a SQL Always on cluster with more than two nodes
2. Discover non-local databases (always on replicated) existing on more than two nodes

Result:

It cannot create all objects since it only uses the AG Group name and Database and not the unique replica_name

The Primary node for my case is OMSQL01N1 so this is the result of the discovery

Expected:
It should create two entries but only one of the rows gets created with the group_name + dbname

 

Fix:

Updated the item prototypes to include the replica_name as follows so they are created unique:

MSSQL AG '{#GROUP_NAME}' Non-Local DB '*

{#REPLICA_NAME}*{#DBNAME}': Get non-local DB states

 

MSSQL AG '{#GROUP_NAME}' Non-Local DB '*{#REPLICA_NAME}

*

{#DBNAME}': Log queue size

 

MSSQL AG '{#GROUP_NAME}' Non-Local DB '{#REPLICA_NAME}
{#DBNAME}

': Redo log queue size