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

Problem with Report Filters

I'm trying to produce a report that only includes devices within a specific IP address range, so I've included two filter entries that are looking for "IP Addresses is greater than 10.10.128.0" and then a second entry looking for "IP Address is less than 10.10.159.255".

When I run this, I get every on our network, even those outside this IP range. Am I doing something wrong or will this filter just not work for IP addresses.

Thanks

Find more posts tagged with

Accepted answers

All comments

Network_Guru

You most likely need a custom SQL query to do this. You're better off to use a custom property as the filter for this report. If the devices are all in the same area or department, then filter on that. You can create a custom property that you can enter data to filter these devices. I use Province, City, Department(owner), contact, device-type, service-provider, etc. which works very well for filtering.

-=Cheers=-
NG

DonYonce

dsullinger,
The Filters in Report Writer are generating SQL statements, therefore the comparison is an ASCII comparison, not a numeric IP Address comparison.

For example, if we use greater than "10.0.0.1" and less than "10.0.0.200", the IP Address "10.0.0.4" would NOT fall within this range using an ASCII comparison. (because the ascii "4" is greater than the ascii "2").

Depending on the IP Address range you are trying to filter, your query may work. ( I would need to see the report to be sure ). Also, within Report Writer, be sure the line above the two filters says "Select records where ALL of the following apply" instead of "Select records where ANY of the folloing apply".

A better method would be to use add a Custom Property to the Nodes and then filter on it. For example, add a custom property named "Department" using the "Custom Property Editor". Then assign each Node a department. Now within Report Writer you can use the new Custom Property to filter reports.

Don

bleearg13

Yes, the problem with your query is that while the IP addresses themselves are integers, the MS SQL database does not understand the format of the IP address. It sees the IPs as just an alphanumeric string, not 4 octets of integers. The best way to do your query is to add a custom property as NG states above.

dsullinger

Rats...