-
Re: Have on per component the credential used
jrouviere Aug 14, 2018 11:59 AM (in response to MathieuJM)I was following this as I was curious myself and then reviewing for something completely different I came across this in the KB:
It takes a little bit of modification to put into SWQL, but I think you should be able to adapt it to your needs. For SWQL I had to update the Table references and change c.ID (for Component ID) to c.ComponentID.
-
Re: Have on per component the credential used
mesverrumAug 14, 2018 10:26 PM (in response to MathieuJM)
This is the SWQL one i use for this, keep in mind that big environments can have a lot of components
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}%')
-
Re: Have on per component the credential used
MathieuJMAug 21, 2018 2:30 AM (in response to MathieuJM)
Many thanks to both of you.
I will check this in my infrastructure.