1_mk

Nimsoft and Custom SQL and Script

Discussion created by 1_mk on Sep 15, 2010
Latest reply on May 7, 2014 by 1_keithk

I need to have Nimsoft alert off of a value returned by a piece of custom SQL submitted to the Oracle and MS SQL Server databases that we monitor.

For Example:

    Example A:
        select count(*) mycount from dual;
        Alert if value of the mycount field is greater than 1.

    Example B:
        select mypackage.check_stuff('ALL') mystatus from dual;
        Alert is value of the mystatus field is 'ERROR'.


Also, I need to have Nimsoft alert off of a value returned by a piece of shell script submitted to the Linux servers that we monitor.

For Example:
    The shell script might be written in sh, bash, ksh, csh, or perl.

    Example A:
        /opt/checkit/isok.sh
        Alert if value returned from the isok.sh shell script is not equal to 0.

    Example B:
        /opt/checkit/outputstatus.sh
        Alert if the work ERROR is found in the output of the outputstatus.sh shell script.


How do we set this up in Nimsoft?  Any help would be greatly appreciated.  Thanks!

Outcomes