This report shows all component monitors in each application template assigned to nodes and which credentials are being used.
This report shows all component monitors in each application template assigned to nodes and which credentials are being used.
With help from @adatole we came up with this query that allows us to see what WMI Credentials are being used on nodes that are set up as WMI & ICMP
use SolarWindsOrion;
select nodes.NodeID, nodes.Caption,
nodesettings.SettingName, NodeSettings.SettingValue,
Credential.Name
from Nodes
join NodeSettings on nodes.NodeID = Nodesettings.NodeID
join Credential on nodesettings.SettingValue = Credential.ID
where nodes.ObjectSubType = 'WMI'
and nodesettings.SettingName = 'WMICredential'
order by nodesettings.SettingValue asc
With help from @adatole we came up with this query that allows us to see what WMI Credentials are being used on nodes that are set up as WMI & ICMP
use SolarWindsOrion;
select nodes.NodeID, nodes.Caption,
nodesettings.SettingName, NodeSettings.SettingValue,
Credential.Name
from Nodes
join NodeSettings on nodes.NodeID = Nodesettings.NodeID
join Credential on nodesettings.SettingValue = Credential.ID
where nodes.ObjectSubType = 'WMI'
and nodesettings.SettingName = 'WMICredential'
order by nodesettings.SettingValue asc
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.