Have on per component the credential used

I was following this as I was curious myself and then reviewing for something completely different I came across this in the KB:

Use SQL to show components and credentials applied to them - SolarWinds Worldwide, LLC. Help and Support

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.

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}%')