There are many credentials accumulated from remote agent installations. These need to be cleaned up. Before cleaning, is there a way to see which agent was installed with which credential or which SolarWinds user installed it and when? I've been searching through all credential and agent tables in the database and SWQL for hours but couldn't find anything. For example, how can I link the following SWQL table with agents?
<span class="hljs-keyword">SELECT</span> TOP <span class="hljs-number">1000</span> ID, Name, Description, CredentialType, CredentialOwner, DisplayName, InstanceType, Uri, InstanceSiteId <span class="hljs-keyword">FROM</span> Orion.Credential <span class="hljs-keyword">WHERE</span> credentialtype <span class="hljs-keyword">LIKE</span> <span class="hljs-string">'%SolarWinds.Orion.Core.SharedCredentials.Credentials.UsernamePasswordCredential%'</span>
This is very urgent for us; please, someone knowledgeable help us.
