https://kb.rvmgroup.it/index.php?action=history&feed=atom&title=Monitoraggio_MS_SQL_Server_con_Zabbix_Agent2 2026-05-06T00:59:05Z Revision history for this page on the wiki MediaWiki 1.44.2 https://kb.rvmgroup.it/index.php?title=Monitoraggio_MS_SQL_Server_con_Zabbix_Agent2&diff=11303&oldid=prev 2024-10-09T18:14:52Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 18:14, 9 October 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l4">Line 4:</td> <td colspan="2" class="diff-lineno">Line 4:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Installare il plugin</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Installare il plugin</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Riavviare Zabbix Agent2</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Riavviare Zabbix Agent2</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* <del style="font-weight: bold; text-decoration: none;">configurare </del>l'utenza di monitoraggio in SQL Server:&lt;pre&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;">Configurare </ins>l'utenza di monitoraggio in SQL Server:</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&lt;pre&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>USE MASTER</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>USE MASTER</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>CREATE LOGIN zabbix WITH PASSWORD = &#039;S2cr3tPassw0rd&#039;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>CREATE LOGIN zabbix WITH PASSWORD = &#039;S2cr3tPassw0rd&#039;</div></td></tr> </table>

Gabriele.vivinetto https://kb.rvmgroup.it/index.php?title=Monitoraggio_MS_SQL_Server_con_Zabbix_Agent2&diff=11271&oldid=prev 2024-09-26T16:36:21Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:36, 26 September 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''NON COMPATIBLE CON 2008R2'''</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Installare sulla macchina Windows Zabbix Agent2</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Installare sulla macchina Windows Zabbix Agent2</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Scaricare la versione di zabbix_agent2_plugins-x.x.x-windows-amd64.msi corrispondente all versione dell&#039;agent da https://cdn.zabbix.com/zabbix/binaries/stable/</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Scaricare la versione di zabbix_agent2_plugins-x.x.x-windows-amd64.msi corrispondente all versione dell&#039;agent da https://cdn.zabbix.com/zabbix/binaries/stable/</div></td></tr> </table>

Gabriele.vivinetto https://kb.rvmgroup.it/index.php?title=Monitoraggio_MS_SQL_Server_con_Zabbix_Agent2&diff=11270&oldid=prev 2024-09-26T15:59:32Z

<p>Created page with &quot;* Installare sulla macchina Windows Zabbix Agent2 * Scaricare la versione di zabbix_agent2_plugins-x.x.x-windows-amd64.msi corrispondente all versione dell&#039;agent da https://cdn.zabbix.com/zabbix/binaries/stable/ * Installare il plugin * Riavviare Zabbix Agent2 * configurare l&#039;utenza di monitoraggio in SQL Server:&lt;pre&gt; USE MASTER CREATE LOGIN zabbix WITH PASSWORD = &#039;S2cr3tPassw0rd&#039; GRANT VIEW SERVER STATE TO zabbix USE msdb CREATE USER zabbix FOR LOGIN zabbix GRANT EXECUT...&quot;</p> <p><b>New page</b></p><div>* Installare sulla macchina Windows Zabbix Agent2<br /> * Scaricare la versione di zabbix_agent2_plugins-x.x.x-windows-amd64.msi corrispondente all versione dell&#039;agent da https://cdn.zabbix.com/zabbix/binaries/stable/<br /> * Installare il plugin<br /> * Riavviare Zabbix Agent2<br /> * configurare l&#039;utenza di monitoraggio in SQL Server:&lt;pre&gt;<br /> USE MASTER<br /> CREATE LOGIN zabbix WITH PASSWORD = &#039;S2cr3tPassw0rd&#039;<br /> GRANT VIEW SERVER STATE TO zabbix<br /> USE msdb<br /> CREATE USER zabbix FOR LOGIN zabbix<br /> GRANT EXECUTE ON msdb.dbo.agent_datetime TO zabbix<br /> GRANT SELECT ON msdb.dbo.sysjobactivity TO zabbix<br /> GRANT SELECT ON msdb.dbo.sysjobservers TO zabbix<br /> GRANT SELECT ON msdb.dbo.sysjobs TO zabbix<br /> GO<br /> &lt;/pre&gt;<br /> <br /> * Sul server Zabbix, installare il template https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mssql_agent2 selezionando la versione dal branch corretto (6.4, 7..)<br /> * Associarla all&#039;Host<br /> * Impostare le macro:<br /> ** {$MSSQL.HOST}: 192.168.3.106<br /> ** {$MSSQL.USER}: zabbix<br /> ** {$MSSQL.PASSWORD}: S3cr3tPassw0rd<br /> ** {$MSSQL.URI} : sqlserver://192.168.3.106:1433<br /> <br /> == Riferimenti ==<br /> <br /> * [https://www.zabbix.com/forum/zabbix-help/484728-how-do-i-use-mssql-plugin-and-install-it-on-zabbix-agent-2 How do I use MSSQL Plugin and Install it on Zabbix Agent 2? - ZABBIX Forums]<br /> <br /> * [https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mssql_agent2 Browse Zabbix / Zabbix - ZABBIX GIT]</div>

Gabriele.vivinetto