Browse by or View APM monitor by Credential?

Is there anyway from inside the web interface that I can view all of my APM monitors by what Credential we are using? Reason being is that we had an admin leave and we are needing to change the password for that credential. Running APM 4.2 SP1. Credentials

Find more posts tagged with

sort

Application

administrator

apm_4.2

monitors

manage

column

credentials

Accepted answers

All comments

aLTeReGo

I posted some reports in the Content Sharing Zone that aren't exactly what you're looking for, but they're pretty close. They should at least point you in the right direction. The reports I'm referring to are listed below.

APM Component Monitors that are not Inheriting from their Original Template

APM Component Monitors Whose Credentials are not Inherited from the Original Template

The report will look similar to the one below. The column on the right displays a number which is a unique identifier for the credential being used from the credential database. So in my lab Credential #1 is my Windows Administrator account, and credential #2 is my Unix/Linux "root" credential.

Petr.Vilem

Query that should be closer to what you are looking for may look like this:

SELECT n.NodeID, n.Caption as Node, a.ID as ApplicationID, a.Name as [Application], c.ID as ComponentId, c.Name as Component,
    cts.Value as TemplateCredId, cs.[Value] as OverridenCredId, cred.Name as CredName
FROM APM_Component c
    INNER JOIN APM_Application a ON c.ApplicationID = a.ID
    INNER JOIN Nodes n ON a.NodeID = n.NodeID
    LEFT JOIN APM_ComponentSetting cs ON cs.ComponentID = c.ID AND cs.[Key] = '__CredentialSetId'
    LEFT JOIN APM_ComponentTemplate ct ON ct.ID = c.TemplateID
    LEFT JOIN APM_ComponentTemplateSetting cts ON cts.ComponentTemplateID = ct.ID AND cts.[Key] = '__CredentialSetId'
    LEFT JOIN [Credential] cred ON cred.ID = ISNULL(cs.Value, cts.Value)

It is including even credentials which are inherited from template and also column with credential name.

You can easily create report using this query to have it available from your web interface.

aLTeReGo

I posted this report as well to the Content Exchange it can be found at the link below.

Credentials Used By APM Component Monitors