Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

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