Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Server & Application Monitor (SAM) > Use SQL to show components and credentials applied to them

Use SQL to show components and credentials applied to them

Table of contents
Created by Riggs Clough, last modified by MindTouch on Jun 23, 2016

Views: 67 Votes: 3 Revisions: 4

Overview

This article describes how to show components and applications and credentials that are applied to them.

Environment

All SAM versions

Detail

  1. Navigate to the Orion Server.
  2. Open Database Manager.
  3. Open the Default Server.
  4. Right click  the SolarWindsOrion database.
    Note: This may be called NetPerfMon depending on when you originally installed the software.
  5. Select New Query.
  6. Run the following query:
    SELECT n.NodeID, n.Caption as Node, a.ID as ApplicationID, a.Name as [Application], c.ID as ComponentId, c.Name as Component,

    cts.Value as TemplateCredId, cs.[Value] as OverridenCredId, cred.Name as CredName
FROM APM_Component c
    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] = '__CredentialSetId'
    LEFT JOIN APM_ComponentTemplate ct ON ct.ID = c.TemplateID
    LEFT JOIN APM_ComponentTemplateSetting cts ON cts.ComponentTemplateID = ct.ID AND cts.[Key] = '__CredentialSetId'
    LEFT JOIN [Credential] cred ON cred.ID = ISNULL(cs.Value, cts.Value)

 

This returns Node ID/Name, ApplicationID/Name, ComponentID/Name, and the credentials that are applied to it. A TemplateCredID of -3 means it is inherited from the template.

 

 

Last modified

Tags

Classifications

Public