Add 'IP Location Overview" field to computer report?

[ERoss]

Hi all,

If I am in the report builder - is the "IP Location Overview" field data available for reporting?

Thanks!

[ERoss]

🙂

Thumbs up - many - many thanks 🙂

[mdouglas · Accepted solution]

Try something like this...

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

[ERoss]

Many thanks for quick response,

Perhaps my error - but the output "default.aspx?item=cust&det=web40repComputerByCity&title=Computer%3a+By+City"

Is only showing the IP Location - not computer name?

(I can try my rusty SQL skills at sorting later!)

[mdouglas]

Yes. It's in a view called "web40AllIPLocations"

SELECT Computername, IPLocation FROM web40AllIPLocations