Nagios Support Forum

Posted: **Thu Dec 22, 2016 3:49 pm**

check_mssql doesn't work that way unfortunately. That would require altering the check_mssql plugin to add it's query results to the output message. It would likely involve changing the following block:

Code: Select all

if (mssql_num_rows($query_data) > 0 ) {
        while ($row = mssql_fetch_row($query_data)) {
            $column_name = mssql_field_name($query_data, 0);
            $query_result = $row[0];
        }
    }

To append the returned row to $output_msg.

Posted: **Mon Dec 26, 2016 1:20 am**

Thank you!

The changes you have sent to me, do I need to add it in check_mssql_query plugin to get desired results?

If yes, can you please guide me where those changes need to implement or send me the updated plugin with suggested changes.

Thanks

Posted: **Tue Dec 27, 2016 1:17 pm**

This is beyond the scope of the support we can provide, @mcapra showed you the part that will need to be modified. If you have a developer on your team, I would contact them.

Nagios Support Forum

MSSQL database wizard issue

Re: MSSQL database wizard issue

Re: MSSQL database wizard issue

Re: MSSQL database wizard issue