How to use the Template App MS SQL Instance Discovery

[studero]

Hi,

My Zabbix server run on RedHat 9 with the last version of Zabbix.

I want to monitor MS-SQL Server with multi instance. I have tried to use the community-templates/Databases/Microsoft_SQL_Server/template_app_ms_sql_instance_discovery_(lld)/6.0 at main · zabbix/community-templates (github.com)

But I have a problem when run the Discover rules. I have the following error message "Unsupported item key" with the Key "windowssqlinstances.discovery"

From my Zabbix server, I run the following command with the same result:
[root@svx-mon-02t ~]# zabbix_get -s svw-mssql-01t -k windowssqlinstances.discovery
ZBX_NOTSUPPORTED: Unsupported item key.
[root@svx-mon-02t ~]#

I thinks that I need or there are an error into the Template.

Thanks for your help
Regards
Olivier

[SanMonitor]

Hi,

My Zabbix server run on RedHat 9 with the last version of Zabbix.

I want to monitor MS-SQL Server with multi instance. I have tried to use the community-templates/Databases/Microsoft_SQL_Server/template_app_ms_sql_instance_discovery_(lld)/6.0 at main · zabbix/community-templates (github.com)

But I have a problem when run the Discover rules. I have the following error message "Unsupported item key" with the Key "windowssqlinstances.discovery"

From my Zabbix server, I run the following command with the same result:
[root@svx-mon-02t ~]# zabbix_get -s svw-mssql-01t -k windowssqlinstances.discovery
ZBX_NOTSUPPORTED: Unsupported item key.
[root@svx-mon-02t ~]#

I thinks that I need or there are an error into the Template.

Thanks for your help
Regards
Olivier

Hey studero, windowssqlinstances is not a standard item key to my knowledge.
You can find these in the Agent documentation (https://www.zabbix.com/documentation.../zabbix_agent2)

If you want to use this key you'd have to add a user parameter but I don't find this anywhere in the documenation of this template.

[cyber]

Hey studero, windowssqlinstances is not a standard item key to my knowledge.
You can find these in the Agent documentation (https://www.zabbix.com/documentation.../zabbix_agent2)

If you want to use this key you'd have to add a user parameter but I don't find this anywhere in the documenation of this template.

Correct, this is not a built-in item and that template is missing actual powershell script for that.. Script is mentioned in that other template there (databases) https://github.com/zabbix/community-...(lld).yaml#L28

Unfortunately, without it, this template is useless and whoever added that template to community templates, has done load of useless work (multiple versions etc. but still missing the most important part).

[TheBonaZabbix]

Thanks Cyber !

[fmt-chs]

Hey studero,
I too needed the template to work.
I havent talked with abakaldin, the creator of the template, but i have created the powershell script to get this to work.
Please see: https://github.com/chhsoe/powershell...-for-zbx-mssql
There is also a guide there to get it to work.