Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Polling rate% calculation

mnsh_majumder

Is someone aware of the method to find the polling rate%.

Find more posts tagged with

Accepted answers

All comments

jm_sysadmin

My best guess is the number of completed polls is divided by the number of polls that should have been completed.

neomatrix1217

See the article below should give you some insight.

(+) Orion performance best practices - Part 1: monitoring the 10.2 Polling Engine - Product Blog - Resources - THWACK (solarwinds.com)

Optimize polling engines in your Orion Platform deployment (solarwinds.com)

mnsh_majumder

Have already gone through them but just for the update engineproperties table , coln:Orion.Standard.Polling stores the polling rate % value which I was looking for preparing the report.

jpaluch

Add this to "Custom Query" widget - you can cut some Joins as I removed some other info from the query but it should work regardless.

SELECT e.serverName as Node
,ToString(pe.CurrentUsage)+'%' as [Polling rate]
,Case 
        WHEN pe.CurrentUsage > 95 THEN '/Orion/images/StatusIcons/Small-Up-Critical.gif'
        WHEN pe.CurrentUsage > 85 THEN '/Orion/images/StatusIcons/Small-Up-Warn.gif'
    ELSE  '/Orion/images/StatusIcons/Small-Up.gif'
    End as [_IconFor_Polling rate]
FROM Orion.Engines e

JOIN (
    SELECT e.EngineID, count(cp.CustomPollerAssignmentID) AS Pollers
    FROM Orion.NPM.CustomPollerAssignment cp
    JOIN Orion.Nodes n ON cp.NodeID = n.NodeID
    FULL JOIN Orion.Engines e ON e.EngineID = n.EngineID
    GROUP BY e.EngineID
) AS cp ON e.EngineID = cp.EngineID


LEFT OUTER JOIN Orion.Nodes n ON e.ServerName = n.Caption
JOIN Orion.PollingUsage pe on pe.EngineID = e.EngineID

INNER JOIN Orion.EngineProperties AS [EP]  
  ON [E].EngineID = [EP].EngineID  
 AND [EP].PropertyName = 'Total Job Weight'   

-- Comment out the follow block if you don't own SAM    
-- [BEGIN] SAM Information...    
FULL JOIN ( SELECT COUNT([AA].ComponentID) AS ComponentCount    
                  , [N].EngineID    
FROM Orion.APM.Component AS [AA]    
INNER JOIN Orion.APM.Application AS [A]    
   ON [AA].ApplicationID = [A].ApplicationID    
INNER JOIN Orion.Nodes AS [N]    
   ON [A].NodeID = [N].NodeID    
WHERE [AA].Disabled = 'False'    
GROUP BY [N].EngineID ) AS [SAM]    
   ON [SAM].EngineID = [E].EngineID    
-- [END] SAM Information   

where pe.ScaleFactor = 'Orion.Standard.Polling'
order by e.serverName ASC

mnsh_majumder

I don't see Orion.PollingUsage table exist in SolarWind DB.

mnsh_majumder

Have modified & used below query to get me the report.

------------------------POLLING STATUS WITHOUT SAM------------------------------
SELECT DISTINCT [E].ServerName AS [Server Name]
, [E].ServerType
, ROUND([N].SystemUpTime / 60 / 60 / 24, 0) AS [Uptime (Days)]
, [E].Elements AS [Monitored Elements]
, [E].Nodes AS [Monitored Nodes]
, [E].Interfaces AS [Monitored Interfaces]
, [E].Volumes AS [Monitored Volumes]
, [E].EngineVersion
, CONCAT([E].WindowsVersion, '/', [E].ServicePack ) AS [OS/SP]
, [N].CPULoad AS [CPU %]
, [N].PercentMemoryUsed AS [Mem %]
, [E].PollingCompletion AS [Polling Completion %]
,[EP].PROPERTYVALUE AS [Polling Rate %]
, [N].STATUSDESCRIPTION
FROM Orion.Engines AS [E]
-- Use of LEFT JOIN so that we can show Engines even if we aren't monitoring them... but we should be monitoring them
LEFT JOIN Orion.Nodes AS [N]
ON [E].IP = [N].IP_Address
left JOIN Orion.EngineProperties AS [EP] ON [E].ENGINEID=[EP].ENGINEID
and [EP].PROPERTYNAME='Orion.Standard.Polling'
---------------------------SERVER STATUS------------------------------------
SELECT
[N].CAPTION
, [N].DNS
, [N].SYSNAME
, [N].IP_ADDRESS
, [N].STATUSDESCRIPTION
, ROUND([N].SystemUpTime / 60 / 60 / 24, 0) AS [Uptime (Days)]
, [N].CPULoad AS [CPU %]
, [N].PercentMemoryUsed AS [Mem %]
, [N].TOTALMEMORY AS [TOTAL MEMORY (IN mb)]
, [N].MEMORYUSED
, [N].MACHINETYPE
, [N].LASTBOOT
, [N].LASTSYSTEMUPTIMEPOLLUTC
, [N].LASTSYNC
FROM Orion.Nodes AS [N]
WHERE [N].caption like'%ENTER_YOUR_SOLARWIND_SERVER_NAME%'

jpaluch

I see it in SWQL studio:

Anyway, glad it worked out for you

KMSigma.SWI

@jpaluch - you should totally share this in Custom Queries - The Orion Platform - THWACK (solarwinds.com)