Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper II
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.
Lansweeper Employee
Lansweeper Employee
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:

The example will show all assets in the - IP range

Where tblAssets.IPNumeric
Between 192168001001 And 192168001050