Forum Discussion

onlyguyhere_409's avatar
onlyguyhere_409
Icon for Nimbostratus rankNimbostratus
Mar 27, 2009

MSSQL Monitor

I am new to the BigIP LTM world. The question I have is there a way to add some logic into MSSQL monitor to perform certain task depending on what is return from a query of my system events database? Or will I have to write a script to perform if/ then /else logic.

 

The scenario is depending on the alert that is contained in my event database the LTM will perform a certain type of failover base on what is returned from the query.
management
monitoring

1 Reply

Sort By
  • hooleylist's avatar
    hooleylist
    Icon for Cirrostratus rankCirrostratus
    Apr 02, 2009
    I wonder if you could use alertd to call a script if a specific log message is seen. See this inconclusive thread for details:

     

     

    Generic command in user_alert.conf

     

    http://devcentral.f5.com/Default.aspx?tabid=53&view=topic&postid=55956&ptarget=55973 (Click here

     

     

    You could then potentially configure an MSSQL monitor and use alertd to call a shell script when a failure is detected. I haven't tried this before as I just found out you can call a script from alertd. If this sounds like it could work for you, you might try opening a case with F5 Support to find out about this 'exec command=/path/to/script.sh' functionality. If you do get more info, can you reply here or in the other post?

     

     

    Thanks,

     

    Aaron