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) > How to display all components polled for each polling engine

How to display all components polled for each polling engine

Table of contents

Updated: November 3, 2017

Overview

This article describes how to run an SQL query that displays all components polled for each polling engine. This value is usually higher than the licensed component count displayed in the user interface. 

Environment

All SAM versions

Steps

  1. Log in to the Orion Server.
  2. Open Database Manager.
  3. Run the following query:
    SELECT Count(ccs.ApplicationID) Component_Count, e.EngineID, ae.ServerName, ae.ServerType
    FROM [dbo].[APM_CurrentComponentStatus] ccs
    JOIN [APM_Applications] ap ON ccs.ApplicationID = ap.ID
    JOIN [Nodes] node ON ap.NodeID = node.NodeID
    JOIN [Engines] e ON node.EngineID = e.EngineID
    JOIN [AllEngines] ae ON ae.EngineID = e.EngineID
    GROUP BY  e.EngineID, ae.ServerName, ae.ServerType
    ORDER BY Component_Count
    DESC

 

The following example query determines if there are a large number of components in a single monitor type (such as AppInsight monitors): 

SELECT Count(*) AS 'num'
  FROM [APM_CurrentComponentStatus]
WHERE ApplicationID in (select ID from [dbo].[APM_Application]
WHERE Name like '%iis%')
ORDER BY num desc;

 

The following query lists the application IDs that are polling a large number of components: 

SELECT ccs.ApplicationID, ap.Name, Count(ccs.ApplicationID) Component_Count, node.Caption, e.EngineID FROM [dbo].[APM_CurrentComponentStatus] ccs
JOIN [APM_Applications] ap on ccs.ApplicationID = ap.ID
JOIN [Nodes] node on ap.NodeID = node.NodeID
JOIN [Engines] e on node.EngineID = e.EngineID
GROUP BY ap.Name, ccs.ApplicationID, node.Caption, e.EngineID
ORDER BY Component_Count DESC

 

 

Last modified

Tags

Classifications

Public