Applications Systems

Create a report of credentials used for monitoring SAM

Create a report of credentials used for monitoring SAM.

First published date

11/22/2018 3:20 PM

Last published date

9/23/2025 8:47 PM

Overview

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

Product section

Server Application Monitor

Resolution

  1. Log in to the SolarWinds Platform Web Console.
  2. Navigate to Reports > All Reposts > Manage Reports.
  3. Select Create New Report. The report builder opens.
  4. Select Custom Table, and under Selection Method, select Advanced Database Query.
  5. Set the Query Type as SQL and paste 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

/* Scripts are not supported under any SolarWinds support program or service. Scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties, of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation. */
  1. Select Add to Layout. The Table Layout builder opens automatically.
  2. Add columns to the table, and submit.
  3. Add a title for the report and select next. The report preview displays.
  4. Select Next to add properties if needed and to schedule the report.
  5. On the Summary page, select Submit to finish creating the 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: Node/application credential from poller is locked out