RE: SQL Import Scripts for ISA Logs
- From: Jim Harrison <jim@xxxxxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Thu, 09 Oct 2003 05:41:21 -0700
Oh, yeah...
There's a picture I need...
Thanks, Bill.
BTW, how's the solution working out?
Jim Harrison
MCP(NT4, W2K), A+, Network+, PCG
http://isaserver.org/Jim_Harrison/
http://isatools.org
Read the help / books / articles!
On Thu, 9 Oct 2003 09:59:09 +0200
"William Robertson" <robertson.william@xxxxxxxxxxxxxx> wrote:
http://www.ISAserver.org
It's such a pity you can't see me salivating at my desk right now, I'm sure
it would make you realise the effort you're putting in is so absolutely
appreciated!!!!
-----Original Message-----
From: cismic [mailto:cismic@xxxxxxx]
Sent: 09 October 2003 07:43 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: SQL Import Scripts for ISA Logs
http://www.ISAserver.org
Hi All,
To start there will be 4 scripts.
1. Moves the log files to your log file processor machine if you have
one. Or you can just move them to
a secure folder on ISA machine and process them as InQueue/OutQueue.
Also have updated this to show
how to use the command line scheduling to run the move script at a
given time.
2. (WEB) Sql to create the table to contain the data, stored procedure
that is called from script and the script to import Web Proxy into the
table. I import raw data and haven't thought about parsing as the data
is imported. I use other stored procedures to parse out information.
i.e. browser type, 200's, 404's, 304's etc.
3. (PACKET) Sql to create the table to contain data and the stored
procedure that is called to import the Packet log file.
I'm almost done with the sql hex conversion feature so you can at least
try and tell what was in a packet.
4. (FIREWALL) Sql to create the table to contain data and the stored
procedure that is called to import the Packet log file.
These can be on internal and external isa machines, since the machine
names and log file names are included in the table so you can determine
by day and log what is going on.
Joseph
-----Original Message-----
From: Jim Harrison [mailto:jim@xxxxxxxxxxxx]
Sent: Wednesday, October 08, 2003 7:10 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: SQL Import Scripts for ISA Logs
http://www.ISAserver.org
As soon as Joe gets them to me, I'll post them on isatools.org and blast
the world as I always do for new content.
Jim Harrison
MCP(NT4, W2K), A+, Network+, PCG http://www.microsoft.com/isaserver
http://isaserver.org/Jim_Harrison
http://isatools.org
Read the help, books and articles!
----- Original Message -----
From: "Bakari Allen" <ballen@xxxxxxxxx>
To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
Sent: Wednesday, October 08, 2003 09:11
Subject: [isalist] RE: SQL Import Scripts for ISA Logs
http://www.ISAserver.org
Would it be possible for other minions to get their grimy hands on this
magic script? I used to log directly to my SQL server, but it screwed up
the ISA reports (i.e., they stopped!!) so I returned to log files for
the ISA reports, but I prefer to do my ad-hoc reports from the DB.
Thanks,
Bakari Allen
bakari.allen@xxxxxxxxx
-----Original Message-----
From: cismic [mailto:cismic@xxxxxxx]
Sent: Wednesday, October 08, 2003 7:11 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: SQL Import Scripts for ISA Logs
http://www.ISAserver.org
Hi William,
Yes, I have them all complete. I'll zip them up and get out to Jim. I
will also, Get them out to you for testing and for your valuable
feedback.
Thanks for reminding me! I keep taking on 90 hour week projects and it
never leaves me Time for the fun stuff!
Joseph
-----Original Message-----
From: William Robertson [mailto:robertson.william@xxxxxxxxxxxxxx]
Sent: Wednesday, October 08, 2003 12:01 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] SQL Import Scripts for ISA Logs
http://www.ISAserver.org
Hi Joseph (aka cismic)
Just posting my little reminder to ask if you've had a chance to
complete the SQL & VB Scripts to import the ISA Logs into a SQL
database. As you may recall I have had enormous difficulty with doing
this myself and am thus eagerly awaiting your solution.
Cheers
William R.
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com No.1
Exchange Server Resource Site: http://www.msexchange.org Windows
Security Resource Site: http://www.windowsecurity.com/ Network Security
Library: http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
cismic@xxxxxxx To unsubscribe send a blank email to
$subst('Email.Unsub')
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com No.1
Exchange Server Resource Site: http://www.msexchange.org Windows
Security Resource Site: http://www.windowsecurity.com/ Network Security
Library: http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
bakari.allen@xxxxxxxxx To unsubscribe send a blank email to
$subst('Email.Unsub')
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com No.1
Exchange Server Resource Site: http://www.msexchange.org Windows
Security Resource Site: http://www.windowsecurity.com/ Network Security
Library: http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
jim@xxxxxxxxxxxx To unsubscribe send a blank email to
$subst('Email.Unsub')
^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*
All mail from this domain is virus-scanned with RAV.
www.ravantivirus.com
^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com No.1
Exchange Server Resource Site: http://www.msexchange.org Windows
Security Resource Site: http://www.windowsecurity.com/ Network Security
Library: http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
cismic@xxxxxxx To unsubscribe send a blank email to
$subst('Email.Unsub')
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
robertson.william@xxxxxxxxxxxxxx
To unsubscribe send a blank email to $subst('Email.Unsub')
---------------------------------------------------------------------
Everything in this e-mail and attachments relating to the official
business of Columbus Stainless is proprietary to the company. It is
confidential, legally privileged and protected by law. Columbus
Stainless does not own and endorse any other content. Views and
opinions are those of the sender unless clearly stated as being that
of Columbus Stainless. The person addressed in the e-mail is the sole
authorised recipient. Please notify the sender immediately if it has
unintentionally reached you and do not read, disclose or use the
content in any way. Whilst all reasonable steps are taken to ensure
the accuracy and integrity of information and data transmitted
electronically and to preserve the confidentiality thereof, no
liability or responsibility whatsoever is accepted if information or
data is,for whatever reason, corrupted or does not reach its intended
destination.
---------------------------------------------------------------------
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
jim@xxxxxxxxxxxx
To unsubscribe send a blank email to $subst('Email.Unsub')
^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*
All mail from this domain is virus-scanned with RAV.
www.ravantivirus.com
^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*^*
Other related posts:
