Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > SAM: Applications Polling Frequency and Timeout Settings query

SAM: Applications Polling Frequency and Timeout Settings query

Table of contents

Updated September 26th, 2017

Overview

The following query will provide the Polling Frequency and Timeout Settings for all applications.  

 

Environment

  • All versions of SAM

Detail

The query below can be executed against the Orion database from Database Manager or SQL Management Studio.  

 

SELECT
    APM_Application.TemplateID,
    APM_Application.ID,
    APM_Application.Name,
    ISNULL(ISNULL(asFreq.Value, atsFreq.Value),300) as Frequency,
    ISNULL(ISNULL(asTimeout.Value, atsTimeout.Value),300) as [Timeout]
FROM
    APM_Application
    LEFT JOIN APM_ApplicationTemplateSetting atsFreq ON APM_Application.TemplateID = atsFreq.ApplicationTemplateID AND atsFreq.[Key]='__Frequency'
    LEFT JOIN APM_ApplicationTemplateSetting atsTimeout ON APM_Application.TemplateID = atsTimeout.ApplicationTemplateID AND atsTimeout.[Key]='__Timeout'
    LEFT JOIN APM_ApplicationSetting asFreq ON APM_Application.ID = asFreq.ApplicationID AND asFreq.[Key]='__Frequency'
    LEFT JOIN APM_ApplicationSetting asTimeout ON APM_Application.ID = asTimeout.ApplicationID AND asTimeout.[Key]='__Timeout'

 

 

 

Last modified

Tags

Classifications

Public