You can use this to get one IP Address for the server, create a stored procedure out of it or use it with CMS to get all server IP Addresses.
Map IP Address to a Geographical Location
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
2012-07-20 (first published: 2009-07-09)
52,606 reads