Forum Discussion
BigTuna_117707
Nimbostratus
Sep 13, 2017SQL 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...
Simon_Blakely
Employee
Sep 14, 2017You 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
Help guide the future of your DevCentral Community!
What tools do you use to collaborate? (1min - anonymous)Recent Discussions
Related Content
DevCentral Quicklinks
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com
Discover DevCentral Connects