Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

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: 2,055 Votes: 3 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

Tags

Classifications

Public