MSSQL database wizard issue

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: MSSQL database wizard issue

Post by mcapra »

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.
Former Nagios employee
https://www.mcapra.com/
Naveed
Posts: 285
Joined: Mon May 30, 2016 10:10 am

Re: MSSQL database wizard issue

Post by Naveed »

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
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: MSSQL database wizard issue

Post by rkennedy »

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.
Former Nagios Employee
Locked