Submit a ticketCall us

WebinarFREE IT Monitoring Webcast

Don’t miss out on our webcast, Essential IT Monitoring with SolarWinds ipMonitor, where we will show you how to keep an eye on your IT environment from one centralized, affordable, and lightweight monitoring tool: SolarWinds® ipMonitor®.

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