Cleaning up USM Maintenance Schedules
Document ID :
Last Modified Date :
Show Technical Document Details
CA Unified Infrastructure Management
UIM MAINTENANCE MODE:UIMMTM
The maintenance_mode probe does not archive expired maintenance schedules.
As a result, this may impact the user response times in UMP.
Attached is an MS SQL script containing 3 queries that can be used to help.
"Cleanup of empty schedules"
"Cleanup of maintenance schedules older than 60 days"
"Cleanup of old maintenance WINDOWS"
Anyone of these 3 queries can be run as seen fit.
It is advisable to backup the tables before running the script.
You may also change the "DELETE" to a "SELECT" before running.
Note: Be careful when cleaning up Schedules and Windows. In addition to the nas probe suppressing alarms the windows are
also used by SLA Reports, and USM graphs (graphs will display maintenance windows, shaded grey area). If reducing the
number of days to keep please check to see if these are needed for SLA's or graphs.
Note: for older installs it may be necessary to change the database name in the scripts from CA_UIM to NimsoftSLM.
Was this information helpful?