Below SQL query we can in solarwinds DB to get the list of node
Select Nodes.IP_Address, Nodes.Caption, Credential.Name from Credential
inner join NodeSettings on Credential.ID=NodeSettings.SettingValue
inner join Nodes on NodeSettings.NodeID=Nodes.NodeID
where NodeSettings.SettingName='WMICredential'
Select Nodes.IP_Address, Nodes.Caption, Credential.Name from Credential
inner join NodeSettings on Credential.ID=NodeSettings.SettingValue
inner join Nodes on NodeSettings.NodeID=Nodes.NodeID
where NodeSettings.SettingName='WMICredential'