Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Server & Application Monitor (SAM) > Clear Threshold Values stuck in Components

Clear Threshold Values stuck in Components

Table of contents
Created by Robert Stidman, last modified by MindTouch on Jun 23, 2016

Views: 7 Votes: 0 Revisions: 2

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
02:48, 23 Jun 2016

Tags

Classifications

Internal Use Only