Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ISA Logs

Author  Topic 

masterzenfoo
Starting Member

1 Post

Posted - 2007-06-05 : 08:23:14
Morning\Afternoon all,

I have a couple of ISA servers and a copy of SQL Express 2005 installed on my machine.

I am trying to play with the ISA logs to glean a bit more info from then rather than using the built in report writer with ISA.

Problem I am having is the ClientIP field is not showing the IP address correctly. The data type of the field is "bigint" and the IP address is displayed as an example: 2886732040

Does anyone know how I can put this number back to an IP address or something a bit more legible????

Thanks in advance!

   

- Advertisement -