Wednesday, March 28, 2012

Put Windows Logs into SQL

Hi!
I am looking into a way to put Windows Logs into SQL Server database
and to be able to query them for specific information. Anybody know
the tool that I can use and be able to schedule it to run on a weekly
basis?
Thank you,
T.
tolcis,
In Windows Scripting you can use the WMI datareader to read the Event Logs
into a structured resultset. Then you can use ADO to insert the rows into a
table. I don't have any examples handy, but this link might have what you
need. If not search Google.
http://www.databasejournal.com/features/mssql/article.php/1503181
-- Bill
"tolcis" <nytollydba@.gmail.com> wrote in message
news:1172591825.527761.216540@.8g2000cwh.googlegrou ps.com...
> Hi!
> I am looking into a way to put Windows Logs into SQL Server database
> and to be able to query them for specific information. Anybody know
> the tool that I can use and be able to schedule it to run on a weekly
> basis?
> Thank you,
> T.
>

No comments:

Post a Comment