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 30, 2012 at 4:46 am

    #1494561

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