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

  • May 31, 2012 at 3:02 am

    #1495063

    Geoff A (5/30/2012)

    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)"

    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.