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

Is there a way to access the property of a SAM component through the database?

Is there a way to access the <User Note> property of a SAM component through the database? If so can someone direct me to the database table. I know it can be accessed in a advanced alert, but I am looking for a database solution for what I need to do.

Thanks

Joe

Find more posts tagged with

Accepted answers

All comments

Hi, user note is one of properties which is inherited from template but can be overridden on application level, so you can find both values for each component this way:

SELECT n.Caption as NodeName, a.Name as ApplicationName, c.Name as ComponentName, cs.Value, cts.Value as TemplateValue

FROM APM_Component c

INNER JOIN APM_ComponentTemplate ct ON c.TemplateID = ct.ID

INNER JOIN APM_Application a ON c.ApplicationID = a.ID

INNER JOIN Nodes n ON a.NodeID = n.NodeID

LEFT JOIN APM_ComponentSetting cs ON cs.ComponentID = c.ID AND cs.[Key] = '__UserDescription'

LEFT JOIN APM_ComponentTemplateSetting cts ON cts.ComponentTemplateID = ct.ID AND cts.[Key] = '__UserDescription'

Quick Links