Adding IP Locations not working properly.

[gnohs]

I tried to edit the Printer toner level low report. And I added the tsysIPLocations Table and selected IPLocation. When I run this report now its all messed up. I have 2 IP locations. Now each printer is showing in both IP Locations while this is not true. I only have the Printer in only the one location.

So now it looks like this:

BH4750-899F22 KONICA MINOLTA bizhub 4750 7 20000 Black Toner 07/10/2015 12:07:06 A6F7011003934 Borax Paper Borax Paper
BH4750-899F22 KONICA MINOLTA bizhub 4750 7 20000 Black Toner 07/10/2015 12:07:06 A6F7011003934 Msedp Network Msedp Network
NPI7C3BC3 HP LaserJet P2035n 10 2674058 Black Cartridge 07/13/2015 12:08:08 CNB9S63653 Borax Paper Borax Paper
NPI7C3BC3 HP LaserJet P2035n 10 2674058 Black Cartridge 07/13/2015 12:08:08 CNB9S63653 Msedp Network Msedp Network

Notice how its duplicated.

Where if I highlight the printer link the location states only borax paper.

[Daniel_B · Accepted solution]

This forum page describes how to add the IP location to a report. You need to manually create the join between tblAssets.IPNumeric and the combination of tsysIPlocations.StartIP and tsysIPlocations.EndIP.

If you did this and you still are having duplicates, likely the IP ranges of your IP locations are overlapping each other. Under Configuration\Asset groups, section IP address range locations, you need to ensure that one IP only is part of one IP location.