Read Registry or Execute SQL query on a DB in a node

venh.123

I have got a tricky requirement. I have various kinds of nodes being monitored. Some of them are app / web servers and some are SQL server nodes. For the app / web server nodes, I have been asked to read a registry key through SolarWinds and display it in Node Details in SolarWinds. For DB server, I have been asked to execute a SQL query on a particular DB and show the result in Node Details. Is this achievable? If so, can anyone please guide me?

mesverrum

With SAM there are no built in components for checking registry keys per se but you could do it by setting up a powershell script component to look it up.  Here is some discussion regarding how to pull reg keys in powershell

variables - How do I get the value of a registry key and ONLY the value using powershell - Stack Overflow

and if you arent familiar with setting up script app monitors this series of posts will be helpful

The Basics of PowerShell (part 1)

The Basics of PowerShell (part 2)

The Basics of PowerShell (part 3)

For your SQL problem, if the results of the query would return a single row with a numeric response then you can use the built int SQL User Experience Monitor component to get what you need, if they want to execute a query that might return an array of values then you are probably going to need to wrap it inside another custom script monitor to parse the array and break it down (keep in mind that each script monitor can only return a maximum of 10 responses, but depending how clever you get you can usually get most sets of data to fit into that constraint.