Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

IPAM Report Sorting/Grouping by Network

Hello,

After a support request (909515) and post here - Web Report - Address Sort Key on IPAM 4.3 can I raise a feature request to get the web reporting ordered by IP Address and grouping like the nested tree view of the web console?

Thanks,

Peter

Find more posts tagged with

Status: None

Comments

PeterLyttle

I've written a brief SQL query to try and help with this but for some reason the IPAM Web Reporter decides it wants to error with the query (it runs in SQL Management Studio ok). Please note I have a Custom Field called "Environment". any IPAM/SQL guru's have any suggestions?

WITH Tiering(ParentId, GroupId)
AS(
    SELECT LG.ParentId, LG.GroupId
        FROM dbo.IPAM_Group AS LG
        WHERE LG.GroupId NOT IN (
SELECT COALESCE(LG.ParentId, 0) FROM dbo.IPAM_Group AS IG)
    UNION ALL
    SELECT PG.ParentId, PG.GroupId
        FROM dbo.IPAM_Group AS PG
        INNER JOIN Tiering AS C
ON PG.GroupId = C.ParentId
)
SELECT G.Location, GA.Environment, G.FriendlyName, G.Address, G.CIDR, G.VLAN
FROM Tiering AS T
JOIN dbo.IPAM_Group AS G
ON G.GroupId = T.GroupID
JOIN dbo.IPAM_GroupAttrData AS GA
ON GA.GroupID = G.GroupID
GROUP BY G.Location, GA.Environment, G.FriendlyName, G.Address, G.CIDR, G.VLAN
OPTION(MAXRECURSION 32767)