Application Delivery Management
Application Modernization & Connectivity
CyberRes
IT Operations Management
This SQL stored procedure automatically closes Events with a defined description (short Event message). To install this procedure, open and run it in SQL Management Studio, first ensuring the AppManager database is connected.
The procedure is run by executing the following command in SQL, inserting the relevant description:
exec _CloseEventsByDescription '<event description>'
Note that the description is treated as a wildcard, so %<event description>% is used. The stored procedure may be scheduled to run on a regular basis via the SQL Agent.
Update 11/17. Close Parent Event instead of Child
Update 11-Feb: Undo previous change!