Delete network config files from the database
If you do not need to keep historical configuration files and want to improve database performance, you can automate the removal of unnecessary configuration files. If your database is not stored on a high performance database server, ensure you regularly purge unused config history.
A scheduled job automatically deletes older configs from the database. You can also delete individual jobs manually.
Customize the Default Purge Configs job
NCM includes the Default Purge Configs job, which deletes older configs from the database. By default, this job is enabled and it runs once a week to prevent the database from becoming too large. If you need to make changes to this job, SolarWinds recommends that you create a copy of the default job and change the copy. Changes to the default job cannot be reverted.
- Click My Dashboards > Network Configuration > Jobs.
- Select the Default Purge Configs job.
- Click Duplicate Job.
- Specify a unique name. For example, include the name of your organization in the job name.
Specify when the job runs:
To run the job once or on a simple schedule, select Basic. Click the tab that identifies how frequently the job runs, and then specify the start time and (if needed) the day(s).
To create a more complex schedule, select Advanced and then use the five fields to create a CRON expression.
- In the Comments box, include the reason for your changes, and then click Next.
- Select the nodes to target with this job, and click Next. By default, the job targets all nodes.
- Specify if you want to save the job log or results.
- Select an email notification option, and click Next. If you click Email Results, the default email notification and SMTP server settings are populated. These settings can be overridden in each job. By default, no email notification is sent.
- Select a Purge Configs option, and then click Next:
Purge all configs that were downloaded before this date
This option can be used if you run the job manually instead of scheduling it to run regularly.
Delete all configs EXCEPT for the last xx current configs
This option is recommended. It sets an absolute limit on the number of configs stored in the database.
Purge all configs except for the last timePeriod
This option ensures that all configs from a certain time period are stored in the database.
Review the settings for the job, and click Finish.
The job is enabled by default.
- To avoid running both your custom job and the default job, disable the default job:
- In the Jobs List, select the Default Purge Configs job.
- Click Disable.
Manually delete a config from the database
- Click My Dashboards > Network Configuration > Configuration Management.
Locate the node, and click the arrow to the left of the node name to display the list of configs from that node.
- Identify the row that contains the config you want to delete.
- In the Suggested Action column, click Delete on that row.