cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 12

Total Number of Components Per Engine

Jump to solution

I'm working on a method to do some dynamic balancing of my APES. I'm wondering where I can get the total number of components per APE. This Page  "...Orion/Admin/Details/ElementsStat.aspx" provides a lot of good data but I need to be able to pull this via SWIS or SQL. Pollers have limits based on the various modules. Does anyone have have the queries used in this or know what table/view I can query?

0 Kudos
1 Solution

Accepted Solutions
Highlighted

Re: Total Number of Components Per Engine

Jump to solution

Hi,

The following base query will show you how many enabled component monitors are assigned to each polling engine:

SELECT COUNT(*) AS Monitors, c.Application.Node.Engine.ServerName
FROM Orion.APM.Component c
WHERE Status = 1
Group BY c.Application.Node.Engine.ServerName

 

View solution in original post

3 Replies
Highlighted

Re: Total Number of Components Per Engine

Jump to solution

Hi,

The following base query will show you how many enabled component monitors are assigned to each polling engine:

SELECT COUNT(*) AS Monitors, c.Application.Node.Engine.ServerName
FROM Orion.APM.Component c
WHERE Status = 1
Group BY c.Application.Node.Engine.ServerName

 

View solution in original post

Highlighted
Level 12

Re: Total Number of Components Per Engine

Jump to solution

Just curious if you have the SQL for this as well?

0 Kudos
Highlighted
Level 12

Re: Total Number of Components Per Engine

Jump to solution

Got this from support

SELECT e.EngineID, Count(ccs.ApplicationID) as Components
FROM [dbo].[APM_CurrentComponentStatus] ccs
JOIN [APM_Application] ap ON ccs.ApplicationID = ap.ID
JOIN [Nodesdata] node ON ap.NodeID = node.NodeID
JOIN [Engines] e ON node.EngineID = e.EngineID
JOIN [Engines] ae ON ae.EngineID = e.EngineID
GROUP BY e.EngineID

0 Kudos