RE: ISA report
- From: "William Robertson" <william.robertson@xxxxxxxxx>
- To: "'[ISAserver.org Discussion List]'" <isalist@xxxxxxxxxxxxx>
- Date: Wed, 22 Jan 2003 07:24:28 +0200
Hi guys
Surely if you want to concat numerous logfiles to be able to import into
Excel, you must take into account the fact that Excel can only handle
65535 rows, and in my scenario this is a very limiting factor.
Cheers
William R.
-----Original Message-----
From: CISMIC [mailto:cismic@xxxxxxx]
Sent: 01 January 1988 06:22 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA report
http://www.ISAserver.org
Hi Thomas,
You can do the merge into one excell file if you want. I've not seen a
reason for this as of yet. For example WebProxy; fields 1 - 10, packet
filter; fields 11 - 15 etc.
So with that in mind using the filesystemobject you could read in two
text
files, do a merge of he files and output into a 3rd text file as a *.csv
that could be opened in excell.
the field headings are different for the different types of files.
WebProxy,
PacketFilter, Firewall. You can also merge the webproxy logs from
different
servers into one file after the comments have been stripped out "#".
Let me know some more specifics and I can give you more detailed
examples.
Joseph
-----Original Message-----
From: Thomas W Shinder [mailto:tshinder@xxxxxxxxxxxxxxxxxx]
Sent: Wednesday, January 22, 2003 2:05 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA report
http://www.ISAserver.org
Hi Joseph,
Very good. I am still curious if there is a way to conglomerate at
series of
text files into a single text file and then important that into
something
like Excel or Access. I've never tried it but figured there might be a
way
to do this.
Thanks!
Tom
www.isaserver.org/shinder
-----Original Message-----
From: CISMIC [mailto:cismic@xxxxxxx]
Sent: Thursday, December 31, 1987 9:50 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA report
http://www.ISAserver.org
I have scripts to import from WebProxy, Packet Filter and Firewall into
an
sql database.
I'll add some additional documentation later and get them out to
everyone
who is interested.
I think I have the WebProxy script, table layout and import sql script
on
Jimmy's site.
Joseph
-----Original Message-----
From: Thomas W Shinder [mailto:tshinder@xxxxxxxxxxxxxxxxxx]
Sent: Wednesday, January 22, 2003 1:46 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA report
http://www.ISAserver.org
Hi Shawn,
Any tips on how to easily concatenate txt files? That would make it
easier
to import into Excel or Access.
Thanks!
Tom
www.isaserver.org/shinder
-----Original Message-----
From: Quillman Shawn (RBNA/CIT1.1) [mailto:Shawn.Quillman@xxxxxxxxxxxx]
Sent: Tuesday, January 21, 2003 9:23 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA report
http://www.ISAserver.org
>From a simplistic side of things, if they're not too large import your
logs
into Excel and remove the columns you don't need.
-----
Shawn R. Quillman
Robert Bosch Corporation RBNA/CIT1.1
38000 Hills Tech Drive
Farmington Hills, MI 48331
(248) 553-1164 (P) (248) 848-2855 (F)
shawn.quillman@xxxxxxxxxxxx
-----Original Message-----
From: Samer Awad [mailto:samera@xxxxxxxxxxxxxxx]
Sent: Tuesday, January 21, 2003 10:10 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA report
http://www.ISAserver.org
Dear William, thanks a lot for your reply ,but the problem is that our
customer is not going to buy any additional tool ,and he is convinced
that if he can not get a report that it doesn't contains details about
each user in the company and what website had accessed in the last
month so it is worthless. I have installed the webmonitor tool on the
ISA server, it is very excelent it shows you each user and what is the
website that he is accessing but in real time monitoring and you cannot
log them to a database.
Best Regards William
Samer Awad
MCSA,MCSE,CCA .
Engineering dept, Soft Flow.
Tel/fax: 961-1-887957 .
P.O.Box:90200-jdeidet el metn Beirut Lebanon .
E-mail:samera@xxxxxxxxxxxxxxx
URL: http//www.softflow.com.lb
-----Original Message-----
From: William Robertson [mailto:william.robertson@xxxxxxxxx]
Sent: Tuesday, January 21, 2003 12:59 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA report
http://www.ISAserver.org
Hi Samer
I do believe that what you are asking is not generically available
within ISA Server. You have 1 of 2 options:
Option1:
Dump your ISA Server logs to a SQL Database and write your own SQL
Queries to give you this information.
Option2:
Purchase a tool such as GFI Languard, Surfcontrol WEB Filter etc which
will in fact include many reports which I am quite sure will be able to
satisfy your request.
Cheers
William R.
-----Original Message-----
From: Samer Awad [mailto:samera@xxxxxxxxxxxxxxx]
Sent: 21 January 2003 10:05 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] ISA report
Dears, all we need from ISA server is to generate a report showing us
all the usernames and all the websites that each user has accessed
during one month that means on each line the name of the user and what
website had accessed ,so if anyone have an idea ,please reply and thanks
in advance.
Samer Awad
MCSA,MCSE,CCA .
Engineering dept, Soft Flow.
Tel/fax: 961-1-887957 .
P.O.Box:90200-jdeidet el metn Beirut Lebanon .
E-mail:samera@xxxxxxxxxxxxxxx
URL: http//www.softflow.com.lb
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=3Disalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=3DFAQ
------------------------------------------------------
Exchange Server Resource Site: http://www.msexchange.org/
Windows Security Resource Site: http://www.windowsecurity.com/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
samera@xxxxxxxxxxxxxxx
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
------------------------------------------------------
Exchange Server Resource Site: http://www.msexchange.org/
Windows Security Resource Site: http://www.windowsecurity.com/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
shawn.quillman@xxxxxxxxxxxx
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
------------------------------------------------------
Exchange Server Resource Site: http://www.msexchange.org/
Windows Security Resource Site: http://www.windowsecurity.com/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
tshinder@xxxxxxxxxxxxxxxxxx
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
------------------------------------------------------
Exchange Server Resource Site: http://www.msexchange.org/
Windows Security Resource Site: http://www.windowsecurity.com/
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
------------------------------------------------------
Exchange Server Resource Site: http://www.msexchange.org/
Windows Security Resource Site: http://www.windowsecurity.com/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
tshinder@xxxxxxxxxxxxxxxxxx
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
------------------------------------------------------
Exchange Server Resource Site: http://www.msexchange.org/
Windows Security Resource Site: http://www.windowsecurity.com/
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
------------------------------------------------------
Exchange Server Resource Site: http://www.msexchange.org/
Windows Security Resource Site: http://www.windowsecurity.com/
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')
Other related posts:
