I'm trying to figure out how to get a list from one of our databases and display it in the application monitor.
It's for keeping track of the status of some database processes.
I've tried using the sql service experience monitor but it seems to expect the sql to just return one value.
Is there something else i should be looking at instead?
How is AppInsight utilized to display multiple results from a custom query? It's a shame that this can't be done for simple data display a single component at a time.
AppInsight applications are complex, purpose built, application specific monitors that do not always adhere to the limitations of traditional component monitors. Because the data set/types are known and the use cases well understood and properly defined they can sometimes be far easier to implement than a general purpose component monitor type that could be used for various other tasks. I have logged this as a feature request internally under FB153908, but I encourage you to create an idea for this so others in the Thwack community can also vote on it. I suggest including a full description of what you would be trying to accomplish with such a monitor so we can understand the various different use cases and value this would provide.
There are two approaches to this problem:
1. Write a query that returns several values, formats those values in a table format or similar, and returns a single number that summarises those. The problem with this, is that you only have the full details/numbers on the current read - the historical numbers only have that single number.
2. use a script instead of SQL. All scripts can return up to 10 numbers and descriptions, and you get the whole history for all of them.
A numeric value used to determine how the monitor compares to its set thresholds. This must be an integer value, (negative numbers are supported).
An error or information message to be displayed in the monitor status details. Note: Multi-line messages are supported. To use this functionality print each line using a separate command. For example:
Only real thing to trip over, is that you can't have new line characters in your message value. If you need to display multiple lines use HTML eg <br /> <p> <table> etc
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.