You can test each script manually in PowerShell before using them in Zabbix. Make sure to replace the IP addresses, domains, and URLs with your own examples.

Who are these scripts ... SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, wrestle with terrible SSMS interfaces, or learn XML.