SELECT
[Node].Caption,
[Node].IPAddress,
[Credential].Name,
[NodeSettings].SettingName,
[NOdeSettings].SettingValue,
[Node].NodeID
FROM Orion.Nodes AS [Node]
JOIN Orion.NodeSettings AS [NodeSettings] ON [Node].NodeID = NodeSettings.NodeID
JOIN Orion.Credential AS [Credential] ON [NodeSettings].SettingValue = Credential.ID
WHERE [Node].ObjectSubType = 'WMI' AND [NodeSettings].SettingName = 'WMICredential'
ORDER BY [Credential].Name, [Node].Caption, [NodeSettings].SettingValue ASC