How to centralize your SQL Server Event Logs.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Geoff Albin » How to centralize your SQL Server Event Logs....

64 posts, Page 7 of 7

«««3 4 5 6 7

How to centralize your SQL Server Event Logs.

Rate Topic

Display Mode

Topic Options

Author

Message

phildale

Posted Wednesday, May 30, 2012 4:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 9:37 AM
Points: 4, Visits: 92

Geoff A (5/30/2012)

Hi Phil,

Only MSSQL logs will be forwarded to the central server. That is a SQL Server Agent function.
SQL Server Agent will not forward non SQL Application log entries.

The modification to the script will work, but only on the server where the error occurs.

Thanks

Thanks for the quick reply Geoff.

I'm having a little trouble trying to grasp the concept. Maybe I'm misunderstanding SQL Server Agent's role in this.

I only want to monitor one SQL Server, and write the errors into a database on that server. In this case, all errors are occurring on that one server, the server that is monitoring for errors. But the script isn't picking up non-SQL specific errors. If the script is reading directly from wherever the Event Viewer Application log is, it shouldn't matter that the errors are not SQL specific?

Thanks

Phil

Post #1308235

Geoff A

Posted Wednesday, May 30, 2012 4:46 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:10 AM
Points: 485, Visits: 1,568

try this script instead;

query = "Select * from __InstanceCreationEvent" _
& " " & "where TargetInstance isa 'Win32_NTLogEvent'" _
& " " & "and (TargetInstance.Logfile = 'Application' or TargetInstance.Logfile = 'System')" _
& " " & "and (TargetInstance.EventType = 1 or TargetInstance.EventType = 2)"

Post #1308239

phildale

Posted Thursday, May 31, 2012 3:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 9:37 AM
Points: 4, Visits: 92

Geoff A (5/30/2012)

Thanks for that, I've given it a try but I'm having the same results.

I thought the package might have cached the script or something so I recreated it with the correct script from the beginning, and it's still ignoring non-SQL errors.

Really confusing one.

Post #1308817

adjas

Posted Monday, June 04, 2012 4:38 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 5:25 PM
Points: 42, Visits: 95

Hi,

I am testing the script on one server and it works.
However it inserts four records for the same event.
Any thoughts?

Adam

Post #1310863

« Prev Topic | Next Topic »

64 posts, Page 7 of 7

«««3 4 5 6 7

Permissions