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
Home
Products
Network Performance Monitor (NPM)
What can I do with a SQLResource?
kevbo
I'm tasked with making a new resource. Looking at the code for some of the existing resources, I see code that I tried to emulate, so I have something like this:
Set SQLResource = NetPerfMon.NewSQLResource
SQLResource.SQL="Select NodeID, Caption, GroupStatus, AvgResponseTime, PercentLoss From Nodes' Order By IP_Address Desc"
SQLResource.Filter=Resource.GetProperty("Filter")
SQLResource.Execute
GetServerStat = SQLResource.GetProperty("GroupStatus")
The thing is, this doesn't just give me what is in the table column GroupStatus...it gives me that, wrapped in an <img> tag.
I was wonder if there's any doc on what all you can do with a NetPerfMon.NewSQLResource. I'd like to not have to log in to the database myself in my resource, but I may need to, if NetPerfMon.NewSQLResource is doing magic behind the scenes that I don't know about.
Thanks,
Kevin
Find more posts tagged with
Accepted answers
All comments
There are no accepted answers yet
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of