Need a report showing subnet polling engine assignments

I am ultimately wanting to load balance my IPAM polling, but first I need a simple report showing (a) which polling engine a subnet is assigned to, and then also (b) that number of total and used IPs that each polling engine is currently polling. Can anyone help? Appreciate it.

Top Replies

donrobert5 11 months ago +8 suggested

I feel this is somewhat easy to accomplish. However, I no longer have a Solarwinds Environment so I can't help out. I will start editing the out of the box report called "IPAM All subnets" and check all…
donrobert5 8 months ago in reply to borgan +8 suggested

Try messaging this guy. I see he has some IPAM reports submitted via content exchange.
chad.every 8 months ago +1

If you build an advanced SWQL report you could try the following query. I joined the IPAM.GroupReport table with the Orion.Engines table so you can see the polling engine name too instead of only the engineID…

Parents

0 chad.every 8 months ago

If you build an advanced SWQL report you could try the following query. I joined the IPAM.GroupReport table with the Orion.Engines table so you can see the polling engine name too instead of only the engineID.

SELECT 
 i.FriendlyName
,i.Address
,i.CIDR
,i.ScanInterval
,i.PercentUsed
,i.UsedCount
,i.AvailableCount
,i.ReservedCount
,i.TransientCount
,i.DisableAutoScanning
,i.StatusName
,e.ServerName AS [AssignedPollingEngine]
,i.EngineId AS [PollingEngineID]
FROM IPAM.GroupReport i
JOIN (SELECT EngineID, ServerName FROM Orion.Engines) e ON e.EngineID = i.EngineId
WHERE GroupType = 8

Here is another similar query to above, but aggregated to show 'load' per polling engine

SELECT 
 e.ServerName AS [AssignedPollingEngine]
,i.EngineId AS [PollingEngineID]
,COUNT(DISTINCT i.Address) AS [TotalSubnetCount]
,SUM(i.UsedCount) AS [TotalIPUsedCount]
,SUM(i.AvailableCount) AS [TotalIPAvailableCount]
FROM IPAM.GroupReport i
JOIN (SELECT EngineID, ServerName FROM Orion.Engines) e ON e.EngineID = i.EngineId
WHERE GroupType = 8
GROUP BY e.ServerName,i.EngineId

Reply

0 chad.every 8 months ago

SELECT 
 i.FriendlyName
,i.Address
,i.CIDR
,i.ScanInterval
,i.PercentUsed
,i.UsedCount
,i.AvailableCount
,i.ReservedCount
,i.TransientCount
,i.DisableAutoScanning
,i.StatusName
,e.ServerName AS [AssignedPollingEngine]
,i.EngineId AS [PollingEngineID]
FROM IPAM.GroupReport i
JOIN (SELECT EngineID, ServerName FROM Orion.Engines) e ON e.EngineID = i.EngineId
WHERE GroupType = 8

Here is another similar query to above, but aggregated to show 'load' per polling engine

SELECT 
 e.ServerName AS [AssignedPollingEngine]
,i.EngineId AS [PollingEngineID]
,COUNT(DISTINCT i.Address) AS [TotalSubnetCount]
,SUM(i.UsedCount) AS [TotalIPUsedCount]
,SUM(i.AvailableCount) AS [TotalIPAvailableCount]
FROM IPAM.GroupReport i
JOIN (SELECT EngineID, ServerName FROM Orion.Engines) e ON e.EngineID = i.EngineId
WHERE GroupType = 8
GROUP BY e.ServerName,i.EngineId

Children

No Data