Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

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: 214 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