Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Server & Application Monitor (SAM) > Create a report of credentials used for monitoring SAM

Create a report of credentials used for monitoring SAM

Table of contents
Created by Matthew Johnsen, last modified by MindTouch on Jun 23, 2016

Views: 27 Votes: 2 Revisions: 4

Overview

This article describes how to create a report of credentials used for monitoring SAM.

Environment

All SAM versions

Steps

 

  1. Log in remotely to Orion.
  2. Go to Start > All Programs > SolarWinds Orion > Alerting, Reporting, and Mapping > Report Writer.
  3. Create a new Advanced SQL report. Refer to Understanding Orion Report Writer
  4. Go to the SQL tab and enter 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)
    WHERE Cred.Name IS NOT NULL
  5. Save the new report.

 

---------------------

 

If you run this report, but still do not find the credentials in question, see the following KB as it may apply to your scenario:

https://support.solarwinds.com/Succe...arWinds_Poller

 

Last modified
02:49, 23 Jun 2016

Tags

Classifications

Public