I need to write a number of reports/cubes using the ISA log as the main source of data.
Unfortunately the ISA log only contains the IP address of the client computer and not it's name.
In order to determine the computer's name I (think) I need to read the DNS using the ip address as a key or search argument.
Does anyone know if this is possible or an easy way to determine a computers name from its IP address?
Ideally I woulld like to issue a query from an sql server stored procedure, but failing that a vb.net program.
Thanks in advance