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):
1. I created a table in the Orion database with columns for the data that I wanted to track (I used keepalive for time):
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.
While the charts I showed above are for completion percentage only, any of the columns gathered from Engines can be plotted.