<div>
Are you trying to interrogate the database directly or viewing through the ISA screen in monitoring - logging and monitoring - reports
</div>


Are you trying to interrogate the database directly or viewing through the ISA screen in monitoring - logging and monitoring - reports

<div>
This is directly from the DB.
</div>


<div>
Thought so - there is nothing to fix - that is the way ISA stores its information. The translation is performed by the realtime log monitor, the historic logging view and the reporting module. 
</div>


Thought so - there is nothing to fix - that is the way ISA stores its information. The translation is performed by the realtime log monitor, the historic logging view and the reporting module.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I'm logging to a SQL database in ISA.<br />
Only the IP's in the column are showing up as ints i.e. 'SourceIP' = 3232238700<br />
and 'DestinationIP' = 1113983331.<br />
Should it now be something like 192.168.20.xxx or something similar.<br />
Where did I go wrong, I also see that the script coming with ISA to create the DB creates the column as bigint ' [SourceIP] bigint,'<br />
How can I correct this ?
</div>
</div>


Hi,
I'm logging to a SQL database in ISA.
Only the IP's in the column are showing up as ints i.e. 'SourceIP' = 3232238700
and 'DestinationIP' = 1113983331.
Should it now be something like 192.168.20.xxx or something similar.
Where did I go wrong, I also see that the script coming with ISA to create the DB creates the column as bigint ' [SourceIP] bigint,'
How can I correct this ?

ISA SQL logging SourceIP

Microsoft Forefront, formerly known as Internet Security and Acceleration Server (ISA Server), is a network router, firewall, antivirus program, VPN server and web cache that runs on Windows servers. It includes identity management and protection systems, and discontinued systems for threat management and network protection, along with protection for Sharepoint and Exchange. The scope of discussions includes forward and reverse proxy, application and service publishing, virtual private networks (VPNs), outbound access rules, SSL certificates and network routing within either a single node or an highly-available array pairing.