RE: Special SQL-Select from Logs?
- From: "Jim Harrison" <Jim@xxxxxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Tue, 26 Jul 2005 08:35:21 -0700
You won't find "canned" queries, because what you write depends on what
you're looking for...
The ISA schema (I guess you mean DB organization?) is documented in the
ISA help and in the .sql scripts on the CD.
Here's an article that may get you started with osql on ISA:
http://support.microsoft.com/?id=838707
-------------------------------------------------------
Jim Harrison
MCP(NT4, W2K), A+, Network+, PCG
http://isaserver.org/Jim_Harrison/
http://isatools.org
Read the help / books / articles!
-------------------------------------------------------
-----Original Message-----
From: Craft, Steve [mailto:SCraft@xxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, July 26, 2005 06:04
To: [ISAserver.org Discussion List]
Subject: [isalist] Special SQL-Select from Logs?
http://www.ISAserver.org
With ISA 2004/EE, using the built-in log query tool is pretty slow. I'd
like to just open Query Analyzer and do my own SQL-Select statements to
get at the data. Is there a repository of canned TSQL or at least some
decently-documented schema (with examples) that I can use to build my
own queries? Digging through the Dev Kit has turned up zero for me.
Thanks.
NOTICE: This communication, including attachments, is information that
is confidential and may be privileged. It constitutes non public
information intended to be conveyed only to the designated recipient(s).
If the reader or recipient of this communication is not the intended
recipient, an employee or agent of the intended recipient who is
responsible for delivering it to the intended recipient, or if you
believe that you have received this communication in error, please
notify the sender immediately by return email and promptly erase this
email including attachments without reading or saving them in any
manner. The unauthorized use, dissemination, distribution or
reproduction of this email, including attachments, is prohibited and may
be unlawful. Receipt by anyone other than the intended recipient(s) is
not a waiver of confidentiality or privilege by the sender.
------------------------------------------------------
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
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.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.
Other related posts:
