Check WMI nodes where service monitoring account is associated

Version 1

    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'