Our company has used the solarwinds products for years and we have Network Performance Monitoring, Server & App Monitor, and a few others in the Solarwinds toolbelt. We have remote servers on our network running SQL. Is it possible to use Server & App Monitor to execute a SQL query against a remote SQL server crafted to gather information one can alert on? For instance let's say the SQL query returned a cash variance. Could we create a SQL query to acquire the cash variance from the remote database then use SolarWinds alerts to alert the appropriate parties if it falls out of spec?
Further research has helped me to refine what I'm looking for. I want Solarwinds (SW) to poll a remote SQL database requesting one or more pieces of information gathered by a custom query. Then I want SolarWinds to store the information so I can create custom alerts if the information goes out of spec. In the example I gave earlier of a cash variance I want SW to poll the remote database for the cash variance, store the variance in the SW DB, and then be able to use the Alert Manager to create an alert when the spec is out of bounds.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.