Polling Rate Stat Location in Database

Mike_Lomax

Can anyone tell me where in the Orion Database the Polling Rate is stored?

I am getting ready to add quite a few servers and want to create a SAM monitor to track the changes to the Polling Rate as I do.

TIA

sum_giais

Ok so that's not where it's stored - my bad. It's in the EngineProperties table but you'll need to query both tables anyway. Here's the different ways of getting at it and some examples. Note that there are other scale factors in the EngineProperties table -- may make sense to cumulate the results using this query but this should get you started.

# Simple SWQL example
SELECT e.ServerName, e.EngineProperties.PropertyValue AS [PollingRate]
FROM Orion.Engines AS e
WHERE ( e.EngineProperties.PropertyName = 'Orion.Standard.Polling' AND e.EngineProperties.PropertyType = 'Scale Factor' )

# Simple SQL example
SELECT e.ServerName, ep.PropertyValue AS [PollingRate]
FROM SolarWindsOrion.dbo.Engines AS e
INNER JOIN SolarWindsOrion.dbo.EngineProperties AS ep ON ep.EngineID = e.EngineID AND ( ep.PropertyName = 'Orion.Standard.Polling' AND ep.PropertyType = 'Scale Factor' )

# Here's an example of incorporating with a great SWQL query KMSigma wrote up
SELECT CASE
                 WHEN [N].Caption IS NULL THEN [E].ServerName
                 ELSE CONCAT('<a href="', [N].DetailsUrl, '">', [N].[Caption], '</a>')
                END AS [Caption]
              , [E].ServerType
              , [N].DetailsUrl AS [_LinkFor_Caption]
              , ROUND([N].SystemUpTime / 60 / 60 / 24, 2 ) AS [Uptime (Days)]
              , MinuteDiff([E].KeepAlive, GETUTCDATE()) AS [Last Checkin (Minutes)]
              , [E].Elements AS [Monitored Elements]
              , [E].Nodes AS [Monitored Nodes]
              , [E].Interfaces AS [Monitored Interfaces]
              , [E].Volumes AS [Monitored Volumes]
              , [E].Pollers AS [Monitored UnDP]
              -- Comment out the follow line if you don't own SAM
              , [SAM].ComponentCount AS [Monitored Components]
              , [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 [PollingRate]

FROM Orion.Engines AS [E]
INNER JOIN Orion.EngineProperties AS [EP] ON [EP].EngineID = [E].EngineID AND ( [EP].PropertyName = 'Orion.Standard.Polling' AND [EP].PropertyType = 'Scale Factor' )
-- 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
-- Comment out the follow block if you don't own SAM
-- [BEGIN] SAM Information...
INNER 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
ORDER BY [E].ServerType DESC, [N].Caption

https://thwack.solarwinds.com/t5/NPM-Documents/Orion-Polling-Engine-Report/ta-p/538060 - source of the last SWQL query