The plugin doesn't support Microsoft SQL Azure

[k67078]

HI,
We receive the error below when we ran Invoke-IcingaCheckMSSQLHealth to check Microsoft SQL Azure.
Error:
@@servicename' is not supported in this version of SQL Server.

Following the error I found out that Get-IcingaMSSQLInstanceName is querying @@ServerName which is not supported in Microsoft SQL Azure

[LordHepipud]

Thank you for the issue. I'm not sure if the plugin entirely is supposed to work with Azure.
I assume the plugin will connect to a remote instance of MSSQL and not apply the check locally? In that case, the health check would not work at all, because we fetch the local service state and therefor require the instance name for the service.

The basic idea behind this health plugin was to connect to the database, check if that is working and afterwards see if all required services are working.

If my assumption is correct and Azure MSSQL is not meant for that (I have no experience with it), I would be open for suggestions for monitoring the MSSQL health with additional information and make it compatible with Azure MSSQL.