Network Management

Custom SQL Windows Node Credential Report

This article describes how to create a custom SQL report for Windows Nodes and their assigned credentials.

First published date

11/7/2018 9:01 PM

Last published date

7/27/2021 12:31 PM

Overview

This article describes how to create a custom SQL report for Windows Nodes and their assigned credentials.

Note: Custom SQL is not supported by SolarWinds Technical Support.

Product section

Network Performance Monitor

Resolution

  1. Navigate to the Manage Reports page.
  2. Click the Create New Report button.
  3. Select Custom table.
  4. Select the "Advanced SQL Database query" option under the Selection Method.
  5. Select "SQL" for the query type and paste this query:
--Disclaimer:
--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.

select Credential.Name, nodes.Caption, nodes.NodeID, nodesettings.SettingName, NodeSettings.SettingValue from Nodes
join NodeSettings on nodes.NodeID = Nodesettings.NodeID
join Credential on nodesettings.SettingValue = Credential.ID
where nodes.ObjectSubType = 'WMI' and nodesettings.SettingName = 'WMICredential'
  1. Adjust or add to the custom SQL query above to add more columns/information.