This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Historical Data for Polling Engine Statistics

Recently I have found it frustrating that there were no historical statistics for polling engine performance. Sure, you can see the current information for them in the Engines table, but no historical data for that information was available.

Yesterday I found a solution to this and added it to my custom admin page.

Available static data in the Engines table (also found in your Polling Engines link in Settings in NPM):

pastedImage_0.png

pastedImage_1.png

1. I created a table in the Orion database with columns for the data that I wanted to track (I used keepalive for time):

          pastedImage_5.png

2. I created a query to insert into this table the data for each of those columns, from Engines.

INSERT INTO [Pollng_Engine_Performance] ([ServerName], [IP_Address], [ServerType], [Elements], [Nodes], [Interfaces], [Volumes], [WindowsVersion], [PollingCompletionPercent], [Keepalive])

SELECT [ServerName], [IP] as [IP_Address], [ServerType], [Elements], [Nodes], [Interfaces], [Volumes]

,[WindowsVersion], [PollingCompletion], [KeepAlive]

FROM [SolarWindsOrion].[dbo].[Engines]

3. I created a job in SQL to perform this query every 5 minutes.

4.  Then I created a custom chart on the page where I wanted to display this information and use SQL from the newly created table for the source.  I have a 2 polling engines where I'm having issues with polling completion percentage, so I created a table for that for all APEs. Then a separate one for each of the polling engines I am having issues with.

pastedImage_6.png

pastedImage_7.png

While the charts I showed above are for completion percentage only, any of the columns gathered from Engines can be plotted.