Showing results for 
Search instead for 
Did you mean: 
Create Post

APM Component Monitors that are not Inheriting from their Original Template

This report lists all Component Monitors that are not inheriting from their original Application Template.

Labels (1)
Tags (1)

I really don't think report even works.  I've been forced to change some 1000 components back to inheriting because we broke inheritance testing out base lining yet this report shows the exact same number of components "not inheriting" as it did before...

Old thread granted but as I didnt find the answer elsewhere I thought I'd post this.

This SQL (borrowed and modified from the original SQL query) seems to work better and lists all components that deviate from their templates along with their new thresholds

USE SWMonitoring

SELECT APM_Component.ID, APM_ApplicationTemplate.Name AS ApplicationTemplate, Nodes.Caption, APM_Component.Name AS Component, APM_Threshold.ThresholdName, APM_Threshold.Warning, APM_Threshold.Critical

FROM APM_Component

INNER JOIN APM_Application ON APM_Component.ApplicationID = APM_Application.ID

INNER JOIN APM_ApplicationTemplate ON APM_Application.TemplateID = APM_ApplicationTemplate.ID

INNER JOIN Nodes ON APM_Application.NodeID = Nodes.NodeID

LEFT JOIN APM_Threshold ON APM_Component.ID = APM_Threshold.ID

WHERE APM_Component.ID IN (SELECT ID FROM APM_Threshold WHERE IsTemplate = 0 AND ID IN (SELECT APM_Component.ID FROM APM_Component JOIN APM_Application ON APM_Application.ID = APM_Component.ApplicationID))

Version history
Revision #:
1 of 1
Last update:
‎01-04-2012 12:00 AM
Updated by: