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.

  • 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 available options for yourself.

    Note:  Since it is an out of the box report, try duplicate and edit.

  • I am still looking for help with this report. I tried the suggestion of using the IPAM All Subnets report, but there is no way that I can see to add the name of the Pollin Engine to the report. Furthermore, once I am able to get the polling engine added, I would really like to also show the total number of IP addresses polled by each polling engine. I ultimately need to do some load balancing. Thank you.

  • Try messaging this guy.  I see he has some IPAM reports submitted via content exchange.

  • 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