For more information regarding the security incident at F5, the actions we are taking to address it, and our ongoing efforts to protect our customers, click here.

Forum Discussion

BigTuna_117707's avatar
BigTuna_117707
Icon for Nimbostratus rankNimbostratus
Sep 13, 2017

SQL Monitor

I am trying to create a SQL health monitor that uses an alias address, does a SQL query and looks for a number in a row. If the number is returned the monitor marks the node up. The monitor is workin...
application delivery
LTM
Simon_Blakely's avatar
Simon_Blakely
Icon for Employee rankEmployee
Sep 14, 2017

You cannot do this with an inbuilt SQL monitor - there is no mechanism for substitution in the SEND string. Is there no way to write the SQL query to select the correct row for the targeted device?

 

Alternatively, you could write an external monitor (which get the node IP and port as parameters). You are limited in the tools you have available for connecting to SQL servers, though.

 

https://devcentral.f5.com/wiki/advdesignconfig.externalmonitor.ashx