Identify nodes credentials (SNMP/Windows) in the SolarWinds Platform via SQL query

This article provides a step-by-step procedure for identifying the Entities (nodes) to which SNMP or Windows credentials are assigned.

You can do this directly in Database Manager.

• Open Database Manager on the SolarWinds Platform server.
• Connect to your SolarWindsOrion database.
• Highlight your database > right click and click New Query.
• Paste the below and click Execute Query.

-- 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 
    n.NodeID,
    n.Caption       AS [Node Name],
    n.IP_Address    AS [IP Address],
    c.ID            AS [CredentialID],
    c.Name          AS [Credential Name],
    ns.SettingName  AS [Setting Name]
FROM Nodes n
LEFT JOIN NodeSettings ns 
    ON n.NodeID = ns.NodeID
   AND ns.SettingName LIKE '%Credential%'
LEFT JOIN Credential c 
    ON TRY_CONVERT(int, ns.SettingValue) = c.ID
WHERE n.ObjectSubType <> 'ICMP'
ORDER BY c.Name, n.Caption;