Getting back to default ip report

[sunglee]

Hello,
I must have changed something in the IP Location: IP Address List, because when I go to load it now, it actually repeats the list several times, resulting in a gigantic list that takes a long time to load and experiences several timeouts. Does anybody know the default settings for this report? I want to use this report because we have different devices and machines, and some of them have multiple IP addresses, and this report seemed to have a comprehensive list of all the IPs in use.

[sunglee]

Thanks, worked a charm! Another question, is it possible to include all IPs in the report? Some machines have 2 or 3 IPs set, but the report doesn't include these? It only shows 1 IP?

[Hemoco]

sunglee wrote:
Thanks, worked a charm! Another question, is it possible to include all IPs in the report? Some machines have 2 or 3 IPs set, but the report doesn't include these? It only shows 1 IP?

You will need to create a report for this based on table "tblNetwork".

[Hemoco · Accepted solution]

You can recreate this report using the information below.


View name:
IPLocationlist


Report name:
IP Location: IP Address list


SQL code:

Select Top 1000000 DERIVEDTBL.icon, DERIVEDTBL.Name As Sysname, DERIVEDTBL.IP, DERIVEDTBL.IPLocation, DERIVEDTBL.Type, DERIVEDTBL.Domain, DERIVEDTBL.Lastseen, DERIVEDTBL.computername From (Select Web40OSName.Compimage As icon, tblComputers.LastknownIP As IP, web40AllIPLocations.IPLocation As IPLocation, tblComputers.Computer As Name, Web40OSName.OSname As Type, tblComputers.Lastseen, tblComputers.IPNumeric, Cast(tblComputers.Computername As varchar) As computername, tblComputers.Domain From tblComputers Inner Join web40AllIPLocations On tblComputers.Computername = web40AllIPLocations.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On tblComputers.Computername = Web40OSName.Computername Union Select tsysDevicetypes.ItemTypeIcon10 As icon, tblCustDevices.Ipaddress As IP, web40AllIPLocationsDev.IPLocation As IPLocation, tblCustDevices.Displayname As Name, tsysDevicetypes.ItemTypename As Type, tblCustDevices.LastSeen, tblCustDevices.IPNumeric, tblCustDevices.DeviceKey As computername, '' As domain From tsysDevicetypes Inner Join tblCustDevices On tsysDevicetypes.ItemType = tblCustDevices.Devicetype Inner Join web40AllIPLocationsDev On tblCustDevices.DeviceKey = web40AllIPLocationsDev.DeviceKey Where tblCustDevices.State = 1) DERIVEDTBL Order By IPNumeric