SNMP credential assignments

Question

Does anyone have a query or know how I can find which nodes are assigned specific snmp credentials?

Under 'Manage SNMP Credentials'  I show how many nodes are assigned to a particular credential, but I cannot find a way to list the nodes assigned to that credential.

Thank you!

mesverrum · Accepted Answer

I use this in a custom query widget for that

SELECT n.Caption AS [Node Name] ,n.detailsurl as [_linkfor_Node Name], '/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node Name],n.ip_address as [IP Address],n.detailsurl as [_linkfor_IP Address],c.Name AS [WMI/SNMPv3 Credential Name], n.Community as [SNMPv2 Community],'Edit' AS [Edit], '/Orion/Nodes/NodeProperties.aspx?Nodes=' + ToString(n.NodeID) AS [_LinkFor_Edit],'/Orion/images/nodemgmt_art/icons/icon_edit.gif' as [_IconFor_Edit]

FROM Orion.Nodes n   
left JOIN Orion.NodeSettings ns ON n.NodeID = ns.NodeID  and ns.SettingName like '%Credential%'  
LEFT JOIN Orion.Credential c ON ns.SettingValue = c.ID

where n.ObjectSubType!= 'ICMP'  
--and (n.caption like '%${SEARCH_STRING}%' or n.community like '%${SEARCH_STRING}%' or c.name like '%${SEARCH_STRING}%')

sum_giais · Accepted Answer

The query above is a SWQL query - it won't work in database manager or SSMS. You'll need to use SWQL Studio or a custom query widget or custom report with a SWQL query datasource to use it.

Try one of the queries here:  Node assigned credentials SWQL query

There's a version for both SWQL, or SQL depending on your need.