→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sunglee
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

3 REPLIES 3
sunglee
Engaged Sweeper
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
Lansweeper Alumni
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
Lansweeper Alumni
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