Exclude or Include IP blocks in Report

[ddarlage]

So what I am wanting to do is either only include a few IP blocks in a report or exclude IP blocks from a report.

I have an automated report I want emailed out however, I do not want all the information from the current report to go to the team. Just different IP blocks that those teams own.

[Esben_D]

You can use the BETWEEN operator in the where condition of your report. Do note you will have to use the tblAssets.IPNumeric table and write the IP addresses in full without dots as shown below. You can find more information about the BETWEEN operator here: https://www.w3schools.com/sql/sql_between.asp

The example will show all assets in the 192.168.1.1 - 192.168.1.50 IP range

Where tblAssets.IPNumeric
  Between 192168001001 And 192168001050