Whaddaya thanking Jim for? He didn't do anything but send you to some other
dude! I see how you are ;)
t
http://www.ISAserver.org
Thanks Jim... and Tim.. Although I never got your email? Why I dunno, lost in transit..
SQL does seem like the way to go the more I get into it.. And the realtime alerts is what im after, plus the ability to be able to pull data chunks would be a boneless!
I'll hit you up later for some more info as im a fair sql spaz. Now seems like a good time to learn though.
Thanks
Greg
-----Original Message----- From: Jim Harrison [mailto:Jim@xxxxxxxxxxxx] Sent: Friday, April 15, 2005 11:58 PM To: [ISAserver.org Discussion List] Subject: [isalist] Re: Querying logs
http://www.ISAserver.org
You guys Might just want to hook up with Joeseph. He wrote some nifty text-to-SQL tools for ISA 2000 logging.
-----Original Message----- From: Thor (Hammer of God) [mailto:thor@xxxxxxxxxxxxxxx] Sent: Friday, April 15, 2005 1:30 AM To: [ISAserver.org Discussion List] Subject: [isalist] Re: Querying logs
http://www.ISAserver.org
Eyeing Jim, huh? I won't worry until you start playing Gordon Lightfoot
songs for him ;)
Though the db route seems like a "last resort" to you, there is some cool stuff you can do if you decide to go there... If you log to SQL, not only do you get rich data gathering and analysis capabilities for reporting, you can also take advantage of somewhat real-time procedure execution in a more robust environment... For instance, a "run while idle" job can easily aggregate log data in pseudo-real-time to launch email/pager/etc alerts, or execute "rule injection" scripts back to the ISA server that are suited to your needs. (Note that "run while idle" requires the MSSQL service to be running as a local admin, so secure that box well if you use RWI as opposed to something that runs every few minutes or so...)
I've been planning to implement something like this for 2k4 as I used to do with 2k when I get some free (HA!) time... But let me know if you'd like
some help with the SQL end of things. I've messed with SQL once or twice ;)
t
----- Original Message ----- From: "Greg Mulholland" <greg@xxxxxxxxxxxxxx> To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx> Sent: Friday, April 15, 2005 12:48 AM Subject: [isalist] Querying logs
http://www.ISAserver.org
Im looking for something that allows me to be alerted when I get a scan or connection fail/attempt from a particular ip (one I would like to specify).
I would like to be able to do it through the alerts stuff but it doesn't allow it. I have thought of logging to a database and writing a query that pulls that info and mails me when it happens, but that is somewhere I will only go if I really need to..
I'm eyeing Jim here with the possibility that a script can do it, but im not sure..
Any suggestions..
G
------------------------------------------------------ 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: World of Windows Networking: http://www.windowsnetworking.com 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: thor@xxxxxxxxxxxxxxx To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist Report abuse to listadmin@xxxxxxxxxxxxx
------------------------------------------------------ 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: World of Windows Networking: http://www.windowsnetworking.com 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 visit http://www.webelists.com/cgi/lyris.pl?enter=isalist Report abuse to listadmin@xxxxxxxxxxxxx
All mail to and from this domain is GFI-scanned.
------------------------------------------------------ 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: World of Windows Networking: http://www.windowsnetworking.com 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: greg@xxxxxxxxxxxxxx To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist Report abuse to listadmin@xxxxxxxxxxxxx