Thursday, March 29, 2012

Export event logs directly to SQL?

Hi,
I was wondering if there were a way to
Export event logs directly to SQL. Does anyone know if this is possible
using VBscript or any of the Resource Kit tools?
Thanks.This is easily done using .NET and the eventlog classes that exists in there. Requires a bit of .NET
coding, though, using your favorite language. I don't have my code here, so I don't recall the class
names etc, but reading the eventlog only requires a few lines of code.
You can do this using WMI as well, but as I'm not familiar with WMI programming I decoded to use the
.NET classes instead.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"-" <-@.-.com> wrote in message news:edlVk8r6DHA.2764@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I was wondering if there were a way to
> Export event logs directly to SQL. Does anyone know if this is possible
> using VBscript or any of the Resource Kit tools?
>
> Thanks.
>|||LOGPARSER from the IIS6 resource kit does exactly this
http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
regards
paul
"-" <-@.-.com> wrote in message news:edlVk8r6DHA.2764@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I was wondering if there were a way to
> Export event logs directly to SQL. Does anyone know if this is possible
> using VBscript or any of the Resource Kit tools?
>
> Thanks.
>

No comments:

Post a Comment