Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Run SQL Query on Node

I have a node that I am monitoring via SAM ( we are considering adding DPA) and the developers have asked if I can put the results of one of the stored procedures from that server into the monitoring results from the server. Is it possible to run an SQL query on an agent monitored node?

Find more posts tagged with

Accepted answers

All comments

sum_giais

Not sure if there’s a better way to do this, but you could use a powershell component monitor to run a script that uses Invoke-SqlCmd to run a query.

https://documentation.solarwinds.com/en/Success_Center/SAM/Content/SAM-Create-Windows-PowerShell-Script-Monitor.htm

https://docs.microsoft.com/en-us/powershell/module/sqlserver/invoke-sqlcmd?view=sqlserver-ps

JimKearney

I will give this a try and let you know how it goes