Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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: December 18, 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