Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

What APM saved Credentials are being used where?

I am in the process of switching several components from one saved credential to another. I THINK I have them all switched, but I am not sure (there were quite a few). Is there a way to see what components are using a credential? Could I create a custom report that listed all components and their associated credential?

Find more posts tagged with

Accepted answers

andrew

Yes, that works perfect!!! Interestingly, the query returns 1190 results, but I only have 1151 components according to APM License Summary.

I improved it a little bit by adding the server name in there and sorted it.

SELECT n.Caption AS Server, a.Name AS Application, cd.Name AS Component, c.Name AS Credentials
FROM APM_ComponentDetails AS cd INNER JOIN
APM_Application AS a ON cd.ApplicationID = a.ID INNER JOIN
APM_Credentials AS c ON cd.Value = c.ID INNER JOIN
Nodes AS n ON a.NodeID = n.NodeID
WHERE (cd.[Key] = '__CredentialSetId')
ORDER BY Server, Application, Component;

All comments

qle

My SQL knowledge is very basic so if someone can improve upon this, please do. Anyway, you can choose to create an Advanced SQL report in Report Writer with this SQL query or if you're only going to run once, you can run it from the Database Manager.

SELECT APM_Application.Name as Application, APM_Component.Name as Component, APM_Credentials.Name as Credentials FROM APM_Application, APM_Component, APM_ComponentSetting, APM_Credentials where [key]='__CredentialSetId' and value=APM_Credentials.Id and APM_Component.Id=ComponentId and APM_Application.Id = APM_Component.ApplicationId

Let me know if that helps.

andrew

Thank you! That is EXACTLY what I was looking for.

cgregors

I ran it against my db and it didn't return all the credentials. There were some I expected that were missing.

andrew

You know what, you are correct. That query is returning 613 rows, but I have 1,151 components according to the APM licensing page.

josh.clark

Does this work better?

SELECT a.Name, cd.Name AS Component, c.Name AS Credentials
FROM APM_ComponentDetails cd
INNER JOIN APM_Application a ON cd.ApplicationId = a.ID
INNER JOIN APM_Credentials c ON cd.value = c.ID
WHERE cd.[Key]='__CredentialSetId'