We have a requirement to query a database table to return a single value using a stored procedure.
We have on-prem installation version 23.1
Below is the only documentation I could find
SQL Server Monitoring Metrics
Your assistance will be appreciated
I think you need to develop a script in perl, php or java to execute the query (stored procedure) and upload it using an EPAgent.
Two options are for this too: to contact Broadcom services or to develop it internally. third option: a third party ;)