This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Credentials Used By APM Component Monitors

This report shows all component monitors in each application template assigned to nodes and which credentials are being used.

Credentials_Used_By_APM_Component_Monitors_.OrionReport
Parents
  • 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

Reply
  • 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

Children
No Data