Search found 6 matches

by peterko
Tue May 24, 2016 4:16 pm
Forum: Open Source Nagios Projects
Topic: Plugin check_mssql_health issue on Microsowft Azure
Replies: 11
Views: 7728

Re: Plugin check_mssql_health issue on Microsowft Azure

Yes, because the plugin does now\t worked with Microsoft Azure SQL Database, so we used python API to run queries for all checks we looking for (db size, table density, status of ETL processes, etc.)
by peterko
Tue May 24, 2016 2:03 pm
Forum: Open Source Nagios Projects
Topic: Plugin check_mssql_health issue on Microsowft Azure
Replies: 11
Views: 7728

Re: Plugin check_mssql_health issue on Microsoft Azure

We can close this ticket but is without solution
by peterko
Tue May 24, 2016 4:05 am
Forum: Open Source Nagios Projects
Topic: Plugin check_mssql_health issue on Microsowft Azure
Replies: 11
Views: 7728

Re: Plugin check_mssql_health issue on Microsowft Azure

Hi,
we already do not use the plugin because of issue with Microsoft Azure, for us is much simpler use python module for Azure connected to Nagios.
by peterko
Mon May 23, 2016 5:53 am
Forum: Open Source Nagios Projects
Topic: Plugin check_mssql_health issue on Microsowft Azure
Replies: 11
Views: 7728

Re: Plugin check_mssql_health issue on Microsowft Azure

Hi, I try following code: /usr/lib/nagios/plugins/check_mssql_health -v --server abcd --username "xyz123abc" --password 'XYZ123456' --name abcd --mode sql "SELECT 1 FROM [dbo].[GetMonitoringStatus] ('Density')" --commit It does not work, still the same issue Could not find stored...
by peterko
Wed May 18, 2016 6:16 am
Forum: Open Source Nagios Projects
Topic: Plugin check_mssql_health issue on Microsowft Azure
Replies: 11
Views: 7728

Re: Plugin check_mssql_health issue on Microsowft Azure

Hi, if I try remove name parameter: /usr/lib/nagios/plugins/check_mssql_health -v --server abcd --username "xyz123abc" --password 'XYZ123456' --mode sql "SELECT * FROM [dbo].[GetMonitoringStatus] ('Density')'" --commit I got an error: UNKNOWN - Use of uninitialized value $sql in ...
by peterko
Tue May 17, 2016 6:37 am
Forum: Open Source Nagios Projects
Topic: Plugin check_mssql_health issue on Microsowft Azure
Replies: 11
Views: 7728

Plugin check_mssql_health issue on Microsowft Azure

Hello everyone, I have a problem with using plugin check_mssql_health for Azure SQL Database . Every time I was trying to connect to the database monitor and execute SQL Statement (get the result of user defined function), I got an error, because I connect to master database instead of monitor datab...