We have a situation where we need to clear template overrides from > 1,800 components and set them back to Inherit from Template.
I opened a case with support (1091057) for an SQL delete. They said NO!!! I had gotten one in the past to force Credential overrides out. This what they gave me then:
-- force a template to inherit credentials
DELETE cs
FROM APM_Component c
INNER JOIN APM_ComponentTemplate ct ON c.TemplateID = ct.ID
INNER JOIN APM_ComponentSetting cs ON c.ID = cs.ComponentID
WHERE ct.ApplicationTemplateID = 208 AND cs.[Key] IN ('__Disabled')
-- You can do it against an Application instead of a Template. The following query can be used:
/*
DELETE cs
FROM APM_Component c
INNER JOIN APM_ComponentTemplate ct ON c.TemplateID = ct.ID
INNER JOIN APM_ComponentSetting cs ON c.ID = cs.ComponentID
WHERE c.ApplicationID = 239 AND cs.[Key] IN ('AuthenticationType', '__CredentialSetId')
*/
I'm looking to do the same general thing for the thresholds. This SQL lists the overrides:
select * from APM_Threshold
where IsTemplate = 0
and ID in
(select c.ID from APM_Component c
join APM_Application app on app.ID = c.ApplicationID
where app.TemplateID = 9)
Can I just make this into a DELETE call?
I have opened a feature request for this ( ), but am not hopeful and need to get this done long before the 2nd update is delivered.
Thanks,
M
