RE: ISA report
- From: "Quillman Shawn (RBNA/CIT1.1)" <Shawn.Quillman@xxxxxxxxxxxx>
- To: "'[ISAserver.org Discussion List]'" <isalist@xxxxxxxxxxxxx>
- Date: Wed, 22 Jan 2003 07:28:57 -0500
Easiest thing I can think of is to drag all the files you want to copy into
a folder, open a command prompt to that folder then do a 'type *.log >>
biglog.txt'. This whole Excel idea, of course, is only if your logs aren't
that huge which I know is certainly not the case for most of us...
-Shawn
-----
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: Thomas W Shinder [mailto:tshinder@xxxxxxxxxxxxxxxxxx]
Sent: Tuesday, January 21, 2003 7:05 PM
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:
shawn.quillman@xxxxxxxxxxxx
To unsubscribe send a blank email to $subst('Email.Unsub')
Other related posts:
