Home / SQLDBManager Plus Troubleshooting / Alarms and Actions / Excluding specific events from Event Log Alerts

Excluding specific events from Event Log Alerts


I would like to create an alarm for all events except for certain event with ID 'xxxx'.

Solution:
Open notepad and save an empty text file as 'EventLogExcludeList.txt' under the "..\SQLDBManagerPlus\working\conf" directory.  This file can be used to specify Event Log Exclusions :
1)  The format for the Exclusion for the events is as follows:
      EventId | Source | Category | User | EventType | Descripion
2)  The file should be present in the directory <SQLDBManagerPlus-Home>\working\conf\EventLogExcludeList.txt
3)  An example for the entries in EventLogExcludeList.txt will be as follows:('#' at the beginning of the line means the line is commented)
     #EventId | Source | Category | User | EventType | Descripion
        100|*|*|*|*|*|*|*|*|*|*
        3|*|*|*|*|*
        *|kerberos|*|*|*|*
     You can enter the event id and by using * it excludes what ever that comes in the respective fields like | Source | Category | User | EventType | Descripion etc
4)  More rules can be specified in next line as shown in the example.
5)  Save the file and restart SQLDBManagerPlus.



 RSS of this page