Import network computer EventLogs to SQL table

By mdenner, 2005/01/13

Total article views: 425 | Views in the last 30 days: 6

Rate this |

Join the discussion |

Briefcase

Creates the required table and stored procedure to facilitate the import of
Event Log WARNING and FAILURE entries from a target computer into a SQL using Microsoft's LogParser
for monitoring and analysis.

In order to import and analyze a number of computers' Event Logs, you should create a scheduled task
with a series of steps that each execute this procedure against a single system. Unless you want to
keep a historical archive of event log messages, you'll want to make the first step
'TRUNCATE TABLE EventLogs', so that at any time you only have the past five days' logs.

By mdenner, 2005/01/13

Total article views: 425 | Views in the last 30 days: 6

Your response

Rate this |

Join the discussion |

Briefcase

Like this? Try these...

create t-sql scripts for every jobs in Instance.

By Additional Articles

(not yet rated) | 102 reads

t-sql function to parse string data

By kmlakov

| 148 reads

Get Data/Log File Names, Sizes, Percent Utilization--ALL DBs

By John Jakob

| 160 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com