cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Hertel
Engaged Sweeper
I would like to create a report showing:

IP Location
Operating System
Machine Type
Model
Manufacturer

When adding tsysiplocation it does not relate to the tblcomputers table etc so I can't use it in the report.

I did notice that in the LANSweeper Configuration console, the "Scanned Computers" section shows the IP location in it's table.

How do I show the IP location in a report?

Regards
2 REPLIES 2
Hertel
Engaged Sweeper
That worked, thank you!
Hemoco
Lansweeper Alumni
See this example:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, web40AllIPLocations.IPLocation
From tblComputers Inner Join
web40AllIPLocations On web40AllIPLocations.Computername =
tblComputers.Computername