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

Custom resources no longer work after moving Netperfmon DB

lgurley

Need help with syntex for custom resource.

Set SQLResource = NetPerfMon.NewSQLResource

SQLResource.SQL="select count(*) as COS from heatdb.heat.asgnmnt"

Heatdb is on old db server still. How do I configure the SQLResource to connect to the right DB server.

Find more posts tagged with

web_console

web_page

Accepted answers

All comments

njoylif

don't know if this will work or not but try:
SQLResource.SQL="USE <dbname> select count(*) as COS from heatdb.heat.asgnmnt"

lgurley

heatdb is the name of the database. How do I define the server the DB is on? Does anyone have all of the SQLResource attributes that can be set like user and password?