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

IP Address Group Report

Anyone know how to create a report to list all Netflow IP Address Groups and their IP's? Normally I would just copy the info from the page and paste in Excel but I have IP ranges specified as well.

I have 300+ groups and wanted to verify that I don't have the same IP in two different groups. If not, this will be a manual process which will take a lot of time.

Thanks

Find more posts tagged with

Accepted answers

All comments

jswan

Try putting this query in a custom report. I think this is what you want:

SELECT g.name,r.low,r.high FROM netflowipgroups g,netflowipgroupranges r

WHERE g.ipgroupid = r.ipgroupid

ORDER by g.name

sachsj

The 3 fields that are returned are:

Event Type Name - This seems to be correct

Low - gives me a single number, something like 10001001108

High - gives me a single number, something like 10001001109

jswan

The single numbers are 12-digit zero-padded versions of the IPv4 address:

10.1.1.108

10.1.1.109

You'll need to 1) reformat them with SQL, which is beyond me, 2) post-process them with other tools (I use Python for this kind of thing), or 3) train your eyes to read that format.

sachsj

Ah! Gotcha. Thanks