MSSQL output multiple values

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
FrontlineIT
Posts: 94
Joined: Tue Jul 26, 2016 8:46 am

MSSQL output multiple values

Post by FrontlineIT »

Hello team!

Is there a way that MSSQL checks can return the output of more than one value or row? Currently, it is only outputting the last row that returns from the query check (returning returning 2 rows). Its a check to see which jobs failed and its returning the names of the jobs. More than likely my check would return 1 to 5 values if there was an issue.

Thank you for any assistance you can provide.
npolovenko
Support Tech
Posts: 3457
Joined: Mon May 15, 2017 5:00 pm

Re: MSSQL output multiple values

Post by npolovenko »

Hello, @FrontlineIT. What plugin are you using? Can you also share the command definition in XI? To do that you can navigate to the Core Configurations Manager, and then click on 'Services', and then select this MSSQL check in the list. Here's an example of what the screenshot should look like:
screenssdsadsd.png
You do not have the required permissions to view the files attached to this post.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked