Automatically close duplicate Events

0 Likes
over 10 years ago

This SQL stored procedure automatically closes duplicate events, leaving only the most recent one open. In order for an Event to be considered duplicate, the Job ID, Agent name, Object name and short Event message must match an existing Open or Acknowledged event.


To install this procedure, open and run it in SQL Management Studio, first ensuring the AppManager database is connected.


The stored procedure accepts one optional parameter, @CLOSE_COMMENTED_EVENTS which controls whether Events to which comments have been added will be closed or not. If not provided, a value of zero is used, which prevents commented events from being closed. To also close commented events, set the parameter to 1. For example:


exec _CloseDuplicateEvents


exec _CloseDuplicateEvents 1


The stored procedure may be scheduled to run on a regular basis via the SQL Agent.



NetIQ does not test or validate any software, code or other materials provided in, on or through NetIQ Cool Solutions (collectively, "Materials"), so please use caution when downloading or accessing any Materials from Cool Solutions and ensure that you have reasonable and current security, spyware and anti-virus measures in place on your computer and/or network prior to downloading. Additionally, do not use any Materials downloaded from Cool Solutions in any production environment without first testing the Materials to ensure they are compatible with your version of NetIQ software or any other hardware or software present in your network or environment. Cool Solutions is not a substitute for authorized NetIQ support and should not be used as such. NETIQ COOL SOLUTIONS AND ANY MATERIALS ARE PROVIDED ON AN AS-IS, AS-AVAILABLE BASIS WITHOUT ANY WARRANTY OF ANY KIND. By downloading this file, you are agreeing to these terms of use. To report a problem please contact: coolguys-netiq@netiq.com. Your use of Cool Solutions is governed by the Cool Solutions Terms and Conditions. https://www.netiq.com/communities/coolsolutions/terms-and-conditions/

Labels:

How To-Best Practice
Comment List
Anonymous
Related Discussions
Recommended