Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Server & Application Monitor (SAM) > 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