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')