How do I add IP location into a report?

[Hertel]

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

[Hertel]

That worked, thank you!

[Hemoco]

See this example:

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