Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Archive > 2017December13 - Deletes > Clear Threshold Values stuck in Components

Clear Threshold Values stuck in Components

Table of contents
Created by Robert Stidman, last modified by Kevin.Swinson on Dec 13, 2017

Views: 625 Votes: 0 Revisions: 3

Overview

In some cases, a SAM template is assigned to many nodes, and at the application level some of the components will have been manually use static thresholds or to calculate baseline.  Whatever value the components get for the baseline becomes "stuck" if the baseline calc setting is removed at the template level.  This article aims to help people clear the integer values that get put in place for the baselines.

Environment

  • All SAM versions

Steps

1.  You must know the template ID number of the template you wish to do this for.  The query below is for one template at a time.  Engage the customer's DBA to run it.

2.  The DBA must back up the Orion database before the run the query below

 

delete from APM_Threshold
from APM_Threshold t2
inner join APM_Component c on c.ID = t2.ID
inner join APM_Application a on c.ApplicationID = a.ID
where t2.IsTemplate = 0 and a.TemplateID = ***put template id number here***

 

remove the ***'s from the above and execute the query.

 

After that customer should load the applications and look at "edit application" - all components should have blank threshold values.

 

 

Last modified

Tags

Classifications

Internal Use Only